SELECT `id_product_supplier` , `id_product` , `id_product_attribute` ,
       `product_supplier_reference` , COUNT( `product_supplier_reference` )
FROM `ps_product_supplier`
GROUP BY `id_product`
HAVING COUNT( `product_supplier_reference` ) >1
AND `id_product_attribute` =0
AND `product_supplier_reference` >0

SELECT `id_product_supplier` , `id_product` , `id_product_attribute` ,
       `product_supplier_reference` , COUNT( `product_supplier_reference` )
FROM `ps_product_supplier`
WHERE `id_product_attribute` =0 AND `product_supplier_reference` >0
GROUP BY `id_product`,`id_product_supplier`,`id_product_attribute`,`product_supplier_reference`
HAVING COUNT( `product_supplier_reference` ) >1