Error Number: 1054

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

SELECT C.country_id ,C.code as country_code ,C.city_id ,C.name as city_name ,C.name_lang ,C.image as city_image ,C.latitude ,C.longitude ,U.user_idx as user_idx ,U.name as user_name ,U.profile_image ,UI.user_img_idx ,UI.image as user_image ,UI.country_id as user_country_id ,UI.city_id as user_city_id ,UI.poi_id as user_poi_id ,(SELECT count(poi_id) FROM poi WHERE city = C.city_id) as poi_count FROM city as C LEFT JOIN user_img as UI ON UI.city_id = C.city_id AND UI.poi_id = '0' AND UI.display = 'Y' LEFT JOIN user as U ON U.user_idx = UI.user_idx WHERE C.country_id = '234' AND C.is_hide = 0 GROUP BY city_id

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

Line Number: 493