syntax error: SELECT p.title_one as title_one, p.alias as alias, p.photo as photo, p.id_city as id_city, p.id_districs as id_districs, p.title_city_one as title_city_one, c.title_one as title_districs_one, p.price FROM (SELECT p.title_one as title_one, p.alias as alias, p.photo as photo, p.id_city as id_city, p.id_districs as id_districs, l.title_one as title_city_one, p.price from table_product p LEFT JOIN table_product_list l ON p.id_city = l.id WHERE p.com='project' AND p.public = 1 AND p.highlight > 0 AND p.active = 1 order by p.no, p.id desc limit 0, 4) p LEFT JOIN table_product c ON p.id_districs = c.id