select DISTINCT(t.sysid) as sysid, t.1, t.144,t.167,t.881,t.922,t.924,Zip,bd,bh, t.137, tp, numpics, t.246,t.157 from (SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, `25` as bd,`92` as bh, `137`, `276` as tp, numpics, `246`,`157` FROM RE1 WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip,`25` as bd,`92` as bh, `137`, `370` as tp, numpics, `246`,`157` FROM RE2 WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, 0 as bd, 0 as bh, `137`, `1` as tp, numpics, `246`,`157` FROM RLD WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' UNION ALL SELECT sysid, `1`, `144`,`167`,`881`,`922`,`924`,`10` as Zip, 0 as bd, 0 as bh, `137`, `1` as tp, numpics, `246`,`157` FROM RIN WHERE sysid != 343645459 AND numpics>0 AND `137`>0 AND CONCAT(`922`,',',`924`) LIKE '%Miami%' ) as t ORDER BY sysid DESC