Parent Directory | Revision Log | Patch
revision 33 by dpavlin, Sat Oct 25 12:02:49 2008 UTC | revision 34 by dpavlin, Sat Oct 25 12:47:24 2008 UTC | |
---|---|---|
# | Line 10 select | Line 10 select |
10 | author_email as author, | author_email as author, |
11 | entry_text as content, | entry_text as content, |
12 | date_part('year', entry_authored_on) as year, | date_part('year', entry_authored_on) as year, |
13 | length(entry_text) as length | length(entry_text) as length_valueType_number |
14 | from mt_entry | from mt_entry |
15 | join mt_author on entry_author_id = author_id | join mt_author on entry_author_id = author_id |
16 | order by entry_authored_on desc | order by entry_authored_on desc |
|
ViewVC Help | |
Powered by ViewVC 1.1.26 |