| use fawiki_p;
select /* SLOW OK */ user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select /* SLOW OK */ user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) latest,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) /*,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) /*,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp) /*,... |
8 years ago |
| use fawiki_p;
select user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
select distinct user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
select distinct user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
select distinct user_name, max(rev_timestamp),... |
8 years ago |
| use fawiki_p;
SELECT DISTINCT user_name, rev_timestamp,... |
8 years ago |
| use fawiki_p;
select user_name, sum(if(page_namespace = 0, 1, 0)) article,... |
8 years ago |
| use fawiki_p;
select user_name, sum(if(page_namespace = 0, 1, 0)) article,... |
8 years ago |
| use fawiki_p;
select rev_page, page_namespace, page_title from revision join... |
8 years ago |
| use fawiki_p;
select * from revision where rev_user = 8483 order by rev_id... |
8 years ago |
| use fawiki_p;
select user_name, str_to_date(left(min(rev_timestamp), 8),... |
8 years ago |
| use fawiki_p;
select user_name, str_to_date(left(min(rev_timestamp), 8),... |
8 years ago |
| use fawiki_p;
select user_name, avg(rev_len) * count(rev_first) from... |
8 years ago |
| use fawiki_p;
select user_name, avg(rev_len) from revision r join (select... |
8 years ago |
| use fawiki_p;
select user_name, mean(rev_len) from revision r join (select... |
8 years ago |
| use fawiki_p;
select user_name, rev_len from revision r join (select... |
8 years ago |
| use fawiki_p;
select user_name, str_to_date(left(min(rev_timestamp), 8),... |
8 years ago |
| use fawiki_p;
select user_name, min(rev_timestamp), sum(if(rev_len between 0... |
8 years ago |
| use fawiki_p;
select user_name, sum(if(rev_len between 0 and 2048, 1, 0)),... |
8 years ago |
| use fawiki_p;
select user_name, sum(if(rev_len between 0 and 2048, 1, 0)),... |
8 years ago |
| use fawiki_p;
select user_name, sum(if(rev_len between 0 and 2048)),... |
8 years ago |
