1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT d.id_demande, d.date_demande, site_wi.abreviation_site,
c.nom, c.email1, statut_abonnement.statut_ab_court_anglais AS statut_news,
pays.pays_lib_anglais, c.commercial_id AS trigramme, d.num_dossier, c.category,
c.cycle, d.commentaire AS commentaire,COUNT(*) AS nb FROM
((((((contact c
INNER JOIN ( SELECT contact_id, id_demande, date_demande, num_dossier, commentaireWI,site_source, status
FROM demande d3 ORDER BY d3.id_demande DESC LIMIT 0,20) AS d ON d.contact_id = c.id_contact)
INNER JOIN contact c2 ON c.email1 = c2.email1)
INNER JOIN demande d2 ON d2.contact_id = c2.id_contact)
LEFT JOIN commercial ON c.commercial_id = commercial.id_commercial)
LEFT JOIN pays ON c.pays = pays.id_pays )
LEFT JOIN site_wi ON d.site_source=site_wi.site_wi )
LEFT JOIN statut_abonnement ON c.statut_abonnement_id = statut_abonnement.id_statut_abonnement
GROUP BY c.email1, d.id_demande ORDER BY id_demande DESC |
Partager