Jump to content

SQL - Attribute ID


Recommended Posts

Bonjour à tous,

 

Si quelqu'un pouvait m'aider à ajouter l' attribute_id à la requête ci-dessous ça m'aiderait énormément à sortir des stats de ventes......

 

Merci d'avance :D

 

SELECT o.`id_order` AS `id`,
CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Customer`,
ca.`name` AS `Carrier`,
cu.`name` AS `Currency`,
o.`payment`, CONCAT(o.`total_paid_real`, ' ', cu.`sign`) AS `Total`,
o.`date_add` AS `Date`,
od.`product_id`, od.`product_name`
FROM `ps_orders` o
LEFT JOIN
`ps_customer` c ON (o.`id_customer` = c.`id_customer`)
LEFT JOIN `ps_carrier` ca ON (o.id_carrier = ca.id_carrier)
LEFT JOIN `ps_currency` cu ON (o.`id_currency` = cu.`id_currency`)
LEFT JOIN `ps_order_detail` od ON (o.`id_order` = od.`id_order`)
WHERE o.`date_add`>'2014-01-01 00:00:00'

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...