dkanavis

Untitled

Apr 25th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  1. SELECT
  2.     r.id,
  3.     r.ulogin
  4. FROM requestbase r
  5. JOIN
  6.     ipdistr d
  7. ON
  8.     d.request = r.id
  9. WHERE
  10.     EXISTS (
  11.         SELECT 1
  12.         FROM
  13.             tvls t
  14.         WHERE
  15.             t.id = r.id
  16.     )
  17. AND
  18.     EXISTS (
  19.         SELECT 1
  20.         FROM
  21.             iptvnew i
  22.         WHERE
  23.             i.request = r.id
  24.     )
  25. GROUP BY
  26.     r.id
  27. HAVING
  28.     COUNT(d.request) > 2
Advertisement
Add Comment
Please, Sign In to add comment