Salut, nu reusesc sa export o lista cu, clientii care sa contina
Nume, nr de telefon si tara
Am gasit un cod MySQL pe forumurile de la prestashop, dar nu contine tablele de phone, si mobile_phone.
SELECT a.`firstname`,
a.`lastname`,
a.`email`,
(SELECT c.`date_add`
FROM `ps_guest` g
LEFT JOIN `ps_connections` c ON c.`id_guest` = g.`id_guest`
WHERE g.`id_customer` = a.`id_customer`
ORDER BY c.`date_add` DESC LIMIT 1) AS `last_activity`,
(SELECT cl.`name`
FROM `ps_address` ad
LEFT JOIN `ps_country_lang` cl ON cl.`id_country` = ad.`id_country`
WHERE ad.`id_customer` = a.`id_customer`
ORDER BY ad.`id_address` DESC LIMIT 1) AS `country_name`
FROM `ps_customer` a
La acesta imi returneaza:
FirstName | Last Name | last_activity | country_name | |
---|---|---|---|---|
John | DOE | [email protected] | 4/24/2014 11:14 | United States |
Alain | dolon | [email protected] | 4/25/2014 13:08 | NULL |
Bogdan | Irimia | [email protected] | 5/5/2014 8:24 | Romania |
In loc de last activity as vrea sa fie nr de telefon, chiar si in loc de adresa de email, sa fie nr de telefon.
Multumesc,