Unknown column 'I.id' in 'where clause'
текст запроса:
SELECT I.*, C.`sef` cat_sef, (I.`rate_sum`/I.`rate_count`) rating ,CITY.`title` city ,REGION.`id` region_id, REGION.`title` region FROM `cat_city` CITY ,`cat_item` I ,`cat_cat` C LEFT JOIN `cat_region` REGION ON (REGION.`id`= (SELECT `region_id` FROM `cat_region_city` RC WHERE RC.`item_id`=I.`id`)) WHERE CITY.`id`=I.`city_id` AND I.`cat_id`=C.`id` AND I.`cat_id`=C.`id` AND I.`sef`="saratov_-oblastnojj_perinatalnyjj_centr_molochka"