1. Home
  2. Europe
  3. Turkey
  4. Istanbul Ataturk Airport (IST)
 

Sanitised car hire at Istanbul Airport

Look out for this icon to see which car hire brands have committed to maintaining sanitisation measures as per WHO COVID-19 guidelines, the following car hire companies at Istanbul Airport, Turkey offer sanitised rental cars:

At present, none of the car rental companies at Istanbul Airport have committed to offering sanitised cars.

Sanitised car
This car rental company has committed to maintaining sanitisation measures as per WHO COVID-19 guidelines.
  • ALAMO
  • AVEC CAR RENTALS
  • AVIS
  • BUDGET
  • CARWIZ
  • ENTERPRISE
  • EUROPCAR
  • GOLDCAR
  • GREEN MOTION
  • NATIONAL
  • RHODIUM

Cheapest car hire at Istanbul Airport

Peugeot 3008

5 Adults, 5 Doors

From 33.71 EUR/day
Peugeot 3008

7 Days rental at 236.02 EUR from 22/03/2021

  2 |
  Automatic |
  Yes

Ford Custom

8 Adults, 5 Doors

From 65.80 EUR/day
Ford Custom

7 Days rental at 460.60 EUR from 22/03/2021

  4 |
  Automatic |
  Yes

Renault Clio

5 Adults, 5 Doors

From 13.60 EUR/day
Renault Clio

7 Days rental at 95.24 EUR from 22/03/2021

  2 |
  Manual |
  Yes

Fiat Egea

5 Adults, 4 Doors

From 18.60 EUR/day
Fiat Egea

7 Days rental at 130.23 EUR from 22/03/2021

  4 |
  Manual |
  Yes

Citroen C-Elysee

5 Adults, 4 Doors

From 15.30 EUR/day
Citroen C-Elysee

7 Days rental at 107.15 EUR from 22/03/2021

  4 |
  Manual |
  Yes

Audi Q7

7 Adults, 5 Doors

From 144.89 EUR/day
Audi Q7

7 Days rental at 1014.27 EUR from 22/03/2021

  5 |
  Automatic |
  Yes

Renault Symbol

5 Adults, 3 Doors

From 13.00 EUR/day
Renault Symbol

7 Days rental at 91.02 EUR from 22/03/2021

  3 |
  Manual |
  Yes

Hyundai i10

4 Adults, 3 Doors

From 13.00 EUR/day
Hyundai i10

7 Days rental at 91.02 EUR from 22/03/2021

  2 |
  Manual |
  Yes

Dacia Lodgy

7 Adults, 5 Doors

From 22.66 EUR/day
Dacia Lodgy

7 Days rental at 158.63 EUR from 22/03/2021

  2 |
  Manual |
  Yes

*daily rates in Istanbul Airport based on a 1 day rental (24hr period) and for guidance purposes only.

Useful to know about Istanbul Airport

  • Istanbul has two major airports; this one is called Ataturk International Airport.
  • It’s found on the European side of the Bosphorus, 15m west of the city centre.
  • The airport opened in 1924.
  • It’s the world’s 17th busiest airport behind Dallas Airport and Frankfurt Airport.
  • Last year 37m people travelled through its terminals.

Istanbul Airport car hire reviews

  •  
  •  
  •  
  •  
  •  
 
We welcome reviews from all of our customers, see what others have to say about us...
Rated 3.8 / 5 | 1,800 reviews

Best car rental companies in Istanbul Airport

8.5
No.1: EUROPCAR,
based on 104 reviews
91
91
80
90
75
6 min (average wait time)
8.0
No.2: AVEC CAR RENTALS,
based on 32 reviews
78
83
80
80
85
8 min (average wait time)
7.2
No.3: CARWIZ,
based on 18 reviews
73
71
70
72
80
26 min (average wait time)

Nearest car hire pickup locations at or near Istanbul Airport

GLOBAL RENT A CAR

