SELECT SQL_CALC_FOUND_ROWS TEMPO.*
									FROM (
									(
									SELECT SAL.sal_pub_code, SAL.sal_ai_id, SAL.id_annonce, 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,
									(SELECT DATEDIFF('2008-10-13', sal_first_online_date)) AS sal_days_old
									FROM T_SALESAD_SAL SAL, LOC_LOOKUP_FR
									WHERE SAL.sal_locality_2 = LOC_LOOKUP_FR.lct_id
									AND LOC_LOOKUP_FR.lct_name_fr='SUPERBOLQUERE'
									AND SAL.sal_property_type_id
									IN ( 1, 2 )
									AND SAL.sal_country = 'FR'
									ORDER BY sal_days_old desc
									)
									UNION ALL 
									(
									SELECT RNT.rnt_pub_code, RNT.rnt_ai_id, RNT.id_annonce, 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,
									 (SELECT DATEDIFF('2008-10-13', rnt_first_online_date)) AS sal_days_old
									FROM T_RENTAD_RNT RNT, LOC_LOOKUP_FR
									WHERE RNT.rnt_locality_2 = LOC_LOOKUP_FR.lct_id
									AND LOC_LOOKUP_FR.lct_name_fr='SUPERBOLQUERE'
									AND RNT.RNT_property_type_id
									IN ( 1, 2 )
									AND RNT.RNT_country = 'FR'
									ORDER BY rnt_days_old desc
									)
									)TEMPO
									ORDER BY sal_days_old
									LIMIT 0,10