0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-dev`

0.0503 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2026-04-12'
AND `url` = 'https://dev.maineventtravel.com/user/login'
ORDER BY `views` DESC

0.0706 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-04-12'
AND `url` = 'https://dev.maineventtravel.com/user/login'

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

0.0003 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.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` = 'dev.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` = 'dev.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.0034 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.0003 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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0067 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 `news_articles`.`active` = '1'
ORDER BY `news_articles`.`date` DESC

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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0006 SECONDS: 
SELECT COUNT(*) AS `numrows` FROM `news_articles`
Test Environment | Test Environment | Test Environment | Hide me!
English
  1. Home
  2. Login

Login / Register

Latest News & Blogs

Tim Chung wins biggest GUKPT Main Event in history

The GUKPT always gets the new poker calendar off to a cracking start and GUKPT London – which ended on Sunday at the Poker Room at the Victoria Casino – certainly pulled out all the stops with the biggest ever GUKPT Main Event in the tour’s long history.

MainEventTravel.com partnering Casino Malta for two Battle of Malta festivals in 2022

For the first time ever, Casino Malta will be hosting two Battle of Malta festivals this year with the first event in April, followed by a second in the Autumn.

ATOL and PTS Protection

Main Event Travel Ltd (SC830886) is a proud member of Protected Trust Services (PTS). Our member number is PT6402. Our ATOL Licence is 12890.

All flights and flight-inclusive holidays on this website are financially protected by the ATOL scheme. When you pay, you will be supplied with an ATOL Certificate. Please ask for it and check that everything you booked (flights, hotels and other services) is listed on it. Please see our booking conditions for further information, or for more information about financial protection and the ATOL Certificate, go to www.caa.co.uk.

Our holidays are financially secured by PTS. Flight-inclusive packages are covered by ATOL. When booking your holidays with us, you can rest assured your funds are fully protected. In the unlikely event that any supplier fails, all funds are held in an Independent Trust Account.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
ATOL Protected Protected Trust Services
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.