SELECT * FROM (SELECT a.REFNO AS REFNO, a.MODSTATUS AS MODSTATUS, a.MODEL AS MODEL, a.FURNACEMODEL AS FURNACEMODEL, a.COILMODEL AS COILMODEL, a.MFR1 AS MFR1, a.TRADENAME AS TRADENAME, a.ARITYPE AS ARITYPE, a.HSVTC AS HSVTC, c.PHASE AS PHASE, a.CAN_OR_EXPORT AS CAN_OR_EXPORT, a.SEER AS SEER, a.EER AS EER, a.CAPACITY AS CAPACITY
FROM ac_input_NEW AS a
INNER JOIN cond_evap AS c ON a.MFR1 = c.MFR1
AND a.MODEL = c.MODEL
WHERE a.modstatus != "Draft"
AND a.modstatus != "deleted") AS t1
,
(SELECT f.REFNO AS REFNO, f.MODSTATUS AS MODSTATUS, f.MODELNUMBER AS MODEL, f.MODELNUMBER3 AS FURNACEMODEL, f.MODELNUMBER2 AS COILMODEL, f.MFR1 AS MFR1, f.TRADENAME AS TRADENAME, d.ARITYPE AS ARITYPE, d.HSVTC AS HSVTC, e.PHASE AS PHASE, d.CAN_OR_EXPORT AS CAN_OR_EXPORT, d.SEER AS SEER, d.EER AS EER, d.CAPACITY AS CAPACITY
FROM ac_input_NEW AS d
INNER JOIN cond_evap AS e ON d.MFR1 = e.MFR1
AND d.MODEL = e.MODEL
RIGHT JOIN ac_input_pbms AS f ON f.OWNER = d.REFNO
WHERE e.modstatus != "Draft"
AND e.modstatus != "deleted") AS t2 LIMIT 100