Gokturk Merkez Mah. Istanbul Cad. No:48/d , Gokturk, Istanbul, Turkey

AVIS

Maslak Mahallesi Ataturk Oto, Sanayi Sitesi 39 Sokak 343/1/1, Istanbul, 34485

AVIS

Nish Istanbul C Blok Kat:10 N0:124 Cobancesme , Mah. Sanayi Cad. Bahcelievler-istanbul, Istanbul

AVIS

Cumhuriyet Mahallesi, Dervis Eroglu No 1/1, Beylikduzu Istanbul, 34500

AUTO-UNION

Konaklar Mah. Selvili Sok. No : 7/a 4.levent,besiktas/ Istanbul, Istanbul, 4. Levent

SIXT

Tepekik Yolu Alkent Alisveris, Istanbul, 34000

Istanbul Airport car hire information

Istanbul Airport car hire information

  • 8.6/10
    Best Rated Agent:
    Europcar Direct
  • € 91.00
    Average price:
    (per week)
  • € 13.00
    Best Price:
    Per Week
  • 73
    Most Popular Type:
    Compact
  • 25
    Most popular model:
    Renault Clio
  • 249
    Total Cars Available
     

Average prices per day for car hire at Istanbul Airport

ItemPercent
January€ 33
February€ 32
March€ 32
April€ 31
May€ 35
June€ 40
July€ 48
August€ 52
September€ 41
October€ 37
November€ 36
December€ 35
ItemPercent
January€ 29
February€ 28
March€ 26
April€ 26
May€ 29
June€ 34
July€ 40
August€ 44
September€ 28
October€ 31
November€ 31
December€ 30
ItemPercent
January€ 61
February€ 62
March€ 64
April€ 79
May€ 57
June€ 63
July€ 65
August€ 65
September€ 63
October€ 39
November
December€ 83
ItemPercent
January€ 40
February€ 40
March€ 40
April€ 39
May€ 44
June€ 58
July€ 82
August€ 93
September€ 57
October€ 43
November€ 41
December€ 49
ItemPercent
January€ 96
February€ 104
March€ 108
April€ 76
May€ 94
June€ 109
July€ 111
August€ 105
September€ 92
October€ 90
November€ 79
December€ 112
ItemPercent
January€ 22
February€ 21
March€ 20
April€ 24
May€ 27
June€ 29
July€ 36
August€ 37
September€ 27
October€ 23
November€ 23
December€ 20
ItemPercent
January€ 53
February€ 48
March€ 51
April€ 54
May€ 66
June€ 88
July€ 89
August€ 82
September€ 80
October€ 58
November€ 50
December€ 64
ItemPercent
January€ 37
February€ 37
March€ 38
April€ 39
May€ 58
June€ 66
July€ 108
August€ 128
September€ 91
October€ 67
November€ 61
December€ 39

Select category to see average car hire prices at Istanbul Airport

*average daily rates based on 7 day rental, search for today's best prices

FAQs about car hire at Istanbul Airport

How much does car hire at Istanbul Airport cost?

Car hire at Istanbul Airport costs as little as €13.00 per day, however the average price across all suppliers for a Compact class vehicle is €31.50 per day. The most expensive car to hire is €183.70 per day from AVIS for a Volvo XC90.

What car hire companies offer sanitised car rental in Istanbul Airport?

11 car hire brands have committed to maintaining sanitisation measures as per WHO COVID-19 guidelines in Istanbul Airport, including AVEC CAR RENTALS, RHODIUM, ALAMO, see the full list here.

What car hire companies offer sanitised car rental at Istanbul Airport?

None of the car hire companies at Istanbul Airport are currently offering sanitised cars as per WHO COVID-19 guidelines.

Who is the best car rental agent at Istanbul Airport?

Based on recent customer reviews over the last 3 months, Europcar Direct has the highest customer rating for car hire at Istanbul Airport with a score of 8.5/10

