Ma cosa ottieni se fondi le due query ed usi:
codice:
SELECT P.reference as Code, PL.`name` as Product_Name, COUNT(OD.id_order) as ordered_qty, o.`id_order` as 'order id' ,ad.`city` as 'Delivery_Address'
FROM ps_product P
LEFT JOIN ps_product_lang PL ON P.id_product = PL.id_product
LEFT JOIN ps_order_detail OD ON P.id_product = OD.product_id
LEFT JOIN ps_orders O ON O.id_order = OD.id_order
join `ps_customer` cs on o.`id_customer`=cs.`id_customer`
join `ps_address` ad on o.`id_address_delivery`=ad.`id_address`
WHERE O.valid = 1
order by ad.city