FROM " . DB_PREFIX . "product_to_category ptc LEFT JOIN . DB_PREFIX . "category_description"FROM oc_product_to_category ptcoc_category_descriptionLEFT JOIN oc_?
SELECT LAST_INSERT_ID()?
SELECT DISTINCT `c`.`id`
FROM `Category` AS `c`
LEFT JOIN (
SELECT DISTINCT `c1`.`id` AS `id`
FROM `Category` AS `c1`
LEFT JOIN `Special` AS `s1` ON `s1`.`Product_id` = `c1`.`Product_id`
WHERE `s1`.`Product_id` IS NULL
) AS `s` ON `s`.`id` = `c`.`id`
WHERE `s`.`id` IS NULL