Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
جام
by
لوقا
This query is marked as a draft
This query has been published
by
لوقا
.
Toggle Highlighting
SQL
#id #select category.cat_id from category where category.cat_title = replace("Connecticut politician stubs"," ","_"); #select langlinks.ll_title as page_title select count(categorylinks.cl_to) as c,categorylinks.cl_to from categorylinks inner join langlinks on langlinks.ll_from = categorylinks.cl_from where categorylinks.cl_to in ( "American_mayor_stubs","Midwestern_United_States_mayor_stubs","Michigan_mayor_stubs","Ohio_mayor_stubs","Wisconsin_mayor_stubs","Northeastern_United_States_mayor_stubs","Massachusetts_mayor_stubs","New_Jersey_mayor_stubs","New_York_(state)_mayor_stubs","Pennsylvania_mayor_stubs","Southern_United_States_mayor_stubs","Georgia_(U.S._state)_mayor_stubs","Virginia_mayor_stubs","Western_United_States_mayor_stubs","California_mayor_stubs","American_politician_book_stubs","Alabama_politician_stubs","Alaska_politician_stubs","Arizona_politician_stubs","Arkansas_politician_stubs","California_politician_stubs","California_State_Senator_stubs","California_State_Assembly_Member_stubs","California_United_States_Representative_stubs","Colorado_politician_stubs","Connecticut_politician_stubs","Washington,_D.C._politician_stubs","Delaware_politician_stubs","Florida_politician_stubs","Georgia_(U.S._state)_politician_stubs","Hawaii_politician_stubs","Idaho_politician_stubs","Illinois_politician_stubs","Members_of_the_Illinois_House_of_Representatives_stubs","Illinois_state_senator_stubs","Indiana_politician_stubs","Iowa_politician_stubs","Kansas_politician_stubs","Kentucky_politician_stubs","Louisiana_politician_stubs","Maine_politician_stubs","Maryland_politician_stubs","Massachusetts_politician_stubs","Massachusetts_State_House_of_Representatives_stubs","Massachusetts_State_Senator_stubs","Massachusetts_United_States_Representative_stubs","Michigan_politician_stubs","Michigan_mayor_stubs","Minnesota_politician_stubs","Mississippi_politician_stubs","Missouri_politician_stubs","Montana_politician_stubs","Nebraska_politician_stubs","Nevada_politician_stubs","New_Hampshire_politician_stubs","New_Jersey_politician_stubs","New_Jersey_mayor_stubs","New_Mexico_politician_stubs","New_York_(state)_politician_stubs","New_York_(state)_mayor_stubs","New_York_State_Senator_stubs","Member_of_the_New_York_State_Assembly_stubs","New_York_(state)_United_States_Representative_stubs","North_Carolina_politician_stubs","North_Dakota_politician_stubs","Ohio_politician_stubs","Ohio_mayor_stubs","Ohio_State_House_of_Representatives_stubs","Ohio_State_Senator_stubs","Ohio_United_States_Representative_stubs","Oklahoma_politician_stubs","Oregon_politician_stubs","Pennsylvania_politician_stubs","Pennsylvania_mayor_stubs","Pennsylvania_State_House_of_Representatives_stubs","Pennsylvania_State_Senator_stubs","Pennsylvania_United_States_Representative_stubs","Rhode_Island_politician_stubs","South_Carolina_politician_stubs","South_Dakota_politician_stubs","Tennessee_politician_stubs","Texas_politician_stubs","Utah_politician_stubs","Vermont_politician_stubs","Virginia_politician_stubs","Virginia_mayor_stubs","Virginia_Delegate_stubs","Virginia_United_States_Representative_stubs","Virginia_State_Senator_stubs","Washington_(state)_politician_stubs","West_Virginia_politician_stubs","Wisconsin_politician_stubs","Wisconsin_mayor_stubs","Wisconsin_State_Senator_stubs","Member_of_the_Wisconsin_State_Assembly_stubs","Democratic_party_member_of_the_Wisconsin_State_Assembly_stubs","Progressive_party_(1924)_member_of_the_Wisconsin_State_Assembly_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,1820s_births_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,_1830s_births_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,1840s_births_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,1850s_births_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,1860s_births_stubs","Republican_party_member_of_the_Wisconsin_State_Assembly,1870s_births_stubs","Wisconsin_United_States_Representative_stubs","Wyoming_politician_stubs","Native_American_politician_stubs" ) and categorylinks.cl_type = "page" and langlinks.ll_lang = "ar" ORDER BY categorylinks.cl_to DESC; GROUP BY categorylinks.cl_to
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...