جام2 - Quarry

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_politician_book_stubs","Alabama_politician_stubs","Alaska_politician_stubs","Arizona_politician_stubs","Arkansas_politician_stubs","Colorado_politician_stubs","Connecticut_politician_stubs","Washington,_D.C._politician_stubs","Delaware_politician_stubs","Florida_politician_stubs","Hawaii_politician_stubs","Idaho_politician_stubs","Illinois_politician_stubs","Indiana_politician_stubs","Iowa_politician_stubs","Kansas_politician_stubs","Kentucky_politician_stubs","Louisiana_politician_stubs","Maine_politician_stubs","Maryland_politician_stubs","Minnesota_politician_stubs","Mississippi_politician_stubs","Missouri_politician_stubs","Montana_politician_stubs","Nebraska_politician_stubs","Nevada_politician_stubs","New_Hampshire_politician_stubs","New_Mexico_politician_stubs","North_Carolina_politician_stubs","North_Dakota_politician_stubs","Oklahoma_politician_stubs","Oregon_politician_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","Washington_(state)_politician_stubs","West_Virginia_politician_stubs","Wyoming_politician_stubs","Native_American_politician_stubs")
   	and  categorylinks.cl_type = "page" 
    and  langlinks.ll_lang = "ar"

GROUP BY categorylinks.cl_to
SQL

Checking query status...
