Coventry Destination Guide - MainEventTravel.com

0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0055 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-27' AND `url` = 'https://www.maineventtravel.com/destination/guide/coventry-destination-guide' ORDER BY `views` DESC

0.0077 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-27' AND `url` = 'https://www.maineventtravel.com/destination/guide/coventry-destination-guide'

0.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0005 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0065 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0007 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0002 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'coventry-destination-guide'

0.0038 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(52.4128163 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(52.4128163 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-1.5089521 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 5 ORDER BY `news_article_destinations`.`display_order`

0.0002 SECONDS:
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country` FROM `uapi_airports` JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code` JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city` WHERE `airport_code` = 'EMA'

Coventry Destination Guide

Thanks to Grosvenor’s annual Goliath festival and the continuing appeal of events such as the GUKPT and 25/50 series, Coventry has always been a major poker destination. However, things are really gearing up for 2024 with the launch of 888poker’s new UK Poker League and the return of the UK Poker Open which made its debut in Coventry last year.

Coventry is sometimes overlooked as a tourist destination but this historic city has a lot going for it. Legend has it that Coventry was the birthplace of St. George – dragon slayer and patron saint of England. However, perhaps Coventry’s most enduring legend is the tale of Lady Godiva. She is said to have ridden naked on horseback through the city streets in a bid to persuade her husband, Leofric the Earl of Mercia, to reduce the heavy taxes he had imposed on the citizens. Whether true or not, a Grade II listed statue of Lady Godiva commemorates the story.

During the Middle Ages, Coventry was one of the largest and most vibrant cities in England. It later became an important industrial centre and was the birthplace of the British motor industry when Daimler set up shop in a disused Coventry cotton mill in 1896.