Featured article title,size,revisions of tewiki

Fork of Featured article title,size,revisions of tewiki by Arjunaraoc

This query is marked as a draft This query has been published by Kasyap.

SQL

use hiwiki_p;
SELECT  page_title, page_len,
count(*) AS num_of_revisions
FROM revision
LEFT JOIN  page ON revision.rev_page=page.page_id
WHERE page.page_namespace = 0 AND page_title in 
		(SELECT page_title 
                  FROM page
					LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id
		WHERE (page_namespace=1 AND categorylinks.cl_to LIKE '{subst:नया निर्वाचित लेख प्रस्ताव|लेख का नाम जिसे आप नामांकित कर रहे हैं'))
GROUP BY page_title
ORDER BY page_title

SQL

Checking query status...