problem with SQL

[fcadena]

i have a problem with the link specials (prices_drop.php), the acces report this error:

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 'AND p.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FRO' at line 3


SELECT COUNT(DISTINCT p.`id_product`) AS nb
FROM `psz_product` p
AND p.`active` = 1
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `psz_category_group` cg
LEFT JOIN `psz_category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1

I have install the 1.2.4 version. i need help with this issue because i don´t know the correction thanks for your help

[Suthichai]

In yourshop/classes/Product.php line 1092
Replace

SELECT COUNT(DISTINCT p.`id_product`) AS nb
           FROM `'._DB_PREFIX_.'product` p
           And p.`active` = 1

With

SELECT COUNT(DISTINCT p.`id_product`) AS nb
           FROM `'._DB_PREFIX_.'product` p
           Where p.`active` = 1

Hope this help