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 ("Q122766409","Q122797303","Q122834177","Q123037007","Q123055598","Q123055617","Q123137520","Q123145624","Q123163071","Q123163559","Q123165970","Q123165971","Q123165972","Q123165974","Q123165975","Q123165976","Q123165977","Q123165978","Q123165979","Q123165980","Q123165981","Q123165982","Q123165983","Q123165984","Q123165985", "Q123165986","Q123165987","Q123165988","Q123165990","Q123165992","Q123165993","Q123165994","Q123165996","Q123165998","Q123165999","Q123166000","Q123166001","Q123166002","Q123166004","Q123166016","Q123166017","Q123166018","Q123166019","Q123166020","Q123166021","Q123166022","Q123166023","Q123166024","Q123166025","Q123166026", "Q123166027","Q123166028","Q123171937","Q123172546","Q123180987","Q123198848","Q123335942","Q123339523","Q123339629","Q123348330","Q123359350","Q123364727","Q123377315","Q123378187","Q123401636","Q123401703","Q123415437","Q123503522","Q123507841","Q123523412","Q123557780","Q123571424") AND pl_from NOT IN ( select page_id from page where page_title in ("Q122766409","Q122797303","Q122834177","Q123037007","Q123055598","Q123055617","Q123137520","Q123145624","Q123163071","Q123163559","Q123165970","Q123165971","Q123165972","Q123165974","Q123165975","Q123165976","Q123165977","Q123165978","Q123165979","Q123165980","Q123165981","Q123165982","Q123165983","Q123165984","Q123165985", "Q123165986","Q123165987","Q123165988","Q123165990","Q123165992","Q123165993","Q123165994","Q123165996","Q123165998","Q123165999","Q123166000","Q123166001","Q123166002","Q123166004","Q123166016","Q123166017","Q123166018","Q123166019","Q123166020","Q123166021","Q123166022","Q123166023","Q123166024","Q123166025","Q123166026", "Q123166027","Q123166028","Q123171937","Q123172546","Q123180987","Q123198848","Q123335942","Q123339523","Q123339629","Q123348330","Q123359350","Q123364727","Q123377315","Q123378187","Q123401636","Q123401703","Q123415437","Q123503522","Q123507841","Q123523412","Q123557780","Q123571424") ) #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...
