| use fawiki_p;
select rev_user_text, rev_year, sum(rev_id) / (1024 * 1024)... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, /*rev_year,*/ sum(rev_id) / (1024 *... |
7 years ago |
| use fawiki_p;
select rev_user_text, rev_year, sum(rev_id)
from
(
select
... |
7 years ago |
| use fawiki_p;
select rev_user_text, rev_year, sum(rev_id)
from
(
select
... |
7 years ago |
| use fawiki_p;
select rev_user_text, rev_year, sum(rev_id)
from
(
select
... |
7 years ago |
| use fawiki_p;
select
new.rev_id,
case
when new.rev_len > old.rev_len... |
7 years ago |
| use fawiki_p;
select
new.rev_id,
case
when new.rev_length >... |
7 years ago |
| use fawiki_p;
select *
from revision new
join revision old
on old.rev_id =... |
7 years ago |
| use fawiki_p;
select *
from revision new
join revision old
on old.rev_id =... |
7 years ago |
| use fawiki_p;
select *
from revision new
-- join revision old
where... |
7 years ago |
| use fawiki_p;
select *
from revision
where rev_user_text = 'Huji' |
7 years ago |
