SELECT DISTINCT UPPER(Email),GalleryId from orders WHERE Galleryid = '' AND UPPER(Email) <> '' UNION SELECT DISTINCT UPPER(Email),GalleryId from requests WHERE Galleryid = '' AND UPPER(Email) <> '' AND Event != 0 ORDER BY `UPPER(Email)` Totals: 0 emails, 0 real emailed, 0 admin emailed, 0 skipped, 0 failed.