0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0110 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-23' AND `url` = 'https://www.maineventtravel.com/destination/articles/london-destination-guide/Empire-Casino-Leicester-Square' ORDER BY `views` DESC

0.0103 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-23' AND `url` = 'https://www.maineventtravel.com/destination/articles/london-destination-guide/Empire-Casino-Leicester-Square'

0.0004 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.0007 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.0004 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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0036 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.0002 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.0015 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `url_name` = 'Empire-Casino-Leicester-Square'

0.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '933'

0.0034 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`

Tuesday 9th January, 2024

Empire Casino, Leicester Square

By Mad Harper

Live Events Main Event Travel News Blogs

Empire Casino, Leicester Square

The Empire Casino offers a busy roster of daily tournaments including a £108 tournament with unlimited re-entries which kicks off at noon every Sunday (apart from the first of the month.) Players get a 12,000 starting stack with 20-minute levels. Other tourneys during the week include Mondays, Fridays, Saturdays (£58); Tuesdays & Thursdays (£78), and Wednesdays (£88).

The Empire promises a warm welcome from Cardroom Manager Rommel Lapinid and his dealers, many of whom are players themselves. The poker room also has a dedicated bar and HD screens showing all the latest sports action. All tables are equipped with electronic card shufflers and mobile phone chargers. The buy-ins vary to accommodate all gamers - from £50 in the cash games and from £58 in tournaments. Bigger buy-ins are offered daily too.

Promotions at the Empire include the monthly Cash Race with players earning points on a daily top 50 leader board – giving the top 15 players each month the chance to compete for cash prizes. The overall winner snags an exclusive Team Empire Package to compete at the 2024 WSOP. Other promotions include a £500 cash prize for winning a hand with a Royal Flush and a cash game rake-free pass for players winning with 5/6 suited.

You can follow updates from the Empire Casino on Twitter.

Top Hotel Picks for the Empire Casino

Staying right bang in the middle of London is never going to be cheap but there are some lovely options near the Empire Casino that won’t break the bank – and it’s certainly a treat to be staying in the heart of London’s West End.

The 4* Hotel Indigo is just round the corner from the Empire and boasts a fabulous rooftop bar affording spectacular views of the city. The art deco-styled property mirrors the 1920s glamour of its theatrical surroundings and has a 24-hour front desk and free WiFi.

The Londoner Hotel is definitely not cheap but it’s very glamorous and having an onsite spa with pool and gym is a real treat. There are six concept restaurants and bars including a rooftop lounge. The Residence guest-only club provides complimentary antipasti, soft drinks, tea and coffee all day.

At the more budget end, there are two Thistle Hotels to choose from – Thistle London Picadilly (pictured below) is two minutes’ walk from the Empire Casino and Thistle Trafalgar Square is just three minutes away. The Thistle Piccadilly has an all-day dining room, 24hr pizza delivery service and fully-equipped gym. The Thistle Trafalgar Square has an on-site restaurant and bar, plus 24-hour room service.

Zedwell Piccadilly puts sleep first and foremost so if shut-eye is the only thing you want from your room, it’s a great option. The minimalist soundproofed design is emphatically clutter-free – with no distractions such as windows, TV or electronics. Their “Cocoon 8” rooms (including two double bunk beds) are ideal for players sharing.