Query products in order

[italofares]

Hi, this query displays the products of orders , I would also add the EAN13 code. can someone help me? thank you
Italo 
PrestaShop™ 1.6.0.14 -  0.274s

 

SELECT d.id_order, os.name AS state, d.product_name, d.product_reference, d.product_quantity, CONCAT_WS(' ', g.firstname, g.lastname) AS customer

    FROM ps_order_detail d

    LEFT JOIN ps_orders o ON (d.id_order= o.id_order)

    LEFT JOIN ps_customer g ON (o.id_customer = g.id_customer)

    LEFT JOIN ps_group_lang gl ON (g.id_default_group = gl.id_group) AND gl.name LIKE 'club%'

    LEFT JOIN ps_order_state_lang os ON (o.current_state = os.id_order_state)

    WHERE os.id_lang = 1 and o.current_state=2 

 

 

 

 

 

 

 

 

Hi, this xxxx displays the products of orders , I would also add the EAN13 code. can someone help me? thank you