SELECT SQL_CALC_FOUND_ROWS `pp`.`id`, `pp`.`id`, `pp`.`tab`, `pp`.`quantity`, `ppl`.`title`, `ppl`.`content`, `ppl`.`short_description`, IF(`pp`.`new`='1' AND ((`pp`.`new_from`<='2012-05-17' OR `pp`.`new_from`='0000-00-00') AND (`pp`.`new_until`>='2012-05-17' OR `pp`.`new_until`='0000-00-00')), 1, 0) AS is_new, IF(`pp`.`promotion`='1' AND ((`pp`.`promotion_from`<='2012-05-17' OR `pp`.`promotion_from`='0000-00-00') AND (`pp`.`promotion_until`>='2012-05-17' OR `pp`.`promotion_until`='0000-00-00')), 1, 0) AS is_promotion, IF(`pp`.`sale`='1' AND ((`pp`.`sale_from`<='2012-05-17' OR `pp`.`sale_from`='0000-00-00') AND (`pp`.`sale_until`>='2012-05-17' OR `pp`.`sale_until`='0000-00-00')), 1, 0) AS is_sale, `ppp`.`price_taxed` AS end_price, `ppp`.`price_taxed` AS old_price, `ppp`.`price` AS netto, `pm`.`file`, `pa`.`id` AS colorId, `pa`.`color`, `pal`.`title` AS colorTitle, `pcmi`.`file` AS manufacturersLogo FROM `portal_products` AS pp INNER JOIN `portal_products_lang` AS ppl ON (`pp`.`id` = `ppl`.`id` AND `ppl`.`id_lang`='1') INNER JOIN `portal_products_categories` AS ppc ON (`ppc`.`id_product`=`pp`.`id` AND `ppc`.`id_category` IN (, 3, 5, 9)) INNER JOIN `portal_products_prices` AS ppp ON (`ppp`.`id_product`=`pp`.`id` AND `ppp`.`id_currency`='1') LEFT JOIN `portal_media` AS pm ON (`pm`.`id_object`=`pp`.`id` AND `pm`.`cat`=`pp`.`tab` AND `pm`.`main`='1') LEFT JOIN `portal_products_attributes` AS ppa ON (`ppa`.`id_product`=`pp`.`id` AND `ppa`.`id_main_attribute`='2') LEFT JOIN `portal_attributes` AS pa ON (`pa`.`id`=`ppa`.`id_attribute` AND `pa`.`show`='1') LEFT JOIN `portal_attributes_lang` AS pal ON (`pal`.`id`=`pa`.`id` AND `pal`.`id_lang`='1') LEFT JOIN `portal_categories` AS pcm ON (`pcm`.`id`=`pp`.`id_manufacturer`) LEFT JOIN `portal_media` AS pcmi ON (`pcmi`.`id_object`=`pcm`.`id` AND `pcmi`.`cat`='manufacturers') WHERE `pp`.`show`='1' AND `pp`.`tab`='products' GROUP BY `pp`.`id` ORDER BY `ppl`.`title` ASC LIMIT 0, 12

1064: 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 ' 3, 5, 9)) INNER JOIN `portal_products_prices` AS ppp ON (`ppp`.`id_product' at line 18