id_client: 4 id_newsletter: 7 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '7' update status OK! client query text: SELECT * FROM citruspost_client WHERE id_client = '4' 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, 'Rhonda Rose' AS name, 'rhonda.rose@wamu.net' 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 = '4' AND n2s.id_newsletter = '7' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender rhonda.rose@wamu.net receiver Rhonda Rose receiver Karen Long receiver Rhonda Rose receiver Tetsu Liew