SELECT `id_product` FROM `ps_specific_price` WHERE `id_shop` IN(0, 1) AND `id_currency` IN(0, 1) AND `id_country` IN(0, 6) AND `id_group` IN(0, 1) AND `from_quantity` = 1 AND ( (`from` = '0000-00-00 00:00:00' OR '2024-11-13 12:33:08' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-11-13 12:33:08' <= `to`) ) AND `reduction` > 0