ukwiki:Articles created by bots

Fork of enwiki:Articles created by bots by Evolutionoftheuniverse

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

SQL

USE ukwiki_p;
SELECT user_id, year(rev_timestamp), month(rev_timestamp), day(rev_timestamp), user_name, COUNT(*)
FROM page
JOIN revision ON page_id = rev_page
JOIN actor ON rev_actor = actor_id
JOIN user_groups ON actor_user = ug_user
JOIN user ON ug_user = user_id
WHERE rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0
AND ug_group = 'bot'
GROUP BY user_id, year(rev_timestamp), month(rev_timestamp), day(rev_timestamp)
ORDER BY year(rev_timestamp), month(rev_timestamp), day(rev_timestamp)

SQL

Checking query status...