Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mahir256
.
Toggle Highlighting
SQL
SELECT DISTINCT pl_title#, COUNT(*) FROM pagelinks LEFT JOIN page ON pl_title = page_title AND pl_namespace = page_namespace WHERE pl_from_namespace IN (0, 120, 146) AND pl_namespace IN (0, 120, 146) AND pl_title in ("Q105525587","Q25038004","Q25059938","Q25059944","Q25059945","Q25059946","Q25059947","Q25059948","Q25059950","Q25059952","Q25059954","Q25059955","Q25059956","Q25059958","Q25059964","Q25059965","Q25060032","Q25060033","Q25060034","Q25060036","Q25060041","Q25060045","Q25060049","Q25060051","Q25066050","Q25066051","Q25066052","Q25066053","Q25066054","Q25066055","Q25066056","Q25066057","Q25066058","Q25066059","Q25066060","Q25066063","Q25066064","Q25066065","Q25066066","Q25066068","Q25066069","Q25066231") AND pl_from NOT IN ( select page_id from page where page_title in ("Q105525587","Q25038004","Q25059938","Q25059944","Q25059945","Q25059946","Q25059947","Q25059948","Q25059950","Q25059952","Q25059954","Q25059955","Q25059956","Q25059958","Q25059964","Q25059965","Q25060032","Q25060033","Q25060034","Q25060036","Q25060041","Q25060045","Q25060049","Q25060051","Q25066050","Q25066051","Q25066052","Q25066053","Q25066054","Q25066055","Q25066056","Q25066057","Q25066058","Q25066059","Q25066060","Q25066063","Q25066064","Q25066065","Q25066066","Q25066068","Q25066069","Q25066231") ) #GROUP BY pl_title #ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
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
.
Checking query status...
