fork download
  1. -- your code goes here
  2.  
  3.  
  4. CREATE TABLE user
  5. (`id` int)
  6. ;
  7.  
  8. INSERT INTO user
  9. (`id`)
  10. VALUES
  11. (1),
  12. (2),
  13. (3),
  14. (4),
  15. (5),
  16. (6)
  17. ;
  18.  
  19.  
  20. CREATE TABLE page
  21. (`id` int)
  22. ;
  23.  
  24. INSERT INTO page
  25. (`id`)
  26. VALUES
  27. (1),
  28. (2),
  29. (3),
  30. (4),
  31. (5),
  32. (6)
  33. ;
  34.  
  35.  
  36. CREATE TABLE follows
  37. (`user_id` int, `page_id` int)
  38. ;
  39.  
  40. INSERT INTO follows
  41. (`user_id`, `page_id`)
  42. VALUES
  43. (2, 3),
  44. (3, 1),
  45. (1, 2),
  46. (1, 1),
  47. (3, 4)
  48. ;
  49.  
  50. select user.id as userid, page.id as pageid
  51. from user, page
  52. where pageid not in(select page_id from follows where user_id = userid)
Success #stdin #stdout 0s 17680KB
stdin
Standard input is empty
stdout
1|3
1|4
1|5
1|6
2|1
2|2
2|4
2|5
2|6
3|2
3|3
3|5
3|6
4|1
4|2
4|3
4|4
4|5
4|6
5|1
5|2
5|3
5|4
5|5
5|6
6|1
6|2
6|3
6|4
6|5
6|6