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
XXN
.
#4802
Toggle Highlighting
SQL
use enwiki_p; select concat('* ',count(l.ll_lang),' [[',p.page_title,']]') #concat('* ',count(l.ll_lang),'// [[:en:',p.page_title,']]') #p.page_title, count(l.ll_lang) from langlinks l join page p on p.page_id=l.ll_from where p.page_namespace=0 and p.page_title in (select pla.page_title from categorylinks cla join page pla on cla.cl_from=pla.page_id# and cla.tl_from_ #where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to in ("Military_memorials_and_cemeteries_task_force_articles", "Fortifications_task_force_articles")) where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="WikiProject_Russia_articles") and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ro") #and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en") group by l.ll_from #having count(l.ll_lang)>20 order by count(l.ll_lang) desc limit 500; /* select p.page_title, lfr.ll_title from plwiki_p.page p join plwiki_p.langlinks lfr on p.page_id=lfr.ll_from and p.page_namespace=0 and lfr.ll_lang="ro" join plwiki_p.categorylinks cfr on cfr.cl_from=p.page_id and cfr.cl_to = "Planetoidy_pasa_głównego" */
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...