Unknown column 'i.id' in 'where clause'
текст запроса:
SELECT i.*, c.`sef` cat_sef, (i.rate_sum/i.rate_count) rating, region.`title` region, city.`title` city FROM `cat_item` i, `cat_cat` c, `cat_city` city LEFT JOIN `cat_region` region ON (region.`id`=(SELECT `region_id` FROM `cat_region_city` WHERE `item_id`=i.`id`)) WHERE c.`sef`="roddoma" AND c.id=i.cat_id AND city.id=i.city_id ORDER BY i.`id` ASC LIMIT 0,10