| select substring(rev_created, 1, 8) as data_RMD, count(*) as str_na_dzien
,... |
2 years ago |
| select substring(rev_created, 1, 8), count(*) as str_na_dzien
,... |
2 years ago |
| select substring(rev_created, 1, 8), min(page_title), min(rev_created),... |
2 years ago |
| select substring(rev_created, 1, 8), min(page_title), min(rev_created),... |
2 years ago |
| select substring(rev_created, 1, 8), min(page_title), min(rev_created),... |
2 years ago |
| select substring(rev_created, 1, 8), min(page_title), min(rev_created),... |
2 years ago |
| select substring(rev_created, 1, 6), min(page_title), min(rev_created),... |
2 years ago |
| select page_title, rev_created, page_touched, page_len
from
(
select... |
2 years ago |
| select page_title, rev_created, page_touched, page_len
from
(
select... |
2 years ago |
| select *
from page
left join
(select rev_page, min(rev_timestamp) as... |
2 years ago |
| select rev_page, min(rev_timestamp) from revision
group by rev_page |
2 years ago |
