| select
DATE_FORMAT(log_timestamp,"%Y-%m") as month,
count(*) as cnt
from... |
10 months ago |
| select
DATE_FORMAT(log_timestamp,"%Y") as year,
count(*) as cnt
from... |
10 months ago |
| -- - |
10 months ago |
| SELECT
page_namespace,
page_title
FROM page
LEFT JOIN pagelinks
ON... |
10 months ago |
| SELECT page_namespace as ns,
COUNT(page_id) as pg_cnt
FROM page
WHERE... |
1 year ago |
| SELECT page_namespace as ns,
COUNT(page_id) as pg_cnt
FROM page
GROUP BY... |
1 year ago |
| SELECT page_namespace as ns,
COUNT(page_id) as pg_cnt
FROM page
GROUP BY... |
1 year ago |
| SELECT page_namespace,
COUNT(page_id) as pg_cnt
FROM page
GROUP BY page_namespace; |
1 year ago |
| SELECT page_namespace,
COUNT(page_id) as cnt
FROM page
GROUP BY... |
1 year ago |
| -- -- |
2 years ago |
| -- -- |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| SET @counter:=0;
SELECT... |
2 years ago |
| -- -- |
2 years ago |
| select
aftr.rev_id,
convert(aftr.rev_len, signed) -... |
3 years ago |
| select
aftr.rev_id,
convert(aftr.rev_len, signed) -... |
3 years ago |
| select
after.rev_id,
convert(after.rev_len, signed) -... |
3 years ago |
| select
`after`.rev_id,
convert(`after`.rev_len, signed) -... |
3 years ago |
| select
`after`.rev_id,
convert(`after`.rev_len, signed) -... |
3 years ago |
| select
`after`.revid,
convert(`after`.rev_len, signed) -... |
3 years ago |
| select
`after`.rev_id,
`after`.rev_len - `before`.rev_len as... |
3 years ago |
| select
`after`.rev_id,
convert(`after`.rev_len, signed) -... |
3 years ago |
| select
`after`.revid,
convert(`after`.rev_len, signed) -... |
3 years ago |
| select
actor_name as user,
avg(convert(`after`.rev_len, signed) -... |
3 years ago |
| select
actor_name as user,
avg(convert(`after`.rev_len, signed) -... |
3 years ago |
| select
actor_name as user,
avg(convert(`after`.rev_len, signed) -... |
3 years ago |
| select
actor_name as user,
avg(convert(`after`.rev_len, signed) -... |
3 years ago |
| select
actor_name as user,
avg(convert(`after`.rev_len, signed) -... |
3 years ago |
| select *
from revision
join actor
on rev_actor = actor_id
limit 30; |
3 years ago |
