1 |
\c blogs |
2 |
-- Movable Type |
3 |
|
4 |
select |
5 |
entry_atom_id as id, |
6 |
'http://blog.rot13.org/' || date_part('year', entry_authored_on) || '/' || lpad(date_part('month', entry_authored_on)::text,2,'0') || '/' || entry_basename || '.html' as uri, |
7 |
entry_title as label, |
8 |
entry_authored_on as date, |
9 |
entry_modified_on as modified, |
10 |
author_email as author, |
11 |
entry_text as content, |
12 |
date_part('year', entry_authored_on) as year, |
13 |
length(entry_text) as length |
14 |
from mt_entry |
15 |
join mt_author on entry_author_id = author_id |
16 |
order by entry_authored_on desc |
17 |
; |