NEWSROOM :: #variables.item_title##variables.item_title#
#variables.item_long_title#
#Replace(formattedText,request.crlf,"
","ALL")#
#Replace(formattedText,request.crlf,"
","ALL")#
#Replace(formattedText,request.crlf,"
","ALL")#
Contact: #variables.item_contact_url_display##trim(variables.item_contact_url)#
#variables.item_other_url_display##trim(variables.item_other_url)#
SELECT I.item_id related_item_id,
I.item_title,
I.item_teaser,
I.item_location,
I.item_type,
I.item_date,
I.item_date_to,
I.item_contact_url,
I.item_contact_url_display,
I.item_other_url,
I.item_other_url_display,
C1.code_long item_type_text
FROM code C1,
item I,
item_item II
WHERE I.item_type = C1.code_id (+) AND
I.item_id = II.itit_item_child AND
II.itit_item_parent = #variables.item_id#
Related articles
#item_title#