Ihr Schweizer Spezialist für
einzigartige Afrika-Reisen
  
-

SELECT t.trips_id as trips_id, img.path as thumbnail_path, img.name as thumbnail_name, img.alt as thumbnail_alt, img.copyright as thumbnail_copyright, img.show_copyright as thumbnail_show_copyright, t.double_price as double_price, t.double_unit as double_unit, td.starting_city as starting_city, td.end_city as end_city, t.duration_days as duration_days, t.duration_nights as duration_nights, td.trips_title as trips_title, td.trips_brief as trips_brief, t.tripstyle_id as tripstyle_id, t.departure_date, t.return_date, t.slug_de, t.slug_en FROM aqt_trips t LEFT JOIN aqt_trips_desc td ON t.trips_id = td.trips_id AND td.languages_code = "de" LEFT JOIN aqt_image img ON t.thumbnail_id = img.id LEFT JOIN aqt_trips_to_trip_categories t2tc ON t.trips_id = t2tc.trips_id LEFT JOIN aqt_trip_categories tc ON t2tc.trip_categories_id = tc.trip_categories_id AND tc.trip_categories_status = 1 LEFT JOIN aqt_trip_categories_desc tcd ON tc.trip_categories_id = tcd.trip_categories_id AND tcd.languages_code = "de" LEFT JOIN aqt_trips_to_regions t2r ON t.trips_id = t2r.trip_id LEFT JOIN aqt_regions regs ON t2r.region_id = regs.id LEFT JOIN aqt_trips_to_getting_there t2gt ON t.trips_id = t2gt.trip_id LEFT JOIN aqt_trips_to_destinations t2d ON t.trips_id = t2d.trips_id LEFT JOIN aqt_destinations d ON t2d.destinations_id = d.destinations_id LEFT JOIN aqt_destinations_desc dd ON d.destinations_id = dd.destinations_id AND dd.languages_code = "de" LEFT JOIN aqt_trips_to_themes t2t ON t.trips_id = t2t.trips_id LEFT JOIN aqt_themes them ON t2t.themes_id = them.themes_id AND them.themes_status = 1 LEFT JOIN aqt_themes_desc themdesc ON them.themes_id = themdesc.themes_id AND themdesc.languages_code = "de" LEFT JOIN aqt_tripstyle tstyle ON t.tripstyle_id = tstyle.tripstyle_id LEFT JOIN aqt_tripstyle_desc tstyledesc ON tstyle.tripstyle_id = tstyledesc.tripstyle_id AND tstyledesc.languages_code = "de" LEFT JOIN aqt_trip_day trd ON t.trips_id = trd.trip_id LEFT JOIN aqt_trip_day_to_attraction trda ON trd.id = trda.day_id LEFT JOIN aqt_attraction attr ON trda.attraction_id = attr.id LEFT JOIN aqt_trip_day_to_place d2p ON trd.id = d2p.day_id LEFT JOIN aqt_place place ON d2p.place_id = place.id AND place.is_active = 1 LEFT JOIN aqt_hotel hotel ON place.id = hotel.place_id AND hotel.is_active = 1 WHERE 1 AND t.trips_status = 1 AND (t.valid_to = "" OR t.valid_to IS NULL OR t.valid_to >= "2024-05-05") AND (t.culture_shock >= 0 AND t.culture_shock <= 5) AND (t.physical_rating >= 0 AND t.physical_rating <= 5) AND ( t.duration_days >= 1 AND t.duration_days <= 120 ) AND ( (SELECT (t.double_price *value) + ((t.double_price *value)*(margin_percent/100) * margin) as cResult FROM aqt_currencies WHERE code_from = t.double_unit AND code_to = 'EUR') >= 0 AND (SELECT (t.double_price *value) + ((t.double_price *value)*(margin_percent/100) * margin) as cResult FROM aqt_currencies WHERE code_from = t.double_unit AND code_to = 'EUR') <= 10000 ) GROUP BY t.trips_id ORDER BY t.single_price ASC LIMIT -10, 10

[TEP STOP]