with Avec Car Rentals rated second best with a score of 8.0/10

.

How much does it cost to hire a compact car at Istanbul Airport?

Today’s cheapest price for compact car hire at Istanbul Airport is €91.02 per week from CIRCULAR.

Who is the cheapest car hire agent at Istanbul Airport?

The cheapest car hire company at Istanbul Airport is CIRCULAR, with prices for a Mini class car such as the Hyundai i10 available from as little as €91.00 per week.

How much is fuel at Istanbul Airport?

You can expect to pay €0.805/ltr of petrol and €0.735/ltr of diesel at Istanbul Airport. You’ll pay a premium if refilling at motorway services of up to 10%.

What car hire agencies are available at Istanbul Airport?

We can arrange great deals on car hire at Istanbul Airport with leading car hire companies such as ALAMO, AUTO-UNION, AVEC CAR RENTALS, AVIS, BUDGET, CARWIZ, CENTRAL, CIRCULAR, ENTERPRISE, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, NATIONAL, RHODIUM as well as reputable, local car hire companies.

What type of car can I hire at Istanbul Airport?

We can arrange Compact, Compact Elite, Economy, Fullsize, Intermediate, Intermediate Elite, Luxury, Mini, Premium, Premium Elite, Special, Standard and Standard Elite class rental cars at Istanbul Airport.

How much does it cost to hire a convertible car at Istanbul Airport?

We don’t currently have any convertible cars to hire at Istanbul Airport, but we are working in it and please check dates for future rentals.
The price at the moment for a convertible rental car at Istanbul Airport is € per week from for a .

Do you have a discount code for car hire at Istanbul Airport?

We don’t have any discount codes for car hire at Istanbul Airport at the moment, however CIRCULAR rates start from just €91.00 per week. If you’ve found a cheaper price than €91.00 from CIRCULAR in Istanbul - New Airport or any other rental agent, let us know and we’ll do our best to beat it.

How much does it cost to hire a car for a week at Istanbul Airport?

The cheapest price to hire a car for a week at Istanbul Airport is €91.00 per week with an average price of €220.50 per week across all car hire companies.

Information about car hire agents at Istanbul Airport

Most popular car hire companies at Istanbul Airport

  • Budget (tel: 00905495622314)
  • Avis (tel: (90) 5498271110)
  • Enterprise (tel: 00902129702937)
  • Alamo (tel: 00902129702937)
  • Alamo (tel: 00902129702937)
  • Circular (tel: +905337323064,+905321311400,+905337322532)
  • Essence (tel: +90 212 603 65 85)
  • Green motion (tel: +90 212 909 1778 )
  • Europcar (tel: 90 533 7608498)
  • Hertz (tel: (+90) 212 465 59 99 )

Pick-up locations for car hire companies at Istanbul Airport

  • Budget (Istanbul Airport Arrival Hall, Istanbul, 34283)
  • Avis (Tayakadin Mh. Terminal, Istanbul, 34283)
  • Enterprise (ISTANBUL AIRPORT, TAYAKADIN MH.ULUBATLI HASAN CD, ISTANBUL, 34277)
  • Alamo (ISTANBUL AIRPORT, TAYAKADIN MH.ULUBATLI HASAN CD, ISTANBUL, 34277)
  • Alamo (ISTANBUL AIRPORT, TAYAKADIN MH.ULUBATLI HASAN CD, ISTANBUL, 34277)
  • Circular (Istanbul Havalimani Dis Hatlar Terminali)

Car hire company reviews at Istanbul Airport

  • Europcar Direct: Rated 8.5/10 from 7 reviews
  • Avec Car Rentals: Rated 8.0/10 from 11 reviews
  • Carwiz: Rated 7.2/10 from 18 reviews
  • Essence Car Rental: Rated 7.0/10 from 30 reviews
  • Global Rent a Car: Rated 7.0/10 from 55 reviews
  • Hertz: Rated 6.8/10 from 6 reviews

