1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| SELECT c.customers_lastname AS Nom, c.customers_firstname AS Prenom, c.customers_email_address AS AdresseMail, c4.customers_info_date_account_created AS DateCreationCompte, o.date_purchased AS Date_Commmande, ot.value AS Montant, c5.NbCommandes
FROM orders o, orders_total ot, customers c, customers_info c4, (
SELECT COUNT( * ) AS NbCommandes, customers_id
FROM orders
GROUP BY customers_id
)c5, FULL OUTER JOIN orders o
ON o.customers_id = c.customers_id
WHERE c.customers_email_address
IN (
SELECT customers_email_address
FROM OptinSolution031208a161208
)
AND c4.customers_info_id = c.customers_id
AND c5.customers_id = c.customers_id
AND o.orders_id = ot.orders_id
AND ot.class = 'ot_total'
ORDER BY c.customers_lastname ASC |
Partager