forums-portlet-postgresql.xql
DB Query file
Related Files
- packages/forums/lib/forums-portlet.tcl
- packages/forums/lib/forums-portlet.adp
- packages/forums/lib/forums-portlet-postgresql.xql
- packages/forums/lib/forums-portlet-oracle.xql
[ hide source ] | [ make this the default ]
File Contents
<queryset> <rdbms><type>postgresql</type><version>7.3</version></rdbms> <fullquery name="hot_topics"><querytext> SELECT b.subject AS subject, b.message_id AS thread_id, a.message_id AS message_id FROM (SELECT message_id, tree_sortkey, posting_date FROM forums_messages WHERE forum_id IN (SELECT forum_id FROM forums_forums WHERE package_id = :package_id and enabled_p = 't') ORDER BY posting_date DESC LIMIT $n) a, forums_messages b WHERE b.parent_id IS NULL AND b.tree_sortkey = tree_root_key(a.tree_sortkey) AND b.forum_id IN (SELECT forum_id FROM forums_forums WHERE package_id = :package_id and enabled_p = 't'); </querytext></fullquery> <fullquery name="new_topics"><querytext> SELECT subject, message_id FROM forums_messages_approved WHERE forum_id IN (SELECT forum_id FROM forums_forums WHERE package_id = :package_id and enabled_p = 't') AND parent_id IS NULL ORDER BY posting_date DESC LIMIT $n </querytext></fullquery> </queryset>