SeaXtreme

Account

E-mail address

Password


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 `ps_product` p
			AND p.`active` = 1
			AND p.`id_product` IN (
				SELECT cp.`id_product`
				FROM `ps_category_group` cg
				LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`)
				WHERE cg.`id_group` = 1
			)