id_client: 4 id_newsletter: 3 UPDATE citruspost_newsletter SET status = 'Newsletter Sent', datetime_sent = now() WHERE id_newsletter = '3' 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, '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 = '4' AND n2s.id_newsletter = '3' AND n2s.id_subscriber = suscriber.id_suscriber) Subscriber query result: OK! sender tetsu@visualscope.com receiver Rhonda Rose receiver Heidi Hansen receiver Eileen Schmitz receiver Jace Schmitz receiver Lynn Moreno receiver Mark Macedo receiver Niamh Prossor receiver Jeanine Cardiff receiver Daphne Eshom receiver Dave Stofferahn receiver Dixie Van Orman receiver Lisa Wyatt receiver Paul Burton receiver Larry Williams receiver Nancy Starkweather receiver Jim Rogers receiver Dick Pilling receiver JOHN GUSSMAN receiver RITA ERDMANN receiver Elizabeth Watkins receiver Tim Riley receiver Ann Fisher receiver Judy Feather receiver Patrick Dennis receiver Mike Clayton receiver Hazel Ault receiver Teri Nomura receiver Nanc Smith receiver Jan & Patty Sivertsen receiver Bill Schroepfer receiver Bryan Rodenberger receiver Paula Clark receiver Michelle Sandoval receiver Jim Graf receiver Jan Garing receiver Lil Wickenhauser receiver Robert & Carolyn Dodds receiver Jim & Bev Cone receiver Trisha Cobb receiver Barbara Bogart receiver Sherry Siegel receiver Chris Yeager receiver Mark Cooper receiver Dan Tash receiver David Sellars receiver Lorene Rittenmyer receiver Margi Normandin receiver Mike Nelson receiver Erin Nave receiver Roland Miller receiver Anita Mauger receiver Ken Laidlaw receiver Eric Hegge receiver Chuck Hazen receiver Gary Halsey receiver Don fourtner receiver Dan Erickson receiver Jim Elliott receiver Dee Dosch receiver Jan Conley receiver Patricia Brueckner receiver Bob Lynette receiver Allen Grant receiver Karen Long receiver Rhonda Rose receiver Tetsu Liew