Error in Query on db f174638, MySql Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND published = 1' at line 41
Query: SELECT it.item_id, it.title, it.ean, it.code, it.title, it.description, it.text, cat.category_id, cat.title as category_title, subcat.subcategory_id, subcat.title as subcategory_title, it.keywords, it.price, it.price_initial, it.head, it.rank, pcat.price_category_id, pcat.name as price_category_name, pcat.title as price_category_title, pcat.description as price_category_description FROM item it LEFT JOIN item_category itmcat ON itmcat.item_id = it.item_id LEFT JOIN category cat ON cat.category_id = itmcat.category_id LEFT JOIN subcategory subcat ON subcat.subcategory_id = itmcat.subcategory_id -- --- LEFT JOIN ( SELECT MAX( subpric.price_category_id ) price_category_id, itmcat.item_id FROM item_category itmcat JOIN subcategory sub on itmcat.subcategory_id = sub.subcategory_id JOIN subcategory_pricing subpric ON sub.subcategory_id = subpric.subcategory_id GROUP BY itmcat.item_id) pricat on pricat.item_id = it.item_id -- --- LEFT JOIN price_category pcat on pricat.price_category_id = pcat.price_category_id -- --- WHERE it.item_id IN () AND published = 1