| use fawiki_p;
select left(rev_timestamp, 8), count(*)
from revision
where... |
6 years ago |
| use fawiki_p;
select quarter('2006-11-01') |
6 years ago |
| select
rev_user_text,
rev_timestamp,
substr(rev_timestamp, 1, 4) YR,
... |
6 years ago |
| select
rev_user_text,
rev_timestamp,
substr(rev_timestamp, 1, 4) YR,
... |
6 years ago |
| select
rev_user_text,
rev_timestamp,
substr(rev_timestamp, 1, 4) YR,
... |
6 years ago |
| select
rev_user_text,
rev_timestamp
substr(rev_timestamp, 1, 4) YR,
... |
6 years ago |
| select
rev_user_text,
substr(rev_timestamp, 1, 4) YR,
... |
6 years ago |
