1. Home
  2. Europe
  3. Spain
  4. Santiago De Compostela Airport
 

Sanitised car hire at Santiago De Compostela 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 Santiago De Compostela Airport, Spain offer sanitised rental cars:

At present, none of the car rental companies at Santiago De Compostela 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
  • AVIS
  • BUDGET
  • DRIVALIA
  • ENTERPRISE
  • EUROPCAR
  • GOLDCAR
  • HERTZ
  • INTERRENT
  • KEDDY BY EUROPCAR
  • OK RENT A CAR
  • RHODIUM
  • SIXT
  • THRIFTY

Cheapest car hire at Santiago De Compostela Airport

Nissan Micra

4 Adults, 3 Doors

From 7.20 EUR/day
Nissan Micra

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

  2 |
  Manual |
  Yes

Nissan Qashqai

5 Adults, 5 Doors

From 11.50 EUR/day
Nissan Qashqai

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

  4 |
  Manual |
  Yes

Audi A3

5 Adults, 5 Doors

From 29.70 EUR/day
Audi A3

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

  3 |
  Manual |
  Yes

Opel Insignia

5 Adults, 4 Doors

From 26.36 EUR/day
Opel Insignia

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

  4 |
  Manual |
  Yes

Mercedes E Class

5 Adults, 4 Doors

From 40.71 EUR/day
Mercedes E Class

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

  4 |
  Automatic |
  Yes

Mercedes C Class

5 Adults, 4 Doors

From 35.28 EUR/day
Mercedes C Class

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

  4 |
  Automatic |
  Yes

Opel Zafira

5 Adults, 5 Doors

From 35.00 EUR/day
Opel Zafira

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

  4 |
  Manual |
  Yes

Smart Forfour

4 Adults, 3 Doors

From 5.83 EUR/day
Smart Forfour

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

  1 |
  Manual |
  Yes

Volkswagen Golf

5 Adults, 5 Doors

From 8.31 EUR/day
Volkswagen Golf

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

  3 |
  Manual |
  Yes

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

Useful to know about Santiago De Compostela Airport

  • The Way of St James passes immediately adjacent to the airport so you can get off your plane and start your pilgrimage.
  • It is Galicia's main airport handling 2.2 million passengers a year.
  • The airport handles seasonal flights from Ireland's Dublin airport for a large number of Irish pilgrims.
  • For airport enthusiasts, Luis Atrilla has written the History of Santiago de Compostela Airport.
  • The airport is a combined civilian and military installation.

Santiago De Compostela 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 Santiago De Compostela Airport

9.3
No.1: ALAMO,
based on 199 reviews
94
96
83
95
98
17 min (average wait time)
8.6
No.2: SIXT,
based on 423 reviews
95
90
73
85
85
15 min (average wait time)
7.7
No.3: BUDGET,
based on 302 reviews
81
80
65
79
78
15 min (average wait time)

Nearest car hire pickup locations at or near Santiago De Compostela Airport

ALAMO

Estacion De Tren Horreo S/n - Edf Renfe, Santiago De Compostela, 15706

AVIS

Avda De Bertoa 34, Carballo, 15100

ALAMO

Alvedro Aeropuerto Alvedro-culleredo, Alvedro, La Coruna, 15180

ALAMO

Estacion De Tren, Avenida Del Ferrocarril, La Coruna, 15008, Cr

EUROPCAR

Estacion De Tren Avenida Do Ferrocarril S/n, La Coruna, 15007

FLIZZR

Santiago De Compostela Airport car hire information

Santiago De Compostela Airport car hire information

  • 9.4/10
    Best Rated Agent:
    Alamo EHI
  • € 40.81
    Average price:
    (per week)
  • € 5.83
    Best Price:
    Per Week
  • 43
    Most Popular Type:
    Compact
  • 10
    Most popular model:
    Fiat 500
  • 161
    Total Cars Available
     

Average prices per day for car hire at Santiago De Compostela Airport

