(
						SELECT SAL.sal_pub_code, SAL.sal_ai_id, SAL.id_annonce, SAL.sal_first_online_date, SAL.id_presto, SAL.sal_locality_2 as locality_2, 
						SAL.sal_property_type_id, SAL.sal_property_type, SAL.sal_area, SAL.sal_post_code, SAL.sal_default_town, 
						SAL.sal_price, SAL.sal_nb_rooms, SAL.sal_photo, SAL.sal_photo_2, SAL.sal_photo_3, SAL.sal_photo_4, SAL.sal_photo_5, 
						SAL.sal_logicode, SAL.sal_logicode_old, SAL.sal_country, SAL.sal_default_proximity, SAL.sal_default_text, 
						SAL.id_agence, SAL.sal_name_agency, SAL.sal_address_agency, SAL.sal_post_code_agency, SAL.sal_town_agency, 
						SAL.sal_logo_agency, SAL.sal_country_agency, SAL.sal_rcs_agency, SAL.sal_fax_agency, SAL.sal_email_agency, 
						SAL.sal_tel_agency, SAL.sal_site_agency, LOC_LOOKUP_FR.lct_id, LOC_LOOKUP_FR.lct_parent_id, LOC_LOOKUP_FR.lct_name_fr,
						T_TRAD.tad_text
						FROM T_SALESAD_SAL SAL
						
						LEFT JOIN T_TEXTAD_TAD T_TRAD ON SAL.sal_ai_id =T_TRAD.sal_ai_id AND T_TRAD.TAD_LANGUAGE = 'FR'
						LEFT JOIN LOC_LOOKUP_FR ON SAL.sal_locality_2 = LOC_LOOKUP_FR.lct_id 
						
						WHERE 
												
						SAL.id_annonce = '99CA4ADA-F9F4-F5CB-49F5-54C2AB58312D'
						)
						UNION ALL 
						(
						SELECT RNT.rnt_pub_code, RNT.rnt_ai_id, RNT.id_annonce, RNT.rnt_first_online_date, RNT.id_presto, RNT.rnt_locality_2 as locality_2, 
						RNT.rnt_property_type_id, RNT.rnt_property_type, RNT.rnt_area, RNT.rnt_post_code, RNT.rnt_default_town, 
						RNT.rnt_price, RNT.rnt_nb_rooms, RNT.rnt_photo, RNT.rnt_photo_2, RNT.rnt_photo_3, RNT.rnt_photo_4, RNT.rnt_photo_5, 
						RNT.rnt_logicode, RNT.rnt_logicode_old, RNT.rnt_country, RNT.rnt_default_proximity, RNT.rnt_default_text, 
						RNT.id_agence, RNT.rnt_name_agency, RNT.rnt_address_agency, RNT.rnt_post_code_agency, RNT.rnt_town_agency, 
						RNT.rnt_logo_agency, RNT.rnt_country_agency, RNT.rnt_rcs_agency, RNT.rnt_email_agency, RNT.rnt_fax_agency, 
						RNT.rnt_tel_agency, RNT.rnt_site_agency, LOC_LOOKUP_FR.lct_id, LOC_LOOKUP_FR.lct_parent_id, LOC_LOOKUP_FR.lct_name_fr,
						T_TRAD.tad_text
						FROM T_RENTAD_RNT RNT
						
						LEFT JOIN T_TEXTAD_TAD T_TRAD ON RNT.rnt_ai_id =T_TRAD.rnt_ai_id AND T_TRAD.TAD_LANGUAGE = 'FR'
						LEFT JOIN LOC_LOOKUP_FR ON RNT.rnt_locality_2 = LOC_LOOKUP_FR.lct_id 
												
						WHERE 
												
						RNT.id_annonce = '99CA4ADA-F9F4-F5CB-49F5-54C2AB58312D'
						)