select * from ores_model |
6 years ago |
show tables; |
6 years ago |
describe page; |
6 years ago |
select rev_user FROM revision WHERE rev_parent_id is null limit 100; |
6 years ago |
select distinct rev_user FROM revision WHERE rev_parent_id is null; |
6 years ago |
describe user; |
6 years ago |
select count(*) from revision where rev_parent_id is null; |
6 years ago |
explain select rev_user from revision limit 10 |
6 years ago |
select rev_user from revision limit 10 |
6 years ago |
explain select rev_user from revision |
6 years ago |
explain select rev_user from revision order by rev_user desc limit 1; |
6 years ago |
select rev_user from revision order by rev_user desc limit 1; |
6 years ago |
select rev_user from revision limit 1 order by rev_user desc; |
6 years ago |
select rev_user from revision limit 1; |
6 years ago |
select count(*) from user where user_editcount > 0 |
6 years ago |
describe user; |
6 years ago |
SELECT count(*) FROM user |
6 years ago |