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 ("Q28604641","Q28604642","Q28604643","Q28604668","Q28604669","Q28604677","Q28604679","Q28604681","Q28604695","Q28604704","Q28604713","Q30615189","Q30615209","Q30615238","Q30615241","Q30615246","Q30615247","Q30615254","Q30615257","Q30615258","Q30615259","Q30615260","Q30615261","Q30615262","Q30615263","Q30615264","Q30615265","Q30615266","Q30615267","Q30615268","Q30615269","Q30615270","Q30615271","Q30615272","Q30615276","Q30615277","Q30615279","Q30615281","Q30615283","Q30615285","Q30615286","Q30615287","Q30615298","Q30615300","Q30615306","Q30615307","Q30615308","Q30615311","Q30615315","Q30615316","Q30615321","Q30615322","Q30615328","Q30615330","Q30615360","Q30615415","Q30615445","Q30615447","Q30615453","Q30615455","Q30615458","Q30615467","Q30615468","Q30615469","Q30615471","Q30615485","Q30615576","Q30615578","Q30615747","Q30615748","Q30615776","Q30615779","Q30615782","Q30615783","Q30615784","Q30615788","Q30615789","Q30615790","Q30615792","Q30615793","Q30615796","Q30615797","Q30732304") AND pl_from NOT IN ( select page_id from page where page_title in ("Q28604641","Q28604642","Q28604643","Q28604668","Q28604669","Q28604677","Q28604679","Q28604681","Q28604695","Q28604704","Q28604713","Q30615189","Q30615209","Q30615238","Q30615241","Q30615246","Q30615247","Q30615254","Q30615257","Q30615258","Q30615259","Q30615260","Q30615261","Q30615262","Q30615263","Q30615264","Q30615265","Q30615266","Q30615267","Q30615268","Q30615269","Q30615270","Q30615271","Q30615272","Q30615276","Q30615277","Q30615279","Q30615281","Q30615283","Q30615285","Q30615286","Q30615287","Q30615298","Q30615300","Q30615306","Q30615307","Q30615308","Q30615311","Q30615315","Q30615316","Q30615321","Q30615322","Q30615328","Q30615330","Q30615360","Q30615415","Q30615445","Q30615447","Q30615453","Q30615455","Q30615458","Q30615467","Q30615468","Q30615469","Q30615471","Q30615485","Q30615576","Q30615578","Q30615747","Q30615748","Q30615776","Q30615779","Q30615782","Q30615783","Q30615784","Q30615788","Q30615789","Q30615790","Q30615792","Q30615793","Q30615796","Q30615797","Q30732304") ) #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...
