Table 'ddlx34_shop.ps4_dompromo' doesn't exist
SELECT COUNT(DISTINCT p.`id_product`) AS nb
FROM `ps4_product` p
LEFT JOIN `ps4_specific_price` sp ON (sp.`id_product` = p.`id_product`)
LEFT JOIN `ps4_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2)
LEFT JOIN `ps4_image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `ps4_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps4_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `ps4_dompromo` vf ON vf.`id_venteflash` = p.`id_product`
WHERE sp.`reduction` > 0
AND (sp.`from` <= '2013-05-25 15:56:39' AND sp.`to` >= '2013-05-25 15:56:39')
AND sp.from_quantity <= 1
AND p.`active` = 1
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `ps4_category_group` cg
LEFT JOIN `ps4_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1
) LIMIT 1