| # 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110: 15745/285.3
#... |
3 years ago |
| # 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110: 15745/285.3
#... |
3 years ago |
| # 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110: 15745/285.3
#... |
3 years ago |
| # 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110: 15745/285.3
#... |
3 years ago |
| # 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110: 15745/285.3
#... |
3 years ago |
| #use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20210110:... |
3 years ago |
| use enwiki_p;
# 20200101: 15245/325.0
# 20210101: 15736/291.0
# 20200110:... |
3 years ago |
| use enwiki_p;
# 20210101: 15736/291.0
# 20200110: 15745/285.3
# 20200120:... |
3 years ago |
| use enwiki_p;
# 20210101: 15736/291.0
# 20200110: 15745/285.3
# 20200120:... |
3 years ago |
| use enwiki_p;
# 20210101: 15736/291.0
# 20200110: 15745/285.3
# 20200120:... |
3 years ago |
| use enwiki_p;
# 20210101: 15736/291.0
# 20200110: 15740/285.4
# 20200120:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20200110: 15740/285.4
# 20200120:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.1
# 20210108: 15724/286.2
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
# 20200109:... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108: 15724/286.17
#... |
3 years ago |
| use enwiki_p;
# 20210101: 15720/291.09
# 20210108:
select count(*),... |
3 years ago |
| use enwiki_p;
# 20210101:
select count(*), avg(age)
from (
select... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select count(*), avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select avg(age)
from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select pa.page_id,
str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id,
str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id,
str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id,
str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select avg(ts) from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select avg(ts) from (
select pa.page_id,... |
3 years ago |
| use enwiki_p;
select pa.page_id, str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id, str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id, str_to_date(max(r.rev_timestamp),... |
3 years ago |
| use enwiki_p;
select pa.page_id, to_date(max(r.rev_timestamp), 'YYYYMMDD')... |
3 years ago |
| use enwiki_p;
select pa.page_id, max(r.rev_timestamp) as ts
from page pa... |
3 years ago |
| use enwiki_p;
select pa.page_id, max(r.rev_timestamp) as ts
from page pa... |
3 years ago |
| use enwiki_p;
select *
from page pa
inner join revision r on r.rev_page =... |
3 years ago |
| use enwiki_p;
select *
from page pa
inner join revision r on r.rev_page =... |
3 years ago |
| use enwiki_p;
select *
from page pa
inner join revision r on r.rev_page =... |
3 years ago |
| use enwiki_p;
select *
from page pa
inner join revision r on r.rev_page =... |
3 years ago |
| use enwiki_p;
select count(*)
from page pa
inner join revision r on... |
3 years ago |
| use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
| use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0 and... |
3 years ago |
| use enwiki_p;
select count(*)
from page pa
where pa.page_namespace = 0... |
3 years ago |
| use enwiki_p;
select count(*)
from page pa
pa.page_namespace = 0... |
3 years ago |
