query = SELECT FwdEmail FROM (SELECT FwdEmail, 1 AS rank FROM clubofficeholders JOIN currentyear ON currentyear.yrid=clubofficeholders.YrID   JOIN clubofficers ON clubofficers.ClubOffID = clubofficeholders.ClubOffID AND clubofficers.ClubID IS NULL AND clubofficers.PostActive=1  JOIN clubs ON clubs.ClubID=clubofficeholders.ClubID  WHERE    (    SPLIT_STR(clubofficers.MailUser,'/',1) ='%u'      OR SPLIT_STR(clubofficers.MailUser,'/',2) = '%u'       OR SPLIT_STR(clubofficers.MailUser,'/',3) = '%u'     OR SPLIT_STR(clubofficers.MailUser,'/',4) = '%u'     OR SPLIT_STR(clubofficers.MailUser,'/',5) = '%u')  AND  clubs.Fwddomain = '%d' UNION SELECT rotarians.MemEmail AS FwdEmail, 2 AS rank FROM clubofficeholders  JOIN currentyear ON currentyear.yrid=clubofficeholders.YrID   JOIN clubofficers ON clubofficers.ClubOffID = clubofficeholders.ClubOffID AND clubofficers.ClubID IS NULL AND clubofficers.PostActive=1  JOIN clubs ON clubs.ClubID=clubofficeholders.ClubID JOIN rotarians ON rotarians.rotid = clubofficeholders.rotid  WHERE    (    SPLIT_STR(clubofficers.MailUser,'/',1) ='%u'      OR SPLIT_STR(clubofficers.MailUser,'/',2) = '%u'       OR SPLIT_STR(clubofficers.MailUser,'/',3) = '%u'     OR SPLIT_STR(clubofficers.MailUser,'/',4) = '%u'     OR SPLIT_STR(clubofficers.MailUser,'/',5) = '%u')  AND  clubs.Fwddomain = '%d'  UNION SELECT rotarians.MemEmail AS FwdEmail, 3 AS rank FROM clubofficeholders  JOIN currentyear ON currentyear.yrid=clubofficeholders.YrID   JOIN clubofficers ON clubofficers.ClubOffID = clubofficeholders.ClubOffID AND clubofficers.ClubID IS NULL AND clubofficers.PostActive=1  JOIN clubs ON clubs.ClubID=clubofficeholders.ClubID JOIN rotarians ON rotarians.rotid = clubofficeholders.rotid  WHERE    (    SPLIT_STR(clubofficers.MailUser,'/',1) ='secretary'      OR SPLIT_STR(clubofficers.MailUser,'/',2) = 'secretary'       OR SPLIT_STR(clubofficers.MailUser,'/',3) = 'secretary'     OR SPLIT_STR(clubofficers.MailUser,'/',4) = 'secretary'     OR SPLIT_STR(clubofficers.MailUser,'/',5) = 'secretary')  AND  clubs.Fwddomain = '%d' ) as Emails WHERE FwdEmail != '' AND NOT FwdEmail IS NULL ORDER BY rank ASC LIMIT 1;