Bonjour
Merci pour votre retour, néanmoins j'ai fini pas trouvé !
Voici le requête qu'il me fallait
SELECT
ps_order_detail.product_reference AS CODE_METI,
ps_order_detail.product_ean13 AS EAN,
ps_order_detail.product_name AS NOM_PRODUIT,
COUNT(ps_order_detail.id_order) AS NB_DE_COMMANDE,
SUM(ps_order_detail.product_quantity_in_stock) AS QTE_PRODUIT_NON_LIVRE,
ps_stock_available.quantity AS STOCK,
MAX(ps_orders.date_add) AS DATE_DERNIERE_COMMANDE
FROM
ps_order_detail
INNER JOIN
ps_stock_available
ON
ps_order_detail.product_id = ps_stock_available.id_product
INNER JOIN
ps_orders
ON
ps_order_detail.id_order = ps_orders.id_order
WHERE
ps_order_detail.product_quantity = 0
GROUP BY
CODE_METI,
EAN,
NOM_PRODUIT
ORDER BY
NB_DE_COMMANDE DESC,
QTE_PRODUIT_NON_LIVRE DESC
Encore merci
Hervé