Pages and first rev ts, number of rev for a set of wikipedians

SQL

use tewiki_p;
SELECT
  page_title,
  user_name,
  rev_timestamp as first_rev_timestamp,
  COUNT(*) as num_of_revisions
FROM user
LEFT JOIN revision
      ON rev_user = user_id
LEFT JOIN page
      ON page_id = rev_page
WHERE page_namespace=0 AND page_is_redirect =0 AND (user_name in (SELECT page_title 
                    FROM page
			LEFT JOIN  categorylinks ON categorylinks.cl_from = page.page_id
		WHERE (page_namespace=2 AND categorylinks.cl_to = 'యాంత్రిక_అనువాదాలు_చేసే_సభ్యులు')))
GROUP BY page_title
ORDER BY page_title,user_name;

SQL

Checking query status...