Query for best-selling products

[Guest locen]

Hi,

I would write a query that shows the products and quantities sold grouped by countries.

I tried several times but results are not correct

 

Please help me

Thanks in advance

 

Edited May 10, 2016 by locen (see edit history)

[Guest locen]

Hi, i solved in part this problem: 

 I made this query:

 SELECT o.reference,  pl.name as product_name, pc.name AS city, od.product_quantity, cs.firstname, cs.lastname, DATE(o.date_add) AS data_acq, ROUND (od.total_price_tax_incl, 3) AS price_with_tax,  cu.name AS curr, o.total_discounts_tax_excl, pt.rate AS tax_value_percent, od.product_reference

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

LEFT JOIN ps_currency cu ON cu.id_currency = o.id_currency

JOIN ps_order_detail_tax dt ON od.id_order_detail = dt.id_order_detail

JOIN ps_tax pt ON pt.id_tax = dt.id_tax

JOIN ps_customer cs on o.id_customer=cs.id_customer

JOIN ps_address ad on o.id_address_delivery=ad.id_address

JOIN ps_country_lang pc on ad.id_country=pc.id_country

 JOIN ps_country_lang ps on pl.id_lang=pc.id_lang

WHERE  o.current_state = 2 OR o.current_state =  3 OR o.current_state = 4 OR o.current_state = 5 OR o.current_state = 9 OR o.current_state = 12 OR o.current_state = 13 OR o.current_state = 16 

 

 

GROUP BY od.id_order_detail

ORDER BY o.date_add;

 

 

But I have problem with prices. when I export file i have price number with a lot of decimals.

can someone help me?