Untitled query #82564

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

SQL

use bnwiki_p;

SELECT
	rev_actor,
	actor_name,
	count(revision.rev_id) as articles_created
FROM
	change_tag,
	actor,
	revision
WHERE
	revision.rev_parent_id = 0 AND
	ct_tag_id = (select ctd_id from change_tag_def where ctd_name = 'contenttranslation') AND
	rev_id = ct_rev_id AND
	rev_actor = actor_id
GROUP BY
	rev_actor
ORDER BY
	articles_created DESC
LIMIT
	100;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...