id_client: 1 id_newsletter: 19 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '19' update status OK! client query text: SELECT * FROM citruspost_client WHERE id_client = '1' client query status: OK! Subscriber queyr text: (SELECT 0 AS id_suscriber, 'Tetsu Liew' AS name, 'tetsu@visualscope.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 = '1' AND n2s.id_newsletter = '19' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender tetsu@visualscope.com receiver Tetsu Liew receiver agregado1 receiver agregado1 receiver agregado1 receiver agregado1