Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (
- SELECT DISTINCT t1.field1, t2.field2
- FROM wedge_table1 AS t1
- INNER JOIN wedge_table2 AS t2 ON (t1.field3 = t2.field4)
- WHERE t1.member = 5
- 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
- )
Advertisement
Add Comment
Please, Sign In to add comment