SELECT `collection_id`, `collection_name`, `trademark_name`, `multiplier`, `c_collections`.`page` AS collection_page, countries.`page` AS country_page, trademarks.`page` AS trademark_page, `c_trademarks`.`country`, `c_collections`.`options`, `c_collections`.`application`, `picture`, `size_x`, `size_y`, `order`, IF(`eurocent` <> 0, `eurocent` * `multiplier`, `price`) AS price, `units` FROM `c_collections` NATURAL JOIN `c_trademarks` JOIN `c_items` USING (`collection_id`) JOIN `c_pages` AS countries USING (country) JOIN `c_pages` AS trademarks ON (`c_collections`.`trademark_id` = trademarks.`trademark_id`) WHERE `collection_id` IN () ORDER BY `order`, `collection_name`: 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 ') ORDER BY `order`, `collection_name`' at line 1