1. SELECT COUNT(1)
  2. FROM impression i
  3. WHERE (
  4. geo_elements LIKE '%[[D1]]%'
  5. OR geo_elements LIKE '%[[D2]]%'
  6. ...
  7. OR geo_elements LIKE '%[[Dn]]%'
  8. )
  9. AND (
  10. industry_elements LIKE '%[[D1]]%'
  11. OR industry_elements LIKE '%[[D2]]%'
  12. ...
  13. OR industry_elements LIKE '%[[Dn]]%'
  14. )