id_client: 3 id_newsletter: 22 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '22' update status OK! client query text: SELECT * FROM citruspost_client WHERE id_client = '3' client query status: OK! Subscriber queyr text: (SELECT repeat('1',12) AS id_suscriber, repeat('1',100) AS name, repeat('1',100) AS email) UNION (SELECT 0 AS id_suscriber, 'Marcos Botta' AS name, 'marcos.botta@gmail.com' AS email) UNION (SELECT suscriber.id_suscriber AS id_suscriber, suscriber.name AS name, suscriber.email AS email FROM citruspost_newsletter_subscriber AS n2s, citruspost_suscriber AS suscriber WHERE suscriber.id_client = '3' AND n2s.id_newsletter = '22' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender marcos.botta@gmail.com receiver Marcos Botta receiver test receiver marcos