Misplaced Pages

User:MZMcBride/Sandbox 5

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
< User:MZMcBride

This is the current revision of this page, as edited by MZMcBride (talk | contribs) at 02:51, 3 December 2015 (updated page). The present address (URL) is a permanent link to this version.

Revision as of 02:51, 3 December 2015 by MZMcBride (talk | contribs) (updated page)(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)
select distinct page_title from page join categorylinks on cl_from = page_id where cl_to = 'Wikipedia_bureaucrats' and page_namespace in (2,3) and substring_index(replace(page_title, '_', ' '), '/', 1) not in (select user_name from user join user_groups on ug_user = user_id where ug_group = 'bureaucrat');

select distinct page_title from page join categorylinks on cl_from = page_id where cl_to = 'Wikipedia_administrators' and page_namespace in (2,3) and substring_index(replace(page_title, '_', ' '), '/', 1) not in (select user_name from user join user_groups on ug_user = user_id where ug_group = 'sysop');
  1. User:Daveydweeb
  2. User:Slumgum
  3. User:Tra
  4. User:Amalas
  5. User:LAX
  6. User:Melesse
  7. User:UberScienceNerd
  8. User:Vaoverland/Administrator_role
  9. User:Stephen_Bain
  10. User:Vaoverland/aboutme
  11. User:Le_Faux_Nez_de_L'Aquatique
  12. User:L'Aquatique
  13. User:Hmwith
  14. User:Fainites
  15. User:Magister_Mathematicae
  16. User:EyeSerene
  17. User:Climie.ca
  18. User:JWSchmidt
  19. User:Jtdirl
  20. User:Davidgothberg
  21. User:Sam_Vimes
  22. User:Tkinias
  23. User:CJLL_Wright
  24. User:Jj137
  25. User:Hu12
  26. User:Hamster_Sandwich
  27. User:RyanGerbil10
  28. User:DO11.10
  29. User:Mtmelendez
  30. User:Bryan_Derksen
  31. User:David_Newton
  32. User:Pablo-flores
  33. User:FisherQueen
  34. User:Mysekurity
  35. User:Kakofonous
  36. User:Danger
  37. User:Henrik
  38. User:Jredmond
  39. User:Qaz
  40. User:Ronline
  41. User:Dsmdgold
  42. User:Shanel
  43. User:Hit_bull,_win_steak
  44. User:BirgitteSB
  45. User:Seb26
  46. User:Kilo-Lima
  47. User:Leebo
  48. User:Diberri
  49. User:Kbthompson
  50. User:Stevenfruitsmaak
  51. User:Canderson7
  52. User:Qwghlm
  53. User:ClockworkSoul
  54. User:Wifione/userboxes
  55. User:Wifione/userbox1
  56. User:Shell_Kinney/Infobox
  57. User:Dieter_Simon
  58. User:Wagino_20100516
  59. User:Tlranln999
  60. User:Paxse
  61. User:Jimsjohnson
  62. User:Hrengifo
  63. User:Kristtty
  64. User:Arjun01
  65. User:Nad808080
  66. User:Kristoffer_L
  67. User:Joseph_the_writer
  68. User:PatSunter
  69. User:VancityEditor
  70. User:Ramon_Serra
  71. User:MikeLynch
  72. User:Alliver
  73. User:Tcvella
  74. User:SausageParty77934
  75. User:TranslatorUK
  76. User:Junirullah/sandbox
  77. User:Prof.junirullah/sandbox
  78. User:Dry_Martini
  79. User:Oskar_Sigvardsson/List_of_administrators
  80. User:Jamlaw223
  81. User:Max7310
  82. User:Sonulangaya
  83. User:Reigndeleon
  84. User:Elen_of_the_Roads
  85. User:Pat.moloney
  86. User:Rocking_ramlal
  87. User:Vivekprakash92
  88. User:Gmaxwell/adminship_map
  89. User:Stewartadcock
  90. User:Kaiger
  91. User:TheElderFox
  92. User:Ronald7488
  93. User:Sivaraam07
  94. User:RaysRates
  95. User:Xbowery
  96. User:ChriCom
  97. User:Tropicalpurplekitty
  98. User:Sobek121
  99. User:Mel_Etitis/sandbox
  100. User:Loreanar
  101. User:Phiraphon
  102. User:Jiale8331
  103. User:Hyipworld
  104. User:Betsy6286
  105. User:Admiral_Alvin
  106. User:ERcheck
  107. User:Billyoweston
  108. User:Bagumbe