ItemPercent
January€ 26
February€ 27
March€ 29
April€ 23
May€ 21
June€ 23
July€ 53
August€ 40
September€ 29
October€ 27
November€ 23
December€ 32
ItemPercent
January€ 21
February€ 21
March€ 27
April€ 23
May€ 25
June€ 27
July€ 44
August€ 37
September€ 28
October€ 26
November€ 24
December€ 26
ItemPercent
January€ 59
February€ 58
March€ 62
April€ 65
May€ 68
June€ 69
July€ 93
August€ 112
September€ 80
October€ 80
November€ 80
December€ 72
ItemPercent
January€ 36
February€ 35
March€ 41
April€ 26
May€ 25
June€ 33
July€ 59
August€ 48
September€ 45
October€ 45
November€ 39
December€ 49
ItemPercent
January€ 50
February€ 50
March€ 42
April€ 31
May€ 129
June€ 127
July
August
September
October
November
December€ 54
ItemPercent
January€ 16
February€ 16
March€ 19
April€ 14
May€ 11
June€ 13
July€ 30
August€ 25
September€ 18
October€ 16
November€ 14
December€ 19
ItemPercent
January€ 49
February€ 49
March€ 46
April€ 36
May€ 35
June€ 40
July€ 63
August€ 69
September€ 56
October€ 44
November€ 45
December€ 49
ItemPercent
January€ 25
February€ 23
March€ 40
April€ 23
May€ 21
June€ 17
July€ 67
August€ 42
September€ 22
October€ 21
November€ 17
December€ 25

Select category to see average car hire prices at Santiago De Compostela Airport

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

FAQs about car hire at Santiago De Compostela Airport

How much does car hire at Santiago De Compostela Airport cost?

Car hire at Santiago De Compostela Airport costs as little as €5.80 per day, however the average price across all suppliers for a Mini class vehicle is €18.70 per day. The most expensive car to hire is €247.50 per day from ENTERPRISE for a Seat Alhambra.

What car hire companies offer sanitised car rental in Santiago De Compostela Airport?

14 car hire brands have committed to maintaining sanitisation measures as per WHO COVID-19 guidelines in Santiago De Compostela Airport, including DRIVALIA, ENTERPRISE, BUDGET, see the full list here.

What car hire companies offer sanitised car rental at Santiago De Compostela Airport?

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

Who is the best car rental agent at Santiago De Compostela Airport?

Based on recent customer reviews over the last 3 months, Alamo EHI has the highest customer rating for car hire at Santiago De Compostela Airport with a score of 9.3/10

with SIXT Corporate rated second best with a score of 8.6/10

.

How much does it cost to hire a compact car at Santiago De Compostela Airport?

Today’s cheapest price for compact car hire at Santiago De Compostela Airport is €58.20 per week from GOLDCAR.

Who is the cheapest car hire agent at Santiago De Compostela Airport?

The cheapest car hire company at Santiago De Compostela Airport is GOLDCAR, with prices for a Mini class car such as the Smart Forfour available from as little as €40.81 per week.

How much is fuel at Santiago De Compostela Airport?

You can expect to pay €1.203/ltr of petrol and €1.09/ltr of diesel at Santiago De Compostela Airport. You’ll pay a premium if refilling at motorway services of up to 10%.

What car hire agencies are available at Santiago De Compostela Airport?

We can arrange great deals on car hire at Santiago De Compostela Airport with leading car hire companies such as ALAMO, AVIS, BUDGET, DRIVALIA, ENTERPRISE, EUROPCAR, FLIZZR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT, THRIFTY as well as reputable, local car hire companies.

What type of car can I hire at Santiago De Compostela Airport?

We can arrange Compact, Compact Elite, Economy, Fullsize, Intermediate, Intermediate Elite, Luxury, Mini, Oversize, Premium and Standard class rental cars at Santiago De Compostela Airport.

How much does it cost to hire a convertible car at Santiago De Compostela Airport?

We don’t currently have any convertible cars to hire at Santiago De Compostela 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 Santiago De Compostela Airport is €237.49 per week from ALAMO for a Opel Astra Convertible.

Do you have a discount code for car hire at Santiago De Compostela Airport?

