Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.33 KB | None | 0 0
  1. SELECT * FROM user_prof WHERE
  2. gender = 0
  3. AND user_id IN (
  4.     SELECT following_id FROM followers
  5.         WHERE follower_id in (
  6.         SELECT user_id FROM user_prof WHERE gender = 1)
  7.         )
  8. AND user_id NOT IN (
  9.     SELECT following_id FROM followers
  10.         WHERE follower_id IN (
  11.         SELECT user_id FROM user_prof where gender = 0)
  12.     );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement