use itwiki_p;
select
rev_id, actor_name,... |
3 years ago |
use itwiki_p;
select
rev_id, actor_name,... |
3 years ago |
use itwiki_p;
select
*
-- rev_timestamp, actor_name
from revision
join... |
3 years ago |
use itwiki_p;
select rev_timestamp, actor_name from revision
join actor
on... |
3 years ago |
use itwiki_p;
select rev_timestamp, actor_name from revision
join actor
on... |
3 years ago |
use itwiki_p;
select * from revision
join actor
on rev_actor =... |
3 years ago |
use itwiki_p;
select * from revision
join actor
on rev_actor =... |
3 years ago |
use itwiki_p;
select * from actor where actor_user is null limit 10 |
3 years ago |
use itwiki_p;
select * from actor limit 100 |
3 years ago |
use itwiki_p;
select * from actor limit 1 |
3 years ago |
use itwiki_p;
select * from revision where rev_page = 6475650 order by... |
3 years ago |
use itwiki_p;
select * from revision where rev_page = 6475650 limit 1
|
3 years ago |
use itwiki_p;
-- select * from revision limit 1
select * from page where... |
3 years ago |
use itwiki_p;
select * from revision limit 1 |
3 years ago |