London Destination Guide - MainEventTravel.com

0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/destination/guide/london-destination-guide' ORDER BY `views` DESC

0.0096 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/destination/guide/london-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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 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.0040 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.0004 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` = 'london-destination-guide'

0.0042 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(51.5072178 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(51.5072178 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-0.1275862 - 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` = 4 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` = 'LHR'

London is a poker lover’s paradise, offering a wide range of venues for players of all levels. While there are many options, four casinos stand out for their exceptional poker experiences.

The Poker Room at Grosvenor’s Victoria Casino

Located in central London, the Poker Room at Grosvenor’s Victoria Casino is renowned for its friendly atmosphere and range of poker options, including cash games and tournaments. It’s a popular choice for both locals and international players, with regular promotions adding to the excitement.

The Hippodrome Casino

The Hippodrome Casino, situated in the West End, is a historic venue offering a luxurious poker experience. It hosts major international tournaments and has a vibrant, 24-hour gaming environment, ensuring players always find action, whether it’s cash games or competitive events.

The Empire Casino in Leicester Square

In the heart of Leicester Square, The Empire Casino offers a dedicated poker room with a mix of cash games and tournaments. Its convenient location makes it ideal for tourists and locals alike, with a welcoming atmosphere for players of all levels.

Aspers Stratford

Located in Westfield Stratford City, Aspers Stratford combines modern facilities with a dynamic poker scene. It offers a variety of games and regular tournaments, attracting a diverse crowd from beginners to seasoned players, with a great mix of cash games and promotions.

These four casinos offer world-class poker action, each with its own unique style. Whether you’re looking for casual play or competitive tournaments, London has something for everyone.