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 40<br>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 '0' = '0' AND '73' = 0
                                                THEN 1=1
                                            WHEN '0' = '0' 
                                                THEN itmcat.category_id = '73' 
                                            ELSE itmcat.subcategory_id = '0' 
                                        END
                                   ))
                              AND `published` = 1 AND
                                    `language_id` = '1'
                                    
                              ORDER BY `rank` desc, itm.item_id desc
                              LIMIT 12 OFFSET -12<br>