Error Number: 1054

Unknown column 'C.is_hide' in 'on clause'

SELECT CN.country_id as idx ,CN.code ,CN.name ,CN.image as country_image ,CN.country_id ,CN.area FROM city C INNER JOIN country CN ON C.country_id = CN.country_id LEFT JOIN poi P ON C.city_id = P.city AND C.is_hide = 0 GROUP BY C.code HAVING count(C.code) > 0 AND count(P.poi_id) > 0 ORDER BY CN.area, CN.name

Filename: /var/www/project/dist/models/poi_model.php

Line Number: 38