| select * from arwiki_p.revision where rev_user = 708413 limit 100 |
6 years ago |
| select * from arwiki_p.revision where rev_timestamp > 20180000000000 limit 10 |
6 years ago |
| select * from arwiki_p.revision limit 100 |
6 years ago |
| select * from arwiki_p.revision |
6 years ago |
| select rev_timestamp from arwiki_p.revision where rev_user = 1995342 |
6 years ago |
| select * from arwiki_p.revision where rev_user = 2078193 |
6 years ago |
| select * from arwiki_p.revision where rev_user = 2220558 |
6 years ago |
| select * from arwiki_p.revision where rev_user = 143372 |
6 years ago |
| select * from arwiki_p.revision where rev_user = 257024 |
6 years ago |
| use frwiki_p;
show tables; |
6 years ago |
| user frwiki_p;
show tables |
6 years ago |
| user frwiki_p;
show tables |
6 years ago |
| user frwiki_p;
show tables; |
6 years ago |
| select count(*) from eswiki_p.wikilove_log; |
6 years ago |
| select count(*) from eswiki_p.logging where log_type = 'thanks' |
6 years ago |
| select * from eswiki_p.logging where log_type = 'thanks' limit 5 |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| -- select log_timestamp as thanktime, replace(log_title, '_', ' ') as... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select log_timestamp as thanktime, replace(log_title, '_', ' ') as receiver,... |
6 years ago |
| select thanktime,
receiver,
ru.user_id as receiver_id,
sender,
... |
6 years ago |
| select thanktime,
receiver,
ru.user_id as receiver_id,
sender,
... |
6 years ago |
| select thanktime,
receiver,
ru.user_id as receiver_id,
sender,
... |
6 years ago |
| select thanktime,
receiver,
ru.user_id as receiver_id,
sender,
... |
6 years ago |
| select thanktime,
receiver,
ru.user_id as receiver_id,
sender,
... |
6 years ago |
