| use mgwiktionary_p;
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
/*
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
/*
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
/*
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
/*
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
select
if(rev_actor in
(select actor_id from... |
4 years ago |
| use mgwiktionary_p;
select * from revision
where rev_actor in
(select... |
4 years ago |
| use mgwiktionary_p;
select * from revision
where rev_actor in
(select... |
4 years ago |
| use mgwiktionary_p;
select actor_id from actor
join user_groups on ug_user... |
4 years ago |
| use mgwiktionary_p;
set @bots := (select actor_id from actor
... |
4 years ago |
| use mgwiktionary_p;
select * from revision_userindex limit 10;
/*
select... |
4 years ago |
| use mgwiktionary_p;
select if(ug_group = 'bot', 'bot', 'not') as botness,... |
4 years ago |
| use mgwiktionary_p;
select if(ug_group = 'bot', 'bot', 'not') as botness,... |
4 years ago |
| use mgwiktionary_p;
select if(ug_group = 'bot', 'bot', 'not') as botness,... |
4 years ago |
| use mgwiktionary_p;
select if(ug_user = 'bot', 'bot', 'not') as botness,... |
4 years ago |
| use mgwiktionary_p;
select if(ug_user = 'bot', 'bot', 'not') as botness,... |
4 years ago |
| use mgwiktionary_p;
select rev_page, count(*) as count from revision
group... |
4 years ago |
| use mgwiktionary_p;
select * from revision
group by rev_page
order by... |
4 years ago |
| use mgwiktionary_p;
select * from revision
group by rev_page
order by... |
4 years ago |
| use mgwiktionary_p;
select * from revision
group by rev_page
order by... |
4 years ago |
| use mgwiktionary_p;
/*
select * from logging
join actor on actor_id =... |
4 years ago |
| use mgwiktionary_p;
/*
select * from logging
join actor on actor_id =... |
4 years ago |
| use enwiktionary_p;
/*
select * from logging
join actor on actor_id =... |
4 years ago |
| use enwiktionary_p;
select * from logging
join actor on actor_id =... |
4 years ago |
| use enwiktionary_p;
select * from logging
join actor on actor_id =... |
4 years ago |
| use enwiktionary_p;
select * from logging
where log_type = 'create'
limit 10; |
4 years ago |
| use enwiktionary_p;
select * from logging
where log_type = 'create'; |
4 years ago |
| use enwiktionary_p;
select log_type as type, count(*) as count from... |
4 years ago |
| use enwiktionary_p;
select * from pagelinks
join page on page_id =... |
4 years ago |
