Mietauto Chile
StartseiteEasyTerra Mietauto Chile ist ein unabhängiges Unternehmen. In unserem System werden die Preise bekannter Mietwagen-Unternehmen miteinander verglichen. So wird gewährleistet, dass Kunden überall günstige Leihwagen mieten können.
Table 'easyterra_v2.et_locations_rates' doesn't exist
SELECT AVG(et_locations_rates.price_per_day / et_currencies.euro_exchange_rate) AS avg_cheapest_daily_rate, et_cities_rank.city_id AS city_id, tr_countries.name AS country_name, tr_countries.seo_name AS country_seo_name, et_cities_rank.total_sum AS total_sum, tr_cities.name AS city_name, tr_cities.seo_name AS city_seo_name FROM et_locations_rates INNER JOIN et_locations_to_cities ON et_locations_to_cities.location_id = et_locations_rates.location_id INNER JOIN et_currencies AS et_currencies ON et_currencies.currency = 'USD' INNER JOIN et_cities_rank AS et_cities_rank ON et_cities_rank.city_id = et_locations_to_cities.city_id AND et_cities_rank.site_id = et_locations_rates.site_id AND et_cities_rank.total_sum != 0 INNER JOIN et_cities AS et_cities ON et_cities.city_id = et_locations_to_cities.city_id AND et_cities.connections != 0 INNER JOIN et_languages AS languages ON languages.lang_code = 'de' INNER JOIN et_cities_to_countries AS et_cities_to_countries ON et_cities_to_countries.city_id = et_cities_rank.city_id AND et_cities_to_countries.country_id = 21 LEFT JOIN tr_countries AS tr_countries ON et_cities_to_countries.country_id = tr_countries.country_id AND languages.id = tr_countries.language_id LEFT JOIN tr_cities AS tr_cities ON et_cities_rank.city_id = tr_cities.city_id AND languages.id = tr_cities.language_id WHERE 1 AND et_cities_rank.site_id = 44 AND UNIX_TIMESTAMP(CONCAT(et_locations_rates.year,et_locations_rates.month,'01')) > 1268227985 AND UNIX_TIMESTAMP(CONCAT(et_locations_rates.year,et_locations_rates.month,'01')) < 1273494785 GROUP BY et_cities_rank.city_id ORDER BY et_cities_rank.total_sum DESC LIMIT 0, 6