Deutschland

Reiseziele
Deutschland

Requ�te : [select T_THEME.TH_ID, DTH_TITRE from T_DESC_THEME, T_THEME where T_DESC_THEME.TH_ID=T_THEME.TH_ID and DTH_LANGUE in (3) and (T_THEME.TH_ID in (select TH_ID from T_PROMO where T_PROMO.PR_ID in (select PR_ID from T_DESC_PROMO where DP_ACTIVE='1' and DP_LANGUE in (3)) and to_date('20/11/2008', 'DD/MM/YYYY') <= T_PROMO.PR_FIN_INLINE AND to_date('20/11/2008', 'DD/MM/YYYY') >= T_PROMO.PR_DEBUT_INLINE and RC_ID in (select RC_ID from T_RELAISCHATEAUX where 1=1 and RC_CODE in ())) or T_THEME.TH_ID in (select TH_ID from T_PACKAGE where PKG_ID in (select PKG_ID from T_RC_PACKAGE where 1=1 and RC_ID in (select RC_ID from T_RELAISCHATEAUX where 1=1 and RC_CODE in ())))) order by DTH_TITRE]