<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="blogger.getRecentPosts.get_n_entries"> <querytext> select * from (select entry_id, to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, content from pinds_blog_entries and package_id = :package_id and draft_p = 'f' and deleted_p = 'f' order by entry_date desc ) where rownum <= :numberOfPosts </querytext> </fullquery> </queryset>