Istanbul Ataturk Airport Mini Guide

The Airport
You will find Ataturk International Airport 15 miles west of Istanbul and it is one of two airports that serve the city. Last year it handled over 37 million passengers making it one of the busiest in Europe. Accessing the airport is quick and easy, and once here, you’ll find over 6,000 parking spaces either covered or open air together with valet and disabled parking.

How Can I Get There?
Over ninety airlines fly there as it’s a major transportation hub in the Eastern Mediterranean. Turkish Airlines are the main carrier but budget airlines such as easyJet also fly there. The majority of the flights are scheduled and some are seasonal.

How to Get to Your Destination
There are a number of ways to reach your final destination. The easiest is take the Metro or light railway from the airport which stops at a number of places, including the central bus station, before terminating at Aksaray. A shuttle bus can take you to the ferry bus at Bakirkoy which will then stop at various wharves in and around the city. Havas operate a shuttle bus from the airport in conjunction with Turkish Airlines.

There are many municipal buses but they are often overcrowded and unreliable. The most convenient is the route that takes you into Taksim Square. There are many car hire companies at the airport whose desks are located in the arrivals public area. As the airport is so busy it is recommended that you pre-book a vehicle and send a group member through to complete final paperwork to save long queues whilst others collect the luggage. Leaving the airport to get to the city and other destinations is easy. The airport access road takes you onto the coastal highway then onto the D100 which has access to the Trans European Motorway system.

Public Information
You can find the information desk in the arrivals/departures public area. It can deal with airport enquiries, accommodation and onward travel details.

Facilities
  • There are banks and a currency exchange office at the airport on both the public side and airside parts of the terminal. Additionally, there are several ATMs around the airport. Shopping here is interesting with the shopping area set out like a bazaar. Most sell only traditional Turkish goods and souvenirs but a second section sells fashion, accessories, gifts, toys, books and more. The duty free shop here is large and has an extensive range of items from alcohol products to tobacco, cigarettes and cigars plus chocolate, perfumery and electrical goods.
  • There is a wide range of places to eat there to suit all tastes and budgets from the fast food outlets to café snack bars and on to haute cuisine dining either of an international or local flavour.
  • There is a medical centre there called PortClinic which is staffed by qualified doctors and nurses. You’ll find it off the main public area.
  • Wi-Fi is available free of charge in the lounges but is payable elsewhere across the airport on a pay per use basis.
  • There are six mosques across the site for worship.
Extra Assistance
Ataturk International Airport is disabled friendly and has staff dedicated to helping passengers with reduced mobility get through the airport experience. There are also Braille keypads for lifts and telephones and tactile pathways for accessing the important parts of the airport. If possible you should give the airport 48 hours’ notice of your arrival so they can help fully but if this isn’t possible general assistance is available. Please ensure you inform your airline well before travelling so that necessary steps can be taken to assist you on board the aeroplane. 

Ataturk Airport is one of the busiest airports in Europe and is a gateway to this fabulous city. Spanning two continents and with a multitude of history and culture, you’ll need a lot of time there to see it all. Hire a car to experience the chaos of Taksim Square then head to the Topkapi Palace to see the famous emerald immortalised in the Michael Caine thriller ‘Topkapi’.

For something completely different, head under the square to the ancient Roman water cisterns where there’s now a café and often live music under one of the busiest parts of the city.
  • Istanbul Airport car hire special offers

    We currently have 166 special offers for car rental in Istanbul Airport including;

  • 10% off
    This special price is inclusive of a 10% discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • Express check-in
    With this car you get express check-in service - you can skip the queue and be among the first to get served at the rental counter available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • Free additional driver
    With this car you get 1 free additional driver available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • GPS Included
    Free GPS is included in the price available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • Pre-Registration available
    For faster, easier car hire, add driver details before pick-up available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR121.99 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR15.43 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR15.92 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR16.62 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR17.72 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR17.98 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR18.83 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR19.33 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR20.03 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR22.93 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR23.14 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR23.63 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR25.09 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR25.14 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR25.74 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR27.14 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR36.56 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR40.86 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.
  • This price includes a special discount
    This special price is inclusive of a EUR65.30 discount. Discount is based on standard rate from the car hire agent available from ALAMO, AVEC CAR RENTALS, CARWIZ, CENTRAL, ESSENCE, EUROPCAR, GOLDCAR, GREEN MOTION, KEDDY BY EUROPCAR, RHODIUM.

Useful Links

Next Upcoming Holiday

  •  

    Saturday 20 Mar 2021

    March Equinox - Season

Customer questions about Istanbul Airport car hire

I’m looking for a car of 9 passengers for the period May 10th till 18th taken and returned to Istanbul Airport. 

Hello, we can certainly arrange that for you, please bear with me whilst I quote. We have vehicles such as the Mercedes Vito and VW Transporter that I am sure would be suitable, as well as other minibuses.

Other car hire locations in Turkey

We specialise in car rentals throughout Turkey fo find you the best price and that's a promise...

SELECT TOP 1 displayhomepageacutalimage, CityKeyword=(SELECT TOP 1 CityKeyword FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' AND DocumentPageTemplateID=1955 and CountryCode = 'TR' and BookingEngineLocationID=3755), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'TR' AND BookingEngineLocationID=3755) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'TR' GROUP BY displayhomepageacutalimage, CityKeyword, NodeAliasPath, CountryCode ORDER BY CountryCode SELECT TOP 1 displayhomepageacutalimage, CityKeyword=(SELECT TOP 1 CityKeyword FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' AND DocumentPageTemplateID=1955 and CountryCode = 'TR' and BookingEngineLocationID=51804), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'TR' AND BookingEngineLocationID=51804) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'TR' GROUP BY displayhomepageacutalimage, CityKeyword, NodeAliasPath, CountryCode ORDER BY CountryCode SELECT TOP 1 displayhomepageacutalimage, CityKeyword=(SELECT TOP 1 CityKeyword FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' AND DocumentPageTemplateID=1955 and CountryCode = 'TR' and BookingEngineLocationID=3788), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'TR' AND BookingEngineLocationID=3788) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'TR' GROUP BY displayhomepageacutalimage, CityKeyword, NodeAliasPath, CountryCode ORDER BY CountryCode SELECT TOP 1 displayhomepageacutalimage, CityKeyword=(SELECT TOP 1 CityKeyword FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' AND DocumentPageTemplateID=1955 and CountryCode = 'TR' and BookingEngineLocationID=964), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'TR' AND BookingEngineLocationID=964) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'TR' GROUP BY displayhomepageacutalimage, CityKeyword, NodeAliasPath, CountryCode ORDER BY CountryCode
from
€18
per day
ItemPercent
Jan€ 15
Mar€ 13
Apr€ 15
May€ 15
Jun€ 21
Jul€ 24
Aug€ 26
Sep€ 22
Oct€ 17
Nov€ 15
Dec€ 15
from
€28
per day
ItemPercent
Jan€ 23
Mar€ 18
Apr€ 26
May€ 29
Jun€ 25
Jul€ 37
Aug€ 42
Sep€ 31
Oct€ 24
Nov€ 30
Dec€ 24
from
€38
per day
ItemPercent
Jan€ 34
Mar€ 33
Apr€ 30
May€ 38
Jun€ 42
Jul€ 46
Aug€ 46
Sep€ 46
Oct€ 34
Nov€ 37
Dec€ 34
from
€30
per day
ItemPercent
Jan€ 37
Mar€ 26
Apr€ 27
May€ 30
Jun€ 31
Jul€ 29
Aug€ 34
Sep€ 34
Oct€ 31
Nov€ 21
Dec€ 29