1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| SELECT d.id_demande, d.date_demande, site_wi.abreviation_site, c.nom, c.email1, statut_abonnement.statut_ab_court_anglais AS statut_news, d.status, d.source_lien, source_keyword, pays.pays_lib_anglais, c.commercial_id AS trigramme, d.num_dossier, d.tag_suivi_direction, d.type_prestation, c.category, c.cycle, d.commentaireWI AS commentaireWI, COUNT( * ) AS nb
FROM v_contact_PMA c
INNER JOIN (
SELECT contact_id, id_demande, date_demande, num_dossier, commentaireWI, tag_suivi_direction, site_source,
STATUS , source_lien, type_prestation
FROM demande d3
) 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
WHERE 1
AND c.pays = 'FR'
GROUP BY c.email1, d.id_demande
ORDER BY id_demande DESC
LIMIT 0 , 20 |
Partager