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 ("Q32320782","Q32320783","Q32320784","Q32320785","Q32320786","Q32320787","Q32320788","Q32320789","Q9243737","Q9243738","Q9243739","Q9243740","Q9243741","Q9243742","Q9243743","Q9243744","Q9243745","Q9243746","Q9243747","Q9243748","Q9243749","Q9243750","Q9243751","Q9243752","Q9243753","Q9243754","Q9243756","Q9243758","Q9243760","Q9243763","Q9243764","Q9243765","Q9243769","Q9243770","Q9243771","Q9243774","Q9243775","Q9243779","Q9243780","Q9316641","Q9316643","Q9316645","Q9316646","Q9316648","Q9316650","Q9316651","Q9316653","Q9316655","Q9316656","Q9316657") AND pl_from NOT IN ( select page_id from page where page_title in ("Q32320782","Q32320783","Q32320784","Q32320785","Q32320786","Q32320787","Q32320788","Q32320789","Q9243737","Q9243738","Q9243739","Q9243740","Q9243741","Q9243742","Q9243743","Q9243744","Q9243745","Q9243746","Q9243747","Q9243748","Q9243749","Q9243750","Q9243751","Q9243752","Q9243753","Q9243754","Q9243756","Q9243758","Q9243760","Q9243763","Q9243764","Q9243765","Q9243769","Q9243770","Q9243771","Q9243774","Q9243775","Q9243779","Q9243780","Q9316641","Q9316643","Q9316645","Q9316646","Q9316648","Q9316650","Q9316651","Q9316653","Q9316655","Q9316656","Q9316657") ) #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...
