Indian constituencies by assessment rating

SQL

SELECT	COALESCE(talkC.cl_to, 'Total') as 'Assessment Rating', article.page_title as 'Example', count(*)
FROM	page AS article
join	page as talk on talk.page_namespace=1 and talk.page_title=article.page_title
join	categorylinks as articleC on articleC.cl_from=article.page_id
join	categorylinks as talkC on talkC.cl_from=talk.page_id
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
        and (articleC.cl_to="Constituencies_of_the_Lok_Sabha" OR
             articleC.cl_to like "Assembly_constituencies_of_%" OR
             articleC.cl_to like "Lok_Sabha_constituencies_in_%")
        and talkC.cl_to like "%-Class_Indian_politics_articles"
group by talkC.cl_to WITH ROLLUP;

-- Stubs
SELECT	count(distinct article.page_title)
FROM	page AS article
join	page as talk on talk.page_namespace=1 and talk.page_title=article.page_title
join	categorylinks as articleC on articleC.cl_from=article.page_id
join	categorylinks as talkC on talkC.cl_from=talk.page_id
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
--        and articleC.cl_to="Constituencies_of_the_Lok_Sabha"
        and (articleC.cl_to like "Assembly_constituencies_of_%" OR
             articleC.cl_to like "Lok_Sabha_constituencies_in_%")
        and talkC.cl_to="Stub-Class_Indian_politics_articles";
        
-- Start < 4k bytes        
SELECT	count(distinct article.page_title)
FROM	page AS article
join	page as talk on talk.page_namespace=1 and talk.page_title=article.page_title
join	categorylinks as articleC on articleC.cl_from=article.page_id
join	categorylinks as talkC on talkC.cl_from=talk.page_id
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
        and (articleC.cl_to like "Assembly_constituencies_of_%" OR
             articleC.cl_to like "Lok_Sabha_constituencies_in_%")
        and talkC.cl_to="Start-Class_Indian_politics_articles"
        and article.page_len < 4100;
SQL

Checking query status...
