Bot and non-bot entry creations on mg.wiktionary.org

SQL

use mgwiktionary_p;

select actor_id from actor
join user_groups on ug_user = actor_user
where ug_group = 'bot';
/*
select rev_actor, rev_page from revision_userindex
group by rev_page
order by rev_timestamp asc
*/

/*
select if(ug_group = 'bot', 'bot', 'not') as botness, count(*) as count from revision_userindex
join actor on actor_id = rev_actor
join user_groups on ug_user = actor_user
group by rev_page, botness
order by rev_page, rev_timestamp desc
limit 10;
*/

/*
select * from logging
join actor on actor_id = log_actor
join comment on comment_id = log_comment_id
where log_type = 'create'
limit 10;
*/
/*
select * from user
join user_groups on ug_user = user_id
where ug_group = 'bot'
limit 10;
*/

SQL

Checking query status...