| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
|
| |
3 |
3 |
<queryset> |
| |
4 |
4 |
<rdbms><type>postgresql</type><version>7.4</version></rdbms> |
| |
5 |
5 |
|
| |
6 |
6 |
<fullquery name="blog_entries"> |
| |
7 |
7 |
<querytext> |
| |
8 |
8 |
SELECT blog.title, entry_id, |
| |
9 |
9 |
to_char(blog.entry_date, 'FMMonth FMDDth, YYYY') AS pretty_date |
| |
10 |
10 |
FROM pinds_blog_entries blog, apm_packages pkg |
| |
11 |
11 |
WHERE pkg.package_key = 'lars-blogger' |
| |
12 |
12 |
AND pkg.package_id IN ([join $list_of_package_ids ,]) |
| |
13 |
13 |
AND blog.package_id = pkg.package_id |
| |
14 |
14 |
AND blog.draft_p = 'f' |
| |
15 |
15 |
AND blog.deleted_p = 'f' |
| |
16 |
16 |
ORDER BY blog.entry_date DESC |
| |
|
17 |
LIMIT 5 |
| |
17 |
18 |
</querytext> |
| |
18 |
19 |
</fullquery> |
| |
19 |
20 |
|
| |
20 |
21 |
</queryset> |
