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;