SQL Error


Code error: 42S22.

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.company_country_code' in 'where clause' (SQL: SELECT sc.id, count(*) as total FROM users as a INNER JOIN cities as sc ON sc.id=a.city_id AND sc.active=1 WHERE a.company_country_code = :countryCode AND (a.verified_email=1 OR a.verified_phone=1) GROUP BY sc.id)