Created
February 17, 2017 09:43
-
-
Save bi0xid/2b1659fa904353a6d38f7450ab712754 to your computer and use it in GitHub Desktop.
Get list of prestashop users with emails
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT SQL_CALC_FOUND_ROWS | |
a.`id_order`, `reference`, `total_paid_tax_incl`, `payment`, a.`date_add` AS `date_add` | |
, | |
a.id_currency, | |
a.id_order AS id_pdf, | |
CONCAT(c.`firstname`,' ', c.`lastname`) AS `customer`, | |
c.email as email, | |
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 | |
FROM `ps_orders` a | |
LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`) | |
LEFT JOIN `ps_address` address ON address.id_address = a.id_address_delivery | |
LEFT JOIN `ps_country` country ON address.id_country = country.id_country | |
LEFT 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) | |
WHERE 1 | |
ORDER BY a.`id_order` DESC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment