| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
-- select user_name, count(*) from revision join page on... |
3 years ago |
| use zhwiki_p;
select user_name, count(*) from revision join page on rev_page... |
3 years ago |
| use zhwiki_p;
select user_name, count(*) from revision join page on rev_page... |
3 years ago |
| use zhwiki_p;
select * from revision order by rev_id desc limit 50 ;
--... |
3 years ago |
| use zhwiki_p;
select * from revision limit 50 order desc;
-- select... |
3 years ago |
| use zhwiki_p;
select * from revision limit 50 desc;
-- select user_id,... |
3 years ago |
| use zhwiki_p;
select * from revision limit 50;
-- select user_id,... |
3 years ago |
| use zhwiki_p;
select user_id, user_name, ug_group from user join user_groups... |
3 years ago |
| use zhwiki_p;
select user_id, user_name, ug_group from user join... |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like... |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like '%wql%' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like '%特产批发零售%' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like '%stang' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like 'Stang' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name like '特产批发零售' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name ~* '.*特产批发零售' |
3 years ago |
| use zhwiki_p;
select user_id, user_name from user
where user_name ~* ".*特产批发零售" |
3 years ago |
