| use cswiki_p;
select origin_type, count(*) from (
select user_id, user_name,... |
6 years ago |
| use cswiki_p;
select origin_type, count(*) from (
select user_id, user_name,... |
6 years ago |
| use cswiki_p;
select count(*) from logging where log_timestamp >=... |
6 years ago |
| use cswiki_p;
select count(*) from logging where log_timestamp >=... |
6 years ago |
| use cswiki_p;
select count(*) from logging where log_timestamp >=... |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration >=... |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration >= '20170101000000' |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and log_user... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' limit 10
|
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'new users' limit 10
|
6 years ago |
| use cswiki_p;
select * from logging limit 10 |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newuser' limit 10 |
6 years ago |
| use cswiki_p;
select * from user where user_name = 'Oberoner' |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select count(*) from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' limit 10
|
6 years ago |
| use cswiki_p;
select count(*) from logging where log_type = 'newusers' limit 10
|
6 years ago |
| use cswiki_p;
select * from logging where log_title = 'MMiller_(WMF)' and... |
6 years ago |
| use cswiki_p;
select log_title as username, from logging where log_title =... |
6 years ago |
| use cswiki_p;
select log_action, count(*) from logging where log_type =... |
6 years ago |
| use cswiki_p;
select * from logging where log_title like '%Urbanecm%' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_title like '%MMiller%' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_title like '%Urbanec%' and... |
6 years ago |
| use cswiki_p;
select * from logging where log_title like '%Urbanec%' limit 10 |
6 years ago |
| use cswiki_p;
select * from logging where log_title like '%MMiller%' limit 10 |
6 years ago |
| use cswiki_p;
select * from logging where log_title = 'MMiller (WMF)' limit 10 |
6 years ago |
| use cswiki_p;
select * from logging where log_type = 'newusers' and... |
6 years ago |
| use cswiki_p;
select log_type, log_action, count(*) from logging group by... |
6 years ago |
| use cswiki_p;
select log_type, count(*) from logging group by log_type |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration <=... |
6 years ago |
| use cswiki_p;
select count(*) from user where user_registration <= '20180606055725'; |
6 years ago |
| use cswiki_p;
select count(*) from user; |
6 years ago |
