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