simile/sql/mt.sql

\c blogs
-- Movable Type

select
        entry_atom_id as id,
        '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,
        entry_title as label,
        entry_authored_on as date,
        entry_modified_on as modified,
        author_email as author,
        entry_text as content,
        date_part('year', entry_authored_on) as year,
        length(entry_text) as length
from mt_entry
join mt_author on entry_author_id = author_id
order by entry_authored_on desc
;
1	dpavlin	33	\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			;