Italiano

Zefiro Bio Voyager - GrandTourAssistance International

ERROR:SELECT pkg.id as id, pkg.name_en as name, pkg.descrshort_en as descrshort, pkg.descr_en as descr, pkg.travnote_en as travnote, validity1_out as v1, validity2_out as v2,validity3_out as v3, t_country.name_en as countryname, currency, flg_nodepart, case when (flg_nodepart<>'1') then 'ok' else '' end as show_dep, pkg.url_photosmall, pkg.url_photo1, pkg.url_photo2, pkg.url_photo3, pkg.url_photo4, minnights as minnights, nights as maxnights, case when (price_adult>0) then price_adult else 0 end as price, case when (date_to<'1980-12-31' or date_to is null) then '1980-12-31' else date_to end as date_to, case when (date_from<'1980-12-31' or date_from is null) then '1980-12-31' else date_from end as date_from, case when (id_from<>3) then 'ok' else '' end as mostra_prezzo, pd.descr_en as dep_desc,pd.info_en as dep_info,pd.include_en as dep_inc,pd.notinclude_en as dep_notinc, flg_new, m_descr as meal FROM pkg left join ( select id_package, max(date_to) as date_to from pkg_details where flg_active='1' group by id_package ) as pd0 on pkg.id = pd0.id_package left join ( select id_package, min(date_from) as date_from from pkg_details where ((date_from > now() or date_from<'1990-01-01 00:00:00')and date_from is not null) and flg_active='1' group by id_package ) as pd1 on pkg.id = pd1.id_package left join( select id_package, max(nights) as nights from pkg_details group by id_package ) as pd2 on pkg.id = pd2.id_package left join( select id_package, min(nights) as minnights from pkg_details group by id_package ) as pd3 on pkg.id = pd3.id_package left join( select id_package, min(price_adult) as price_adult from pkg_details where flg_active='1' group by id_package ) as pd4 on pkg.id = pd4.id_package left join ( select m2.descr_en m_descr, id_package, id_meal, m1.descr_en, info_en, include_en, notinclude_en, flg_active from ( select DISTINCT ON (id_package) id_package, id_meal, descr_en, info_en, include_en, notinclude_en, flg_active from pkg_details ) m1 left join pkg_meals m2 on id_meal= m2.id ) as pd on pkg.id = pd.id_package left join t_country on pkg.id_country = t_country.id WHERE true AND pkg.id=2471 and (pkg.flg_active = '1' or id_from='3') and ( date_from > now() or flg_nodepart = '1') and flg_italian<>'1' and (validity1_out >= current_date or validity2_out >= current_date or validity3_out >= current_date) and pkg.name_en<>'' and pkg.name_en is not null order by random()

  • Nights:

Information Request

You are here Home