We don’t have any discount codes for car hire at Santiago De Compostela Airport at the moment, however GOLDCAR rates start from just €40.81 per week. If you’ve found a cheaper price than €40.81 from GOLDCAR in Santiago De Compostela - 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 Santiago De Compostela Airport?

The cheapest price to hire a car for a week at Santiago De Compostela Airport is €40.60 per week with an average price of €130.90 per week across all car hire companies.

Information about car hire agents at Santiago De Compostela Airport

Most popular car hire companies at Santiago De Compostela Airport

  • Europcar (tel: 34911505000)
  • Avis (tel: (34) 902105160)
  • Budget (tel: 902105160)
  • Goldcar (tel: +34 918 341 400)
  • Thrifty (tel: 981598893)
  • Sixt (tel: +34-871180192)
  • Hertz (tel: 981 598893)
  • Alamo (tel: 981599877)
  • Enterprise (tel: 981599877)
  • Keddy by europcar (tel: 34911505000)

Pick-up locations for car hire companies at Santiago De Compostela Airport

  • Europcar (LABACOLLA AEROPUERTO, SANTIAGO DE COMPOSTELA, 15820)
  • Avis (Aeropuerto De Santiago, Lavacolla, Santiago, 15820, La Coruna)
  • Budget (Budget Aeropuerto De Santiago, Lavacolla, Santiago La Coruna, 15820)
  • Goldcar (Estacion de Servicio La carabela - Flight numbers are essential, O Noval nº 1, N-634 km 71, Lavacolla, 15820, SANTIAGO DE COMPOSTELA)
  • Thrifty (Labacolla Airport, Santiago De Com, 15820)
  • Sixt (Zona rent a car - Llegadas, Santiago de Compostela, 15820)

Car hire company reviews at Santiago De Compostela Airport

  • Alamo EHI: Rated 9.3/10 from 20 reviews
  • SIXT: Rated 8.6/10 from 12 reviews
  • BUDGET EMEA: Rated 7.7/10 from 16 reviews
  • Enterprise: Rated 7.5/10 from 10 reviews
  • Hertz: Rated 7.0/10 from 7 reviews
  • Keddy by Europcar (Corporate): Rated 6.9/10 from 166 reviews

Santiago De Compostela Airport Mini Guide

Who Goes to Santiago?
Well, if you’re a Catholic, one of your dreams will be to take the pilgrimage to Santiago de Compostela and the cathedral dedicated to the saint which gives the city its name Saint Iago, which, translated from the Latin means St James. Many people who might struggle to do the whole of the 450 mile pilgrimage fly into the airport there and join the route immediately outside the terminal which takes them the four miles into the centre and to the cathedral. Even if you’re not interested in the religious aspect of the city, the buildings associated with it are incredible from the monumental cathedral to the Monasterio de San Martiño Pinario, one of the emblems of the city.

How do I Travel There?
Lavacolla Airport is found just on the outskirts of the city and many no frills carriers fly there. Most of the routes are from cities in predominantly Catholic countries and Ryanair do a flight from London’s Stansted Airport. Many choose to walk from the airport but if even that is too much then there’s the bus or taxi or one of the many shuttles provided by religious groups.

The Airport
It’s small and a little dated. Inside it’s a little claustrophobic with lowered ceilings and dim lighting. There are plans for a new terminal which will be very futuristic and designed with the religious nature of the city in mind.

What can I Expect When I Arrive?
Airside, the building isn’t attractive but at least it has air bridges to get you into the terminal. Once there you can walk the short distance through passport control and baggage reclaim to the main arrivals hall. For any airport information or directions there’s a central island information point with screens of arrival and departure information and tourist information plus it’s manned by a member of staff if you haven’t found the answer to your question.

If you need cash at the airport, there are two bank branches just after customs which can exchange money and which have ATMs. For the collection of a pre-booked hire car, the desks are immediately to your left as you exit customs. You could almost miss them if you don’t keep your eyes peeled. From outside the terminal you can catch a local bus or taxi into the centre or start walking. Many religious groups offer a ride into the city or accompanied walks from the airport.

