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 '-12' at line 34
Query: SELECT itm.item_id, itm.title, itm.head, itm.price, itm.price_initial, pcat.price_category_id, pcat.name as price_category_name, pcat.title as price_category_title, pcat.description as price_category_description FROM item itm 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 = itm.item_id LEFT JOIN price_category pcat ON pricat.price_category_id = pcat.price_category_id WHERE itm.item_id IN ( SELECT itmcat.item_id FROM item_category itmcat WHERE (CASE WHEN '492' = '0' AND '73' = 0 THEN 1=1 WHEN '492' = '0' THEN itmcat.category_id = '73' ELSE itmcat.subcategory_id = '492' END) ) AND published = 1 AND language_id = '2' ORDER BY itm.rank DESC, itm.item_id DESC LIMIT 12 OFFSET -12