WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:40:03] [Envoi massif Hotel] 0 business(es) éligible(s) trouvé(es).
[2026-08-13 13:40:03] [Envoi massif Hotel] Rien à envoyer.
[2026-08-13 13:45:01] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:45:01] Limite globale : 270 | Envoyés aujourd'hui : 0
[2026-08-13 13:45:01] 🗄️ Requête: SELECT ec.*, et.subject AS tpl_subject, et.body AS tpl_body, et.category AS tpl_category FROM email_campaigns ec JOIN email_templates et ON ec.template_id = et.id WHERE ec.is_active = 1
[2026-08-13 13:45:01] 2 campagne(s) active(s) trouvée(s).
[2026-08-13 13:45:01] [Envoi massif restaurant] Traitement en cours...
[2026-08-13 13:45:01] [Envoi massif restaurant] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:45:01] [Envoi massif restaurant] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:45:01] [Envoi massif restaurant] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails IS NOT NULL AND b.emails != '' AND b.emails != 'none' AND b.category = 'restaurant' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:45:02] [Envoi massif restaurant] 3 business(es) éligible(s) trouvé(es).
[2026-08-13 13:45:02] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #26712: your@email
[2026-08-13 13:45:02] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #37775: contact{at}restaurant-umami{dot}com
[2026-08-13 13:45:02] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #31802: your@email
[2026-08-13 13:45:02] [Envoi massif restaurant] ✅ Résultat: 0 envoyé(s), 0 échec(s).
[2026-08-13 13:45:02] [Envoi massif Hotel] Traitement en cours...
[2026-08-13 13:45:02] [Envoi massif Hotel] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:45:02] [Envoi massif Hotel] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:45:02] [Envoi massif Hotel] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails IS NOT NULL AND b.emails != '' AND b.emails != 'none' AND b.category = 'Hôtel' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:45:03] [Envoi massif Hotel] 0 business(es) éligible(s) trouvé(es).
[2026-08-13 13:45:03] [Envoi massif Hotel] Rien à envoyer.
[2026-08-13 13:50:02] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:50:02] Limite globale : 270 | Envoyés aujourd'hui : 0
[2026-08-13 13:50:02] 🗄️ Requête: SELECT ec.*, et.subject AS tpl_subject, et.body AS tpl_body, et.category AS tpl_category FROM email_campaigns ec JOIN email_templates et ON ec.template_id = et.id WHERE ec.is_active = 1
[2026-08-13 13:50:02] 2 campagne(s) active(s) trouvée(s).
[2026-08-13 13:50:02] [Envoi massif restaurant] Traitement en cours...
[2026-08-13 13:50:02] [Envoi massif restaurant] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:50:02] [Envoi massif restaurant] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:50:02] [Envoi massif restaurant] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails IS NOT NULL AND b.emails != '' AND b.emails != 'none' AND b.category = 'restaurant' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:50:03] [Envoi massif restaurant] 3 business(es) éligible(s) trouvé(es).
[2026-08-13 13:50:03] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #26712: your@email
[2026-08-13 13:50:03] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #35757: c%6f%6e%74a%63t@l%75%6cur%6fuget%2efr
[2026-08-13 13:50:03] [Envoi massif restaurant] ⚠️ Aucun email valide pour business #6280: contact@latableôchef.fr
[2026-08-13 13:50:03] [Envoi massif restaurant] ✅ Résultat: 0 envoyé(s), 0 échec(s).
[2026-08-13 13:50:03] [Envoi massif Hotel] Traitement en cours...
[2026-08-13 13:50:03] [Envoi massif Hotel] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:50:03] [Envoi massif Hotel] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:50:03] [Envoi massif Hotel] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails IS NOT NULL AND b.emails != '' AND b.emails != 'none' AND b.category = 'Hôtel' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:50:03] [Envoi massif Hotel] 0 business(es) éligible(s) trouvé(es).
[2026-08-13 13:50:03] [Envoi massif Hotel] Rien à envoyer.
[2026-08-13 13:55:01] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:55:01] Limite globale : 270 | Envoyés aujourd'hui : 0
[2026-08-13 13:55:01] 🗄️ Requête: SELECT ec.*, et.subject AS tpl_subject, et.body AS tpl_body, et.category AS tpl_category FROM email_campaigns ec JOIN email_templates et ON ec.template_id = et.id WHERE ec.is_active = 1
[2026-08-13 13:55:01] 2 campagne(s) active(s) trouvée(s).
[2026-08-13 13:55:01] [Envoi massif restaurant] Traitement en cours...
[2026-08-13 13:55:01] [Envoi massif restaurant] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:55:01] [Envoi massif restaurant] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:55:01] [Envoi massif restaurant] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails_clean IS NOT NULL AND b.emails_clean != '' AND b.category = 'restaurant' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:55:02] [Envoi massif restaurant] 0 business(es) éligible(s) trouvé(es).
[2026-08-13 13:55:02] [Envoi massif restaurant] Rien à envoyer.
[2026-08-13 13:55:02] [Envoi massif Hotel] Traitement en cours...
[2026-08-13 13:55:02] [Envoi massif Hotel] 🔍 Exclusion basée sur la catégorie template: 'premier_contact'
[2026-08-13 13:55:02] [Envoi massif Hotel] 🗄️ Requête: SELECT COUNT(*) FROM email_sends WHERE DATE(sent_at) = CURRENT_DATE AND status != 'failed'
[2026-08-13 13:55:02] [Envoi massif Hotel] 🗄️ Requête ciblages (copiable): SELECT b.* FROM business b WHERE b.emails_clean IS NOT NULL AND b.emails_clean != '' AND b.category = 'Hôtel' AND b.id NOT IN (
SELECT es.business_id
FROM email_sends es
JOIN email_templates et ON es.template_id = et.id
WHERE et.category = 'premier_contact'
) ORDER BY RAND() LIMIT 3
[2026-08-13 13:55:02] [Envoi massif Hotel] 0 business(es) éligible(s) trouvé(es).
[2026-08-13 13:55:02] [Envoi massif Hotel] Rien à envoyer.