Pažintinė kelionė atrasti neįtikėtiną Japoniją. 8 dienos aplankant Tokiją, Fudži, Osaką, Kiotą
Japonija
string(3401) "SELECT DISTINCT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`travel_type`, `e`.`travel_type_value`, `e`.`departure_date_from_filter`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`city`, `e`.`city_value`, `e`.`country`, `e`.`country_value`, `e`.`hotel_name`, `e`.`hotel_name_value`, `e`.`departure_city`, `e`.`departure_city_value`, `e`.`duration`, `e`.`departure_date`, `e`.`arrival_date`, `e`.`extra_info`, `e`.`recommended`, `e`.`route_cities`, `e`.`ship`, `e`.`ship_value`, `e`.`cabin_type`, `e`.`cabin_type_value`, `e`.`departure_region`, `e`.`departure_region_value`, `e`.`not_allowed_to_buy`, `e`.`room_type`, `e`.`room_type_value`, `e`.`nourishment`, `e`.`nourishment_value`, `e`.`link_to`, `e`.`last_update_date`, `e`.`departure_date_to_filter`, `e`.`redirect_link`, `e`.`show_from`, `e`.`show_to`, `e`.`coupon_price_from`, `e`.`sold_out`, `e`.`article_country`, `e`.`article_country_value`, `e`.`travel_direction_text`, `e`.`duration_days`, `e`.`duration_days_value`, `e`.`date_text`, `e`.`teztour_fingerprint`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `_stock_information`.`qty`, `_stock_information`.`stock_status`, IF((`e`.`recommended` = 0 OR `e`.`recommended` IS NULL) OR (`e`.`recommended` = 1 AND (DATE(NOW()) >= Date(`e`.`show_to`) OR ((`e`.`type_id` = "simple" AND `e`.`entity_id` != 75068 ) AND `_stock_information`.`qty` = 0) OR (`e`.`type_id` = "grouped" AND `_stock_information`.`stock_status` = 0))), 0, `e`.`entity_id` ) AS `recommended_2`, IF(DATE(NOW()) >= Date(`e`.`show_to`) OR ((`e`.`type_id` = "simple" AND `e`.`entity_id` != 75068 ) AND `_stock_information`.`qty` = 0) OR (`e`.`type_id` = "grouped" AND `_stock_information`.`stock_status` = 0), IF(`e`.`recommended` = 1, 1, 2), 0) AS `sold_out_2` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '67' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_product_index_eav` AS `country_idx` ON `country_idx`.entity_id = e.entity_id AND `country_idx`.attribute_id = '135' AND `country_idx`.store_id = 1 AND `country_idx`.value in (230) LEFT JOIN `cataloginventory_stock_status` AS `_stock_information` ON _stock_information.product_id = e.entity_id WHERE (e.status = 1) ORDER BY `recommended_2` DESC, `sold_out_2` ASC, `e`.`show_from` DESC LIMIT 24"
Geriausi kelionių pasiūlymai el. paštu
Prenumeruokite mūsų naujienlaiškį ir nepraleiskite puikių kelionų pasiūlymų.
Užsisakykite naujienas el. paštu ir naudokitės geriausiais, tik Jums skirtais kelionių pasiūlymais!
Dėkojame. Nurodytu el. pašto adresu gavote patvirtinimo nuorodą. Prašome ją paspausti, kad užbaigtumėte prenumeratą.
Prašome palaukti...
Svetainėje naudojame slapukus (angl. cookies) norėdami suasmeninti turinį Jums. Spausdami mygtuką "Sutinku" Jūs sutinkate su šiomis nuostatomis. Sutikimą galite atšaukti ištrindami slapukus savo naršyklės nustatymuose. Daugiau