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