| use cswiki_p;
select * from logging u where log_user = 6216 and log_type = 'newusers' |
5 years ago |
| use cswiki_p;
select u.* from user u where user_id = 6216 |
5 years ago |
| use cswiki_p;
select u.* from user u
left join (select * from logging where... |
5 years ago |
| use cswiki_p;
select count(*) from user where user_registration >= 20100101000000 |
5 years ago |
| use cswiki_p;
select count(*) from user where user_registration is not null |
5 years ago |
| use cswiki_p;
select count(*) from user where user_registration is null |
5 years ago |
| use cswiki_p;
select * from user limit 10 |
5 years ago |
| use cswiki_p;
select count(*) from user |
5 years ago |
| use cswiki_p;
select * from user where user_name like 'MMiller (WMF)' |
5 years ago |
| use cswiki_p;
select * from user where user_name = 'MMiller_(WMF)' |
5 years ago |
| use cswiki_p;
select * from user where user_name = 'Urbanecm' |
5 years ago |
| use cswiki_p;
select * from user limit 10 |
5 years ago |
