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 ("Q28417189","Q28837463","Q30629756","Q30629956","Q47211932","Q48676841","Q48678308","Q48679024","Q48680257","Q48680258","Q55588076","Q55588142","Q55588171","Q55588195","Q55588217","Q55588292","Q55589556","Q61005326","Q61007777","Q61008111","Q61008113","Q65060591","Q65061545","Q65646245","Q65648357","Q65648358","Q65648359","Q65766042","Q65786725","Q86262806","Q86273883","Q86274336","Q86277047","Q86279617","Q86279717","Q86280133","Q86280186","Q86280956","Q86286999","Q86290628","Q86290633","Q86300289","Q86307991","Q86308073","Q86322658","Q86325648","Q86329614","Q86329660","Q86329702","Q86329753","Q86329797","Q86330824","Q86338880","Q86338914","Q97384904","Q97384957","Q97385001","Q97385003","Q97385144","Q97385221","Q97385282","Q97385283","Q97385350","Q97385402","Q97385485","Q97386980","Q97386984") AND pl_from NOT IN ( select page_id from page where page_title in ("Q28417189","Q28837463","Q30629756","Q30629956","Q47211932","Q48676841","Q48678308","Q48679024","Q48680257","Q48680258","Q55588076","Q55588142","Q55588171","Q55588195","Q55588217","Q55588292","Q55589556","Q61005326","Q61007777","Q61008111","Q61008113","Q65060591","Q65061545","Q65646245","Q65648357","Q65648358","Q65648359","Q65766042","Q65786725","Q86262806","Q86273883","Q86274336","Q86277047","Q86279617","Q86279717","Q86280133","Q86280186","Q86280956","Q86286999","Q86290628","Q86290633","Q86300289","Q86307991","Q86308073","Q86322658","Q86325648","Q86329614","Q86329660","Q86329702","Q86329753","Q86329797","Q86330824","Q86338880","Q86338914","Q97384904","Q97384957","Q97385001","Q97385003","Q97385144","Q97385221","Q97385282","Q97385283","Q97385350","Q97385402","Q97385485","Q97386980","Q97386984") ) #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...
