Pages with a million transclusions and their protection levels

This query is marked as a draft This query has been published by Trialpears.
SQL

SELECT concat(page_namespace,":",page_title), pr_level
FROM page JOIN page_restrictions on page.page_id = page_restrictions.pr_page
WHERE pr_type ="edit" AND page_namespace in (10,828) AND
page_title IN ("Arguments","Yesno","No globals","Namespace detect/config","Namespace detect/data","Namespace detect","Pagetype/config","Pagetype","Pagetype","Yesno","Check for unknown parameters","String","Yesno-yes","WPBannerMeta/istemplate","WPBannerMeta/class","WPBannerMeta/importance","WPBannerMeta/core","WPBannerMeta","Class mask","Class/colour","Class/icon","Class","WPBannerMeta/qualityscale","Main other","Portal","Message box","Message box/configuration","If both","Portal","Portal/styles.css","WPBannerMeta/importancescale","Importance mask","Unsubst","Redirect","Navbar","WPBannerMeta/hooks/taskforces","WPBannerMeta/hooks/taskforces/core","Reflist","Reflist/styles.css","Redirect template","Redirect template","Tl","Navbar/configuration","Importance/colour","Importance","WPBannerMeta/hooks/tfnested","Citation/CS1/styles.css","Citation/CS1/Utilities","Citation/CS1/Configuration","Citation/CS1/Whitelist","Citation/CS1","Citation/CS1/Date validation","Citation/CS1/Identifiers","Citation/CS1/COinS","TableTools","Navbar/styles.css","Short description","Template other","SDcat","SDcat","Category handler","Category handler/blacklist","Category handler/shared","Category handler/config","Category handler/data","Navbox","Cite web","Navbox/styles.css","Navbox/configuration","InfoboxImage","Infobox/styles.css","Short description/lowercasecheck","Infobox","WPBannerMeta/hooks/notecounter","Template link","WPBannerMeta/taskforce","Clear","Infobox","Template link general","WPBannerMeta/hooks/cats","WPBannerMeta/hooks/notes","WPBannerMeta/hooks/taskforces/taskforce","Category handler","Noinclude","Tfm/dated","Spaces","Navbox","Tmbox","Tlx","WPBannerMeta/hooks/bchecklist","If empty","If empty","Show button","WikiProject banner shell","Portal/images/b","Template link expanded","ResolveEntityId","WPBannerMeta/hooks/peerreview","Buffer","Asbox","Asbox","Asbox/styles.css","PAGENAMEBASE","WPBannerMeta/hooks/aclass","ClueBot NG/Warnings/FPReport","Mbox","WikiProject Biography/class","Separated entries","WikiProject Biography","Authority control","Authority control","R from move/except","R from move","WPBannerMeta/hooks/qualimpintersect","Unassessed class","WPBannerMeta/hooks/qualimpintersect/core","Yesno-no","Redirect category shell","EditAtWikidata","Ns has subpages","Ns has subpages","FULLROOTPAGENAME","EditAtWikidata","Dated maintenance category","Br separated entries","DMCA","Delink","Trim","Delink","Hatnote","Portal/images/a","Hatnote/styles.css","Find sources/config","Find sources","Find sources/links","Math","GetParameters","String2","Wd","Wd/i18n","Ambox","Cite book","Both","Portal/images/c","WPBannerMeta/note","Portal/images/s","Nowrap","Str left","Check talk wp","Replace","List","Cite news","Use dmy dates","Language/data/iana languages","Language/data/iana variants","Language/data/iana regions","Language/data/iana suppressed scripts","Language/data/iana scripts","Lang/data","Unicode data","Lang/ISO 639 synonyms","Lang","Coordinates","Coordinates/styles.css","Coord","Date","Toolbar","Plain link","WPBannerMeta/hooks/todolist","WikiProjectBannerShell","Text","Convert/text","Convert/data","Convert","Paragraph break","Format link","Check for clobbered parameters","Detect singular","WPBannerMeta/hooks/collaboration","Pb","Pluralize from text","Convert","Age","BLP","Unbulleted list","WikidataIB/nolinks","WikidataIB/titleformats","WikidataIB","Plain text","Italic title","Side box","Hatnote list","Small","Side box")
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
