-
SELECT COUNT(1)
-
FROM impression i
-
WHERE (
-
geo_elements LIKE '%[[D1]]%'
-
OR geo_elements LIKE '%[[D2]]%'
-
...
-
OR geo_elements LIKE '%[[Dn]]%'
-
)
-
AND (
-
industry_elements LIKE '%[[D1]]%'
-
OR industry_elements LIKE '%[[D2]]%'
-
...
-
OR industry_elements LIKE '%[[Dn]]%'
-
)