1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SELECT g.increment_id AS `N° CDE` ,
i.sku AS `REF PRODUIT` ,
SUBSTRING_INDEX(i.name, '-', -1) AS `TAILLE` ,
o.value AS `N° EQUIPAGE` ,
i.name AS `NOM PRODUIT` ,
i.qty_ordered AS `QTE` ,
a.lastname AS `NOM` ,
a.firstname AS `PRENOM` ,
a.street AS `ADRESSE` ,
a.city AS `VILLE` ,
a.postcode AS `CP` ,
a.region AS `REGION` ,
a.country_id AS `PAYS` ,
a.email AS `EMAIL` ,
a.telephone AS `TELEPHONE`
FROM sales_flat_order_grid g
INNER JOIN sales_flat_order_item i ON g.entity_id = i.order_id
INNER JOIN sales_flat_order_address a ON a.parent_id = g.entity_id
INNER JOIN sales_flat_quote_item_option o ON o.item_id = i.quote_item_id
WHERE a.address_type = 'shipping' AND g.status <> 'canceled' AND i.sku LIKE '9311%' AND i.product_type = 'simple' AND o.code = 'option_2' AND g.increment_id > 100000128
ORDER BY g.increment_id DESC
LIMIT 0 , 5000 |
Partager