PrestaShop: Listado de productos con fabricante y marca

SELECT l.id_product, l.name, p.reference, s.name AS supplier, m.name AS manufacturer
FROM  ps_product AS p
LEFT JOIN  ps_product_lang AS l ON p.id_product = l.id_product
LefT JOIN  ps_supplier AS s ON p.id_supplier = s.id_supplier
LefT JOIN  ps_manufacturer AS m ON p.id_manufacturer = m.id_manufacturer
WHERE l.id_lang = '1';