Edit History

Il une soluction pour ca il faudrat utilisé ANDWHERE voici un exemple de ma requete :

SELECT  o.date_add as 'order_date', o.reference as 'order_reference',  CONCAT(c.firstname,' ', c.lastname) as 'Name', c.email, a.phone, a.phone_mobile, od.product_name, od.product_reference, m.name as 'manufacturer', op.date_add as 'payment_date', op.payment_method, s.name as 'shop' 
FROM ps_orders AS o, ps_customer AS c, ps_address as a, ps_order_detail as od, ps_product as p, ps_manufacturer as m, ps_order_invoice_payment as oip, ps_order_payment as op, ps_shop as s
ANDWHERE c.id_customer = o.id_customer 
AND a.id_customer = c.id_customer
AND od.id_order = o.id_order
AND p.id_product = od.product_id
AND m.id_manufacturer = p.id_manufacturer
AND oip.id_order = o.id_order
AND op.id_order_payment= oip.id_order_payment
AND s.id_shop = o.id_shop

Prestashop inject une condition avant notre where a nous, c'est pour ca que ANDWHERE fonctionne, c'est bizarre mais c'est comme ça