id_client: 1 id_newsletter: 54 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '54' 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 = '54' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender webmaster@drdeanhowell.com receiver Dean Howell receiver Richard Arrandt receiver Charles Musich receiver Adam Del Torto receiver Anne Davis receiver David Weck receiver Steve Henderson receiver Terry Spence receiver James Sensenig receiver Linda R Martin receiver Lewis Arrandt receiver Alain Salas receiver Dean T Odmark receiver John Andrew receiver Alla Rubin receiver Boyer Cole receiver Doug Hayes receiver Harold Sparks receiver Howard McIllroy receiver Jeff Mersky receiver Jeff Reynolds receiver Jim McCarthy receiver Joe Swartz receiver Kurt Ehling receiver Mark Frank receiver Michael Kudlas receiver Peter Levy receiver Rodolfo Leiserson receiver Ross Hauser