Guest User

Untitled

a guest
Sep 26th, 2011
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. (
  2.     SELECT DISTINCT t1.field1, t2.field2
  3.     FROM wedge_table1 AS t1
  4.         INNER JOIN wedge_table2 AS t2 ON (t1.field3 = t2.field4)
  5.     WHERE t1.member = 5
  6.     GROUP BY t1.field1
  7.     HAVING t1.field1 = 'test'
  8.     ORDER BY t1.member ASC
  9.     LIMIT 1, 50
  10. ) UNION ALL (
  11.     SELECT IFNULL(m.name, mem.name) AS name, mem.id_member
  12.     FROM wedge_mems AS m
  13.         INNER JOIN wedge_members AS mem ON (m.id_member = mem.id_member)
  14.     WHERE m.id_member IN (
  15.         SELECT p.id_member
  16.         FROM wedge_players AS p
  17.         WHERE p.FIELD IN ('hockey', 'cricket')
  18.     )
  19.     ORDER BY mem.id_member DESC
  20. )
Advertisement
Add Comment
Please, Sign In to add comment