| select rc_actor, count(*) as nrc from recentchanges
... |
2 years ago |
| select * from user_properties where up_user=806 |
2 years ago |
| select rc_actor,count(*) from recentchanges
... |
2 years ago |
| select distinct(rc_actor) from recentchanges
... |
2 years ago |
| select *
from user_properties where up_user in (select distinct(rc_actor)... |
2 years ago |
| select *
from actor where actor_id in (select distinct(rc_actor) from... |
2 years ago |
| select rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_new,... |
2 years ago |
| select rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_new,... |
2 years ago |
| select rc_id, rc_timestamp, rc_actor, rc_namespace, rc_title, rc_new,... |
2 years ago |
| select * from recentchanges where rc_actor in (select distinct(rc_actor)... |
2 years ago |
| select * from recentchanges where rc_actor in (select distinct(rc_actor)... |
2 years ago |
| select * from recentchanges where rc_actor in (select rc_actor from... |
2 years ago |
| select * from recentchanges where rc_actor in (select rc_actor, count(*) as... |
2 years ago |
| select * from rechentchanges where rc_actor in (select rc_actor, count(*) as... |
2 years ago |
| select rc_actor, count(*) as nrc from recentchanges
where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) as nrc from recentchanges
where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) as nrc from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_actor, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_title, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_namespace, rc_title, count(*) from recentchanges where... |
2 years ago |
| select rc_namespace, count(distinct(rc_title)) from recentchanges where... |
2 years ago |
| select count(distinct(rc_actor)) from recentchanges where rc_timestamp >... |
2 years ago |
| select count(distinct(rc_user)) from recentchanges where rc_timestamp >... |
2 years ago |
| select count(*) from recentchanges where rc_timestamp > 20210101000000 AND rc_bot=0
|
2 years ago |
| describe recentchanges |
2 years ago |
| select rc_bot, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| select rc_bot, count(*) from recentchanges where rc_timestamp >... |
2 years ago |
| describe recentchanges |
2 years ago |
| select count(*) from recentchanges where rc_timestamp > 20221001000000
|
2 years ago |
| describe recentchanges |
2 years ago |
| select rev_actor, count(*) from revision where rev_timestamp >... |
2 years ago |
| select rev_actor, count(*) from revision where rev_timestamp >... |
2 years ago |
| describe revision |
2 years ago |
| describe revisions |
2 years ago |
| select user_id, count(*) from revision where rev_timestamp > 20221001000000... |
2 years ago |
| select count(*) from revision where rev_timestamp > 20221001000000
|
2 years ago |
| describe revision
|
2 years ago |
| select count(*) from revision where timestamp > 20221001000000
|
2 years ago |
| select count(*) from revision_userindex
|
2 years ago |
| selec count(*) from revision_userindex
|
2 years ago |
| describe revision_userindex
|
2 years ago |
| show tables |
2 years ago |
| describe revision |
2 years ago |
| select * from user_properties LIMIT 100 |
2 years ago |
| describe user_properties |
2 years ago |
| describe up_user |
2 years ago |
| describe user |
2 years ago |
| select user_id, user_name, user_registration from user where user_name LIKE 'Jul%' |
2 years ago |
| select user_id, user_name, user_registration from user where user_name LIKE 'J%' |
2 years ago |
| select user_id, user_name, user_registration from user where username LIKE 'J%' |
2 years ago |
| select user_id, user_name, user_timestamp from user where username LIKE 'J%' |
2 years ago |
| select * from user |
2 years ago |
