<?xml version="1.0"?> <!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN" "http://www.thecodemill.biz/repository/xql.dtd"> <!-- --> <!-- @author Victor Guerra (guerra@galileo.edu) --> <!-- @creation-date 2005-05-19 --> <!-- @cvs-id $Id: site-templates.xql,v 1.3 2018/08/15 17:02:02 gustafn Exp $ --> <queryset> <fullquery name="select_site_templates"> <querytext> select dst.site_template_id, dst.pretty_name, pet.name || ' ( ' || pet.description || ' )' as portal_theme from dotlrn_site_templates dst, portal_element_themes pet where dst.portal_theme_id = pet.theme_id </querytext> </fullquery> </queryset>