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

SQL

AخA
 
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;
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
All SQL code is licensed under CC0 License.

Checking query status...