1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
SELECT emailing_newsletter_groupe.id_groupe, emailing_newsletter_groupe.id_client, emailing_newsletter_groupe.cle_groupe, emailing_newsletter_groupe.libelle, emailing_newsletter_groupe.id_liste_mj, emailing_newsletter_client.societe,
COUNT(emailing_newsletter_abonne.id_abonne) AS nb_abonne
FROM emailing_newsletter_groupe
LEFT JOIN emailing_newsletter_client ON emailing_newsletter_client.id_client = emailing_newsletter_groupe.id_client
LEFT JOIN emailing_newsletter_abonne ON emailing_newsletter_abonne.id_client = emailing_newsletter_groupe.id_client
WHERE emailing_newsletter_groupe.id_client = '1'
AND emailing_newsletter_groupe.id_groupe = '11'
AND emailing_newsletter_abonne.id_groupe = '11'
GROUP BY emailing_newsletter_groupe.id_groupe |
Partager