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