id_client: 10 id_newsletter: 12 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '12' update status OK! client query text: SELECT * FROM citruspost_client WHERE id_client = '10' client query status: OK! Subscriber queyr text: (SELECT 0 AS id_suscriber, 'Anibal Alegre' AS name, 'webmaster@anibalsite.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 = '10' AND n2s.id_newsletter = '12' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender webmaster@anibalsite.com receiver Anibal Alegre receiver Anibal