Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- r.id,
- r.ulogin
- FROM requestbase r
- JOIN
- ipdistr d
- ON
- d.request = r.id
- WHERE
- EXISTS (
- SELECT 1
- FROM
- tvls t
- WHERE
- t.id = r.id
- )
- AND
- EXISTS (
- SELECT 1
- FROM
- iptvnew i
- WHERE
- i.request = r.id
- )
- GROUP BY
- r.id
- HAVING
- COUNT(d.request) > 2
Advertisement
Add Comment
Please, Sign In to add comment