SELECT ps_product_lang.name, ps_product.id_product, ps_product.id_manufacturer, ps_product.active 
FROM ps_product INNER JOIN ps_product_lang 
ON ps_product.id_product = ps_product_lang.id_product 
WHERE ps_product.id_manufacturer = 0 
GROUP BY ps_product.id_product;