SELECT SQL_CALC_FOUND_ROWS, AS id, AS country_name, AS country_id, AS region_name, AS region_id, IF(p.type!=4, IF(pp.price IS NOT NULL, pp.price, pp2.price), pd7.price) AS price FROM cached_product_structure cps LEFT JOIN products p ON cps.product_id = LEFT JOIN destinations d1 ON cps.country_id = LEFT JOIN destinations d2 ON cps.region_id = LEFT JOIN product_details_neukombi pdn ON = pdn.product_id LEFT JOIN destinations d3 ON cps.city_id = LEFT JOIN product_type t ON cps.product_type = LEFT JOIN product_type_combination ptc ON = ptc.product_id LEFT JOIN cached_bestprice_by_base pp ON p.code = pp.base LEFT JOIN cached_bestprice_by_code pp2 ON p.code = pp2.code LEFT JOIN product_details_hotel pd1 ON = pd1.product_id LEFT JOIN product_details_roundtrip pd2 ON = pd2.product_id LEFT JOIN product_details_cruise pd3 ON = pd3.product_id LEFT JOIN product_details_combination pd4 ON = pd4.product_id LEFT JOIN product_details_trip pd5 ON = pd5.product_id LEFT JOIN product_details_stopover pd6 ON = pd6.product_id LEFT JOIN product_details_special pd7 ON = pd7.product_id LEFT JOIN airlines air ON pd7.airline_id = LEFT JOIN product_days days ON = days.product_id LEFT JOIN ( SELECT product_id, TYPE, title FROM product_highlight ph WHERE (available_from <= DATE(NOW()) OR available_from IS NULL) AND (available_until >= DATE(NOW()) OR available_until IS NULL) AND active = 1 GROUP by product_id ORDER BY id ASC ) AS ph ON = ph.product_id WHERE (pp.price IS NOT null OR pp2.price IS NOT NULL OR pd7.price IS NOT NULL) AND p.mode = 1 AND p.type != 4444 AND (p.available_from <= CURDATE() OR p.available_from IS NULL) AND (p.available_until >= CURDATE() OR p.available_until IS NULL) AND (p.type = "10" OR ptc.product_type = "10" ) GROUP BY ORDER BY highlight_type DESC, price ASC; Stopover in Asien von Asiamar by ID Reisewelt
Code Nr.:
Anfrage stellen    |   Suche   |   Ihr Reiseplan