USE dewiki_p;
select page_title, page_namespace from revision inner join... |
6 years ago |
USE dewiki_p;
select page_title, page_namespace from revision, page where... |
6 years ago |
USE dewiki_p;
select page_title, page_namespace from revision, page where... |
6 years ago |
USE dewiki_p;
select * from revision where rev_parent_id=0 order by... |
6 years ago |
USE dewiki_p;
select * from logging where log_type not in ('review',... |
6 years ago |
USE dewiki_p;
select * from logging where log_type not in ('review',... |
6 years ago |
USE dewiki_p;
select * from logging where log_type not in ('review',... |
6 years ago |
USE dewiki_p;
select * from logging where log_type not in ('review',... |
6 years ago |
USE dewiki_p;
select * from logging where log_type not in ('review',... |
6 years ago |
USE dewiki_p;
select * from logging order by log_timestamp desc limit 500; |
6 years ago |
USE dewiki_p;
select count(distinct log_title) from logging where... |
6 years ago |
USE dewiki_p;
select * from logging where log_type='delete' and... |
6 years ago |
USE dewiki_p;
select * from logging where log_type='delete' and... |
6 years ago |
USE dewiki_p;
select * from logging where log_type='delete' order by... |
6 years ago |
USE dewiki_p;
select * from logging order by log_timestamp desc limit 500; |
6 years ago |
USE dewiki_p;
select * from revision where rev_deleted<>0 order by... |
6 years ago |
USE enwiki_p;
select * from revision where rev_deleted<>0 order by... |
6 years ago |
USE enwiki_p;
select * from revision where rev_deleted<>0 order by... |
6 years ago |
USE enwiki_p;
select * from revision where rev_deleted<>0 limit 10; |
6 years ago |
USE enwiki_p;
SHOW INDEX IN user; |
6 years ago |
USE enwiki_p;
SHOW INDEX IN revision; |
6 years ago |
USE enwiki;
SHOW INDEX IN revision; |
6 years ago |
USE enwiki_p;
SHOW INDEX IN revision; |
6 years ago |
USE enwiki_p;
describe revision; |
6 years ago |
USE enwiki_p;
describe revision_comment_temp; |
6 years ago |