SELECT u.*, i.stat, i.inv_id AS invid
FROM (
    SELECT fm.mem_id, fm.photo, fm.fname, fm.lname, fm.email, fm.profilenam, fm.birthday, fm.phone, fm.sn_flag
    FROM future_members fm
    JOIN network n ON fm.mem_id = n.frd_id
    WHERE n.mem_id = 48
        AND fm.verified = 'y'
        AND fm.deleted = 'N'
        AND profile_type != 'C'
        AND fm.updated_by = 48
) UNION (
    SELECT fm.id, m.photo, fm.name, fm.lname, fm.email, fm.profilenm, fm.birthday, fm.phone, fm.sn_flag
    FROM `future_members` AS fm
    JOIN `members` m ON m.mem_id = fm.addedby
    WHERE fm.addedby = 48
) u
LEFT JOIN invite i ON i.email = u.email AND i.mem_id = 48
ORDER BY TRIM(u.lname) ASC
LIMIT 0, 20