0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0152 SECONDS:
SELECT *
FROM `page_views`
WHERE `date` = '2026-03-09'
AND `url` = 'https://www.maineventtravel.com/pages/page/our-team'
ORDER BY `views` DESC
0.0238 SECONDS:
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-03-09'
AND `url` = 'https://www.maineventtravel.com/pages/page/our-team'
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` = '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.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 *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0005 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.0061 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.0005 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 `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`url_name` = 'our-team'
0.0002 SECONDS:
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/our-team%'
Hi,
We'd like to send you push notifications so you never miss out on:
Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team

Owain Reed - In Memoriam
The IT Guy
Owain has a background in Web development and E-Commerce. Having built several sites from the ground up, he has applied this knowledge to the new MainEventTravel.com. He will solve any problem that involves the mysterious language of HTML.
Sadly, Owain passed away on March 26th 2025. He was a bright light in our company who was taken too early at a young age. As well as developing this site, we also brought to us Main Event Tickets and an EPoS system for our sister businesses. He cannot be replaced, but his legacy lives on throughout our company's DNA.
Mark Valentine
The Client Services Guy
With a growing client roster, Mark is the guy who makes sure everything runs smoothly so all you have to do is check-in, sit down and put on your AirPods (or any other good quality headphones) over your ears. Having spent his first lifetime in nightclubs, bars and restaurants and a second one travelling the international poker circuit, it makes him pretty much the oldest guy on the team.