(
    SELECT DISTINCT t1.field1, t2.field2
    FROM wedge_table1 AS t1
        INNER JOIN wedge_table2 AS t2 ON (t1.field3 = t2.field4)
        INNER JOIN wedge_table4 AS t4 ON (t4.field7 = t2.field7)
        LEFT JOIN wedge_table3 AS t3 ON (t3.mem = t2.mem)
    WHERE t1.member = 5 AND (t2.field6 = 0 OR t3.field6 = 0)
    GROUP BY t1.field1
    HAVING t1.field1 = 'test'
    ORDER BY t1.member ASC
    LIMIT 1, 50
) UNION ALL (
    SELECT IFNULL(m.name, mem.name) AS name, mem.id_member
    FROM wedge_mems AS m
        INNER JOIN wedge_members AS mem ON (m.id_member = mem.id_member)
    WHERE m.id_member IN (
        SELECT p.id_member
        FROM wedge_players AS p
        WHERE p.FIELD IN ('hockey', 'cricket')
    )
    ORDER BY mem.id_member DESC
)