Найти
Принятие
Принятие Число:
Время:
Возврат
Возврат Число:
Время:
Валюта
Secured by COMODO
Специальные предложения - Котор Центр - Выберите
SELECT DISTINCT cars.group_id, periods.coop_id, ctcountry.country_ru as country, ctregion.name2_ru as region, ctlocation.name2_ru as location, ctlocation.id as location_id, ctregion.id as reg_id, ctcountry.id as country_id, cars.car_id, cars.name_en as car, cars.picture, groups.name_en, groups.name_en as group_en, ROUND(pricelists.day_7/7) as price, periods.name_en as period, periods.datefrom, periods.dateto, d.new_id, ctlocation_ids.new_id as new_loc_id FROM special_offers INNER JOIN ctcountry ON special_offers.country_id=ctcountry.id INNER JOIN ctregion ON special_offers.region_id=ctregion.id INNER JOIN ctregion_ids d ON special_offers.region_id=d.region_id INNER JOIN ctlocation ON special_offers.location_id=ctlocation.id INNER JOIN ctlocation_ids ON ctlocation.id = ctlocation_ids.location_id INNER JOIN cars ON special_offers.car_id=cars.car_id INNER JOIN groups ON cars.group_id = groups.group_id INNER JOIN pricelists ON cars.group_id = pricelists.group_id INNER JOIN periods ON pricelists.period_id = periods.period_id WHERE d.brand_id=1 AND d.level='W' AND UNIX_TIMESTAMP() between UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(datefrom,'-2019'), '%d-%m-%Y' ) , ' 00:00:01' )) AND UNIX_TIMESTAMP( concat( STR_TO_DATE( concat(dateto,'-2019'), '%d-%m-%Y' ) , ' 23:59:59')) AND special_offers.site_level='W' AND special_offers.page='R' AND special_offers.region_id = '189' AND ctlocation_ids.brand_id=1 AND ctlocation_ids.level='W' GROUP BY special_offers.id ORDER BY RAND()

Котор Центр
Прокат Авто

Mini Economy (A)
Skoda Citigo

от €19/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Small Automatic (E3)
Nissan Micra Automatic

от €27/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Economy (B)
Fiat Panda

от €21/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Medium Family Diesel (C2)
Suzuki Swift Diesel

от €27/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Multi Purpose Vehicles (D4)
Hyundai Matrix

от €32/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Mini Vans 7 Seats Automatic (L2)
Nissan Evalia Automatic

от €54/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Large Automatic (E1)
Hyundai I30 Automatic

от €37/день

(22/08 - 04/09)

Котор Центр
Прокат Авто

Large Family (D1)
Opel Astra

от €27/день

(22/08 - 04/09)