SELECT * FROM products_providers WHERE product_id IN ( SELECT product_id FROM products_providers GROUP BY product_id HAVING COUNT(product_id) >1) ;