And What About on the day of my Departure?
Once you’re checked in, the choice of things to do is good. There are numerous shops including gifts, toys and travel goods, household good shops, a jewellery shop specialising in the local Celtic style and a clothing outlet. Beyond security there is a duty free and gift shop combined where you can make your spirit, tobacco and perfumery purchases. If you get hungry before your flight you can choose from two cafeterias and an a la carte restaurant specialising in Galician cuisine.

Santiago de Compostela is such an important city in religion that you need to spend most of your time in and around the city. Hiring a car from the airport will enable you to get to your accommodation, comfortably and quickly and you’ll be able to use it to seek out the 'must-see' sights of the city including the final destination of pilgrims, Santiago Cathedral.

Many companies offer guided tours but armed with a decent guide book and one of our hire cars you'll be able to do the same trips at your leisure and for a fraction of the cost. We pride ourselves on our value for money, whilst still offering exceptional levels of service. That's why we were voted 'Best on the Road' in 2018, check this out to see all the awards we've won.
  • Santiago De Compostela Airport car hire special offers

    We currently have 118 special offers for car rental in Santiago De Compostela Airport including;

  • 15% off
    This special price is inclusive of a 15% discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • 20% off
    This special price is inclusive of a 20% discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • 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, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • Free additional driver
    With this car you get 1 free additional driver available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • Pre-Registration available
    For faster, easier car hire, add driver details before pick-up available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR10.20 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR10.56 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR10.70 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR11.08 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR11.66 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR12.24 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR12.68 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR12.71 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR13.27 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR14.55 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR15.25 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR15.67 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR16.29 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR16.51 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR17.11 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR17.45 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR18.65 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR19.00 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR19.54 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR20.14 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR21.74 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.
  • This price includes a special discount
    This special price is inclusive of a EUR23.34 discount. Discount is based on standard rate from the car hire agent available from ALAMO, EUROPCAR, GOLDCAR, HERTZ, INTERRENT, KEDDY BY EUROPCAR, OK RENT A CAR, RHODIUM, SIXT.

Useful Links

Next Upcoming Holiday

  •  

    Friday 29 Jan 2021

    St. Valero's Feast - Local holiday

Other car hire locations in Spain

We specialise in car rentals throughout Spain 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 = 'ES' and BookingEngineLocationID=177965), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'ES' AND BookingEngineLocationID=177965) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'ES' 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 = 'ES' and BookingEngineLocationID=382), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'ES' AND BookingEngineLocationID=382) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'ES' 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 = 'ES' and BookingEngineLocationID=1782), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'ES' AND BookingEngineLocationID=1782) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'ES' 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 = 'ES' and BookingEngineLocationID=2609), NodeAliasPath =(SELECT TOP 1 NodeAliasPath FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath like '%SpecialPages%' AND DocumentPageTemplateID=1955 AND CountryCode = 'ES' AND BookingEngineLocationID=2609) + '.aspx' FROM View_CONTENT_MenuItem_Joined CM WHERE CM.NodeAliasPath not like '%SpecialPages%' and CountryCode = 'ES' GROUP BY displayhomepageacutalimage, CityKeyword, NodeAliasPath, CountryCode ORDER BY CountryCode
from
€10
per day
ItemPercent
Jan€ 10
Mar€ 17
Apr€ 3
May€ 5
Jun€ 7
Jul€ 21
Aug€ 12
Sep€ 10
Oct€ 5
Nov€ 6
Dec€ 17
from
€18
per day
ItemPercent
Jan€ 18
Mar
Apr€ 8
May€ 16
Jun€ 10
Jul€ 29
Aug€ 29
Sep€ 15
Oct€ 15
Nov€ 18
Dec€ 22
from
€15
per day
ItemPercent
Jan€ 14
Mar€ 19
Apr€ 5
May€ 4
Jun€ 16
Jul€ 22
Aug€ 25
Sep€ 20
Oct€ 9
Nov€ 9
Dec€ 20
from
€18
per day
ItemPercent
Jan€ 14
Mar€ 21
Apr€ 9
May€ 14
Jun€ 11
Jul€ 24
Aug€ 25
Sep€ 17
Oct€ 17
Nov€ 17
Dec€ 30