1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| SELECT
SQL_CALC_FOUND_ROWS
a.`id_order`,
address.`company`,
address.`firstname`,
address.`lastname`,
address.`address1`,
address.`address2`,
address.`postcode`,
address.`city`,
address.`phone`,
address.`phone_mobile`,
c.`id_customer`,
c.`email`,
c.`siret`,
c.`id_gender`,
c.`birthday`,
c.`newsletter`,
c.`active` `total_paid_tax_incl`,
`total_paid_real`, `payment`,
a.`date_add`
AS `date_add` , a.id_currency, a.id_order
AS id_pdf, osl.`name` AS `osname`, os.`color`,
IF((SELECT so.id_order FROM `ps_orders` so WHERE so.id_customer = a.id_customer AND so.id_order < a.id_order LIMIT 1) > 0, 0, 1)
as new, country_lang.name as cname, IF(a.valid, 1, 0) badge_success, shop.name as shop_name
FROM `ps_orders` a LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
INNER JOIN `ps_address` address ON address.id_address = a.id_address_delivery
INNER JOIN `ps_country` country ON address.id_country = country.id_country
INNER JOIN `ps_country_lang` country_lang ON (country.`id_country` = country_lang.`id_country` AND country_lang.`id_lang` = 1)
LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1)
LEFT JOIN `ps_shop` shop ON a.`id_shop` = shop.`id_shop` WHERE 1 AND a.id_shop IN (1)
ORDER BY a.id_order DESC |