<?xml version="1.0"?> <queryset> <fullquery name="category_info"> <querytext> select f.short_name as forum_name, f.forum_id, c.short_name from bboard_forums f, bboard_categories c where c.category_id = :category_id and f.forum_id = c.forum_id </querytext> </fullquery> </queryset>