<?xml version="1.0"?> <queryset> <fullquery name="get_attachments"> <querytext> select live_revision as attach_id, display, name as file_name from (select live_revision, name from cr_items where parent_id = :slide_item_id and content_type in ('cr_wp_image_attachment', 'cr_wp_file_attachment') ) a left join cr_wp_image_attachments on (a.live_revision = attach_id) </querytext> </fullquery> </queryset>