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

SQL

use mgwiktionary_p;

/*
select
	if(rev_actor in 
		(select actor_id from actor
		join user_groups on ug_user = actor_user
		where ug_group = 'bot'), 'bot', 'not')
        	as botness,
    count(*)
    	as count
    from revision
where parent_id = 0
group by botness;
*/

select * from revision where parent_id = 0 limit 10;

-- select * from revision limit 10;

/*
select rev_actor, rev_page from revision_userindex
group by rev_page
order by rev_timestamp asc
limit 10;
*/

/*
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...
