0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1C/updates'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1C/updates', 1, '2024-11-22')

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

0.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

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.0004 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.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` = 'tour'

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

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.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.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event6'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'

0.0293 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0063 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1

0.0288 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1

0.0288 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1

0.0290 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1

0.0292 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0055 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1

0.0286 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0054 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '135'
AND `published` = 1

0.0284 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
AND `name` = '1C'

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '129'
ORDER BY `busted` ASC, `current_chips` DESC

0.0055 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '129'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5595'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5591'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5593'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5587'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5583'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5581'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5585'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5579'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5578'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5577'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5573'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5572'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5570'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5568'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5567'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5565'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5561'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5560'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5559'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5555'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5552'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5550'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5549'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5547'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5541'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5539'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5538'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5536'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5534'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5528'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5529'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5527'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5526'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5524'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5523'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5518'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5517'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5515'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5510'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5509'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5506'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5502'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5501'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5499'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5498'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5494'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5493'
ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '129'
ORDER BY `busted` ASC, `current_chips` DESC

0.0057 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '129'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0067 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5595'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5592'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5591'
ORDER BY `chip_change` DESC, `busted` ASC

0.0074 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5593'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5587'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5583'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5581'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5585'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5579'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5578'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5577'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5573'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5572'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5571'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5570'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5568'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5567'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5565'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5561'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5560'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5559'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5555'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5552'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5550'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5549'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5547'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5541'
ORDER BY `chip_change` DESC, `busted` ASC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5544'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5539'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5538'
ORDER BY `chip_change` DESC, `busted` ASC

0.0082 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5536'
ORDER BY `chip_change` DESC, `busted` ASC

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5534'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5528'
ORDER BY `chip_change` DESC, `busted` ASC

0.0078 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5529'
ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5527'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5526'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5524'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5523'
ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5518'
ORDER BY `chip_change` DESC, `busted` ASC

0.0092 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5517'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5515'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5510'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5509'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5506'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5502'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5501'
ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5499'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5498'
ORDER BY `chip_change` DESC, `busted` ASC

0.0105 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5494'
ORDER BY `chip_change` DESC, `busted` ASC

0.0117 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5493'
ORDER BY `chip_change` DESC, `busted` ASC

0.0112 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
ORDER BY `busted` ASC, `current_chips` DESC

0.0008 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

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

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(1)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4

WSOPC Tallinn - Live Reporting

Event #6: €1,500 WSOPC Tallinn Main Event See other events

Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

---

Current Level 35 Current Day 4

---

Blinds 300,000/600,000 Ante 600000

Entries 719 Remaining 1

---

Prize Pool (EUR) €1,000,000 First Prize (EUR) €211,500

Chip Leaders Day 4

1

Ignacio Garrido Gonzalez

35,900,000

Day 1A Day 1B Day 1C Day 1D Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 1C

Joel Holmberg Bags Overall Chip Lead on Day 1c Posted Thursday 21st September, 2023 at 18:40(UTC+0) by Jason Glatzer

Joel Holmberg parlayed his opening stack of 50,000 into 318,000 to lead the 115 Day 1c survivors out of the 260 entries in the field. This also placed him on top of the overall chip counts with Jonatan Fors coming out of Day 1c in second place overall with 297,000 with Tarmo Tammel nearly bagging up around the same. 

Check out all of the Day 1c chip counts below:

Player	Chips	Big Blinds
Joel Holmberg	318,000	127
Jonatan Fors	297,000	119
Tarmo Tammel	290,000	116
Mantas Bagocius	284,500	114
Santeri Piiroinen	281,000	112
Pyry Kekalainen	267,500	107
Jun Beum Chun	246,000	98
Oskar Ojaveer	227,500	91
Andrius Bielskis	205,000	82
Hannes Praks	199,500	80
Lars Jonsson	191,000	76
Priit Vallap	190,500	76
Juuso Elsinen	181,000	72
Mark Metsla	181,000	72
Kimmo Kurko	177,500	71
Mauro-Mark Musting	175,000	70
Agnius Ismailovas	175,000	70
Hai Hoang	165,000	66
Maruen Zormati	162,000	65
Mathias Siljander	159,500	64
Albert Ostrovskij	159,000	64
Deividas Butnoras	155,500	62
Antti Karkkainen	155,000	62
Vu Hoang Vuong	153,000	61
Mikko Ylamaki	152,500	61
Aigars Taukacs	149,500	60
Niko Linnama	148,000	59
Martin Naveiro	147,500	59
Jaime Susarte	145,000	58
Tanaka Yusuke	145,000	58
Andrius Simonovicius	142,000	57
Martin Valent	140,000	56
Mantas Ramanaukas	140,000	56
Eirimas Tomkevicius	137,000	55
Robin Palm	132,500	53
Aleksandrs Kasincevs	126,000	50
Anders Hansson	126,000	50
David Asqino	125,500	50
Arturs Daugis	123,500	49
Juha Helppi	123,000	49
Dmitri Dudakov	122,500	49
Justus Kursi	121,500	49
Amanullah Tahiri	120,000	48
Markuss Rukkalns	120,000	48
Tomi Hietala	120,000	48
Eeti Loyttyniemi	118,000	47
Priit Parmasto	116,000	46
Maciej Komorowski	115,500	46
Jordi Baixas	115,000	46
Stephen Groom	115,000	46
Tero Hakanen	114,000	46
Emil Hovmark	113,500	45
Niko Petro	111,000	44
Priit Oja	111,000	44
Rasmus Eino	108,500	43
Calle Hansson	107,000	43
Adrians Imsa	105,000	42
Kai Lehto	102,500	41
Einar Hersdal	102,000	41
Xiaolei Chen	101,500	41
Vilius Zabarauskas	101,500	41
Claudio Cecchi	100,000	40
Domene Jose Larios	99,500	40
Antti Eeva	98,000	39
Magnus Pukk	93,500	37
Pavel Solodovnikov	92,500	37
Davis Modans	92,000	37
Quang Doan	92,000	37
Kasper Mellanen	90,000	36
Mustafa Biz	89,000	36
Juha Nikkola	88,500	35
Edgars Gendvilis	88,000	35
Santtu Leinonen	87,000	35
Lukasz Balbierz	83,500	33
Matias Arosuo	82,000	33
Bartlomiej Kijak	79,000	32
Ignacio Garrido	75,000	30
Kevin Karenius	74,500	30
Glen Gaines	70,000	28
James Noonan	69,500	28
Matias Knaapinen	68,500	27
Niko Palonen	67,500	27
Joona Ranta-Nilkku	66,500	27
Ville-Matti Keranen	66,000	26
Aleksei Gontsar	65,000	26
Silver Simulask	65,000	26
Anne Bezdek	62,000	25
Giuseppe Rosa	61,000	24
Carl Halvarsson	60,000	24
Jani Haarala	58,000	23
Aurelijus Sipavicius	58,000	23
Ilari Sahamies	56,500	23
Kaspars Renga	56,000	22
Jari Mahonen	56,000	22
Viacheslav Sultanov	56,000	22
Paulius Mikaliunas	55,000	22
Michele Tocci	52,500	21
Kaido Mikk	51,000	20
Ramunas Mika	51,000	20
Jorge Bravo	51,000	20
Viktors Semjonovs	50,500	20
Roberts Rumba	50,000	20
Valters Cernevskis	50,000	20
Juha Kaitanen	48,500	19
Jon Kyte	47,000	19
Akseli Paalanen	46,000	18
Matus Fecisko	46,000	18
Niki Nurmisto	44,000	18
Min Ho Cho	42,500	17
Ryan Mandara	42,000	17
Seppo Parkkinen	38,000	15
Tomi Arponen	38,000	15
Edgars Beizaks	34,500	14
Sami Suominen	27,000	11
Davor Pavic	19,500	8

Final Four Hands Posted Thursday 21st September, 2023 at 17:36(UTC+0) by Jason Glatzer

The tournament director announced the final four hands of Day 1c. While we focus on the chip counts of the nearly 120 survivors, we will also start reporting Day 1d after the first break.

The Big Boy Bluff Posted Thursday 21st September, 2023 at 17:35(UTC+0) by Alaxandar Georgiev

Level 10: 1,000/2,000 (2,000)
Entries: 127/260

Big action on the turn as the board was dealt ,  Anders Hansson was the original raiser and he made another 10,000 bet on the turn. His opponent was Pyry Kekalainen and he re-raised him to 35,000 which Hansson called.

On the river Hansson checked, shortly after Kekalainen put another 40,000 into the pot, and the Swede folded.

Pyry Kekalainen showed to everyone after Hansson revealed he had the .  

The big bluff earned Finland's Kekalainen a pot worth over 130,000 chips.

Player		Chips	Progress
Pyry Kekalainen		220,000	10,000
Anders Hansson		180,000	53,000

Larsson Doesn't Love Queens Posted Thursday 21st September, 2023 at 17:14(UTC+0) by Lina Olofsson

Greger Larsson hit the rail in the end of last level after loosing his good stack in a few pretty harsh hands against Justus Kursi. 

First he doubled Kursi with versus on a very dry board and lost 37,000 to the Finn. A few hands later they were five to see the flop . Larsson who had flopped the nut flush with on his hand checked and the guy after him made a tiny tiny raise to 1,5 big blinds as Justus Kursi raised. Action was folded to Larsson who pushed his chips in and was called by Kursi who turned over for a flopped set. So far so good but that didn't last long as another queen came on the turn and his opponent got a full house leaving Larsson down to only 4,500 left in his stack. 

Larsson managed to spin his last chips up to 27,000 until he ran into eights with his sevens and the journey was over for our Swede . 

"At least Calle managed to double up", Larsson commented as he walked around in the tournament area deciding if he wanted to fire another bullet in the tournament as day 1D was just about to start (and you can buy in all the way until tomorrow morning). When saying Calle he refers to Calle Hansson who managed to get a good beat as his survived against his opponents doubling up to around 125,000.  

Player		Chips	Progress
Calle Hansson		94,000	0
Justus Kursi		50,000	0
Greger Larsson		0	0

Final Day 1c Blind Level Begins; Day 1d Kicks Off Posted Thursday 21st September, 2023 at 17:04(UTC+0) by Jason Glatzer

Level 10: 1,000/2,000 (2,000)
Entries: 146/256

Day 1c has progressed to its final blind level of the day before surviving players bag their chips for tomorrow's Day 2.

Meanwhile, the final opening flight in Day 1d just began with a field of 20 entries. This flight is a little different than the others as it boasts 30-minute blind levels instead of the 40-minute levels prevalent during the rest of the event. 

Our Day 1d coverage will begin after the first break while we focus on the tail end of Day 1c.

 

17:02 (UTC+0)

Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000

Its Always Coming Seven Posted Thursday 21st September, 2023 at 17:01(UTC+0) by Alaxandar Georgiev

Level 9: 600/1,200 (1,200)
Entries: 146/258

Eirimas Tomkevicius raised from the button, followed by a big blind jam for 37,500 chips by Renars Sakauskis, not long after Tomkevicius called.

Eirimas Tomkevicius:
Renars Sakauskis:

Quite behind with the lower pair Tomkevicius was hoping for one of the sevens on the flop as he shouted "seeeveen" and that is exactly what he got on the flop.

Sakauskis didn't look happy with this flop and needed a King to stay in the tournament. The turn was and the river was . 

Unlucky for Renars Sakauskis as he busts 1 level before Day 1C Finishes.

Player		Chips	Progress
Eirimas Tomkevicius		115,000	65,000
Renars Sakauskis		0	0

Ramanauskas is "Sorry" for Ousting Bering Posted Thursday 21st September, 2023 at 16:51(UTC+0) by Jason Glatzer

Level 9: 1,000/1,500 (1,500)
Entries: 153/256

Christoffer Bering three-bet from the button before Mantas Ramanauskas four-bet shoved from the small blind for 65,000. The initial raiser, folded while Bering called off his stack of a little less.

"Oh no," said Ramanauskas. "What did I do?"

Christoffer Bering:
Mantas Ramanauskas:

Unlike most players who would root for a jack, Ramanauskas began to apologize to his opponent after his jack connected on the flop. Neither the turn nor the river saved the day. Bering began to leave but not before Ramanauskas got out of his chair to say sorry once again and give his opponent a hug.

"You've been doing that to me all day," Bering said in a friendly tone.

"Sorry, again," Ramanauskas.

Player		Chips	Progress
Mantas Ramanauskas		125,000	75,000
Christoffer Bering		0	0

Swedish Poker Federation Chairman Svedin On the Line Posted Thursday 21st September, 2023 at 16:44(UTC+0) by Lina Olofsson

The Swedish Poker Federations chairman Robert Svedin is one of the players in today's field and had a good start to the day as he was up to 120,000 in chips after a few levels but the past two of them weren't as successful and he's holding on to a thread as he's now playing with only 9,000 in front of him on the blinds 1,000/1,500 with a big blind ante of another 1,500. 

But it's like they say. A chip and a chair and Svedin is known for his skills to spin up and we wish him good luck as the play resumes for the last two levels of today here in flight 1C. 

Svedin's good friend and a Swede who's doing much better is Anders Hansson who sits with 233,000 in front of him right next to his fellow countryman Davor Pavic who just moved to his table. 

Player		Chips	Progress
Anders Hansson		233,000	50,000
Davor Pavic		43,000	7,000
Robert Svedin		9,000	111,000

Not A Bad Flop Posted Thursday 21st September, 2023 at 16:44(UTC+0) by Alaxandar Georgiev

Level 9: 600/1,200 (1,200)
Entries: 158/254

Andres Leppik raised from the cut-off to 3,000, followed by a call and a three-bet to 15,000 by Maruen Zormati on the big blind. With no hesitation, Leppik put forward all of his chips and just as quickly Zormati called for 70,500 chips.

Andres Leppik:
Maruen Zormati:

To the flop which was not bad at all for Leppik as he picked up a lot of outs to win the hand. He needed a spade, ace or a deuce to win over his opponent, but the turn and the river didn't get him there.

 The Finn scoops the whole pot and Leppik was left with just 3,000 chips.

Player		Chips	Progress
Maruen Zormati		141,000	91,000
Andres Leppik		3,000	47,000

Big Stacks at Break Posted Thursday 21st September, 2023 at 16:27(UTC+0) by Alaxandar Georgiev

Player		Chips	Progress
Joel Holmberg		280,000	165,000
Jun Beum Chun		225,000	106,000
Oskar Ojaveer		220,000	170,000
Pyry Kekalainen		210,000	160,000
Tarmo Tammel		190,000	100,000
Kristoffer Hovmark		180,000	130,000
Skommar Hansson Sr.		180,000	5,000
Ville Keranen		140,000	105,000

16:22 (UTC+0)

Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500

Final Day 1c Break Posted Thursday 21st September, 2023 at 16:03(UTC+0) by Jason Glatzer

Players are on their final break of Day 1c. Blinds will increase to 1,000/1,500 with a 1,500 big blind ante before moving to the final blind level of the day with blinds at 1,000/2,000 with a 2,000 big blind ante when the action resumes. After these two levels, players will bag and tag chips into Saturday's Day 2.

Tuominen Dusts Off Vaitiekunas & Doubles Thru Butnoras Posted Thursday 21st September, 2023 at 15:50(UTC+0) by Jason Glatzer

Level 9: 600/1,200 (1,200)
Entries: 174/249

Paulius Vaitiekunas jammed his crumbs from under the gun and was called by Deividas Butnoras (pictured below) before Eemil Tuominen three-bet jammed for more than 30,000. Butnoras called this as well and the cards were turned over.

Paulius Vaitiekunas:
Eemil Tuominen:
Deividas Butnoras:

Touminen eliminated Vaitiekunas while doubling through another Lithuanian in Deividas Butnoras after the ran out on the board.

Player		Chips	Progress
Deividas Butnoras		140,000	90,000
Eemil Tuominen		65,000	15,000
Paulius Vaitekunas		0	0

Tammel Binks It On The River Posted Thursday 21st September, 2023 at 15:48(UTC+0) by Alaxandar Georgiev

Level 8: 600/1,200 (1,200)
Entries: 179/249

Tarmo Tammel raised the button and Paulius Vaitiekunas defended from the big blind. 

The  flop went check-check. Vaitekunas led the turn for 10,000 chips which was an overbet and Tammel jammed it all in for 45,000. After a short thought, his opponent called.

Tarmo Tammel:
Paulius Vaitekunas:

Vaitekunas was ahead with his two-pair, while Tarmo needed a ten, ace, or a king on the river.

And indeed he binked the on the river wining 90,000 chips. Vaitekunas was left with only 2,600 chips which he doubled the next hand.

Player		Chips	Progress
Tammel Tarmo		90,000	40,000
Paulius Vaitekunas		2,600	47,400

Day 1c Larger Than Day 1a & Day 1b Combined! Posted Thursday 21st September, 2023 at 15:33(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 179/249

Day 1a and Day 1b attracted 246 entries behind. There are already 249 entries in Day 1c making not only the largest opening flight but also larger than Day 1a and Day 1b combined.

15:22 (UTC+0)

Start of Level 8
Blinds: 600/1,200     Ante: 1,200

Too Many Outs For Herrero Posted Thursday 21st September, 2023 at 15:22(UTC+0) by Alaxandar Georgiev

Level 7: 500/1,000 (1,000)
Entries: 183/245

Sandro Herrero jammed about half a starting stack over a raise by Jari-Pekka Juhola and was snap-called by Juhola.

Sandro Herrero:
Jari-Pekka Juhola:

A great flop gave Herrero better odds of winning the pot as he was drawing to a flush, an ace, or perhaps one of the two Kings left.

The turn wasn't what the Spanish player wanted, neither the on the river.

Player		Chips	Progress
Jari-Pekka Juhola		75,000	25,000
Sandro Herrero		0	0

Jon Kyte Trying on Rings Posted Thursday 21st September, 2023 at 15:20(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 185/244

Norwegian poker sensation Jon Kyte (pictured below) was busy deciding which finger he wanted the majestic WSOP Circuit gold ring to be fitted for after winning Event #8: €1,100 PLO 4, 5, & 6 Cards for €34,780. After he decides which finger, he will also have to deliberate on design decisions.

Kyte isn't off to a hot start on Day 1c as he has already lost more than half his starting stack but after winning a ring last night, Kyte appears to be very low-stress and ready for another day under the lights and cameras competing for a coveted WSOP gold ring.

Meanwhile, a hand took place at his table as we were having a chat. Antti Karkkainen got his last 16,600 into the pot with the on the board after the flop and was up against Timo Ruuska.

Antti Karkkainen:
Timo Ruuska:

Ruuska's top pair wasn't good enough and it didn't get any better the rest of the way to double Karkainen. Karkkainen's good fortunes were short-lived as shortly after he was witnessed leaving the tournament arena.

Player		Chips	Progress
Timo Ruuska		85,000	35,000
Jon Kyte		20,000	30,000
Antti Karkkainen		0	0

Big Slick for Rosa to Felt Arras Posted Thursday 21st September, 2023 at 14:54(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 191/240

Lithuanian poker beast Paulius Vaitiekunas opened for 2,200. 2022 Battle of Malta Spring Edition Main Event champion Giuseppe Rosa three-bet to 7,000 before Rauno Arras four-bet shoved for approximately 15,000. Vaitiekunas folded while Rosa snap-called.

Rauno Arras:
Giuseppe Rosa:

Arras got out of his seat but kept his eyes on the table. Shortly after he left the room after bricking the runout.

We Have A New Sheriff In Town Posted Thursday 21st September, 2023 at 14:50(UTC+0) by Lina Olofsson

As the 190 players still in the field (of 238 already bought in) have left for their second break here on day 1C of the €1,500 Main Event we have spotted some notable stacks around the tables. 

Jun Beum Chun is in the lead with 191,000 in his stack just before Anders Hansson with 183,000. Below you'll find some more chips across the grand ballroom here at the Hilton Park and Olympic Casino. 

Player		Chips	Progress
Jun Beum Chun		191,000	141,000
Jun Beum Chun		190,000	140,000
Anders Hansson		183,000	133,000
Priit Vallap		140,000	90,000
Steven Tool		140,000	75,000
Tomi Matias Rasanen		132,000	82,000
Robert Svedin		120,000	70,000
Hai Hoang		115,000	65,000
Joel Holmberg		115,000	65,000
Matus Fecisko		96,000	9,000
Calle Hansson		94,000	44,000
Antonios Onoufriou		93,000	43,000
Matti Lasanen		88,000	66,000
Aleksandrs Kasincevs		85,000	35,000
Juha Helppi		75,000	25,000

14:40 (UTC+0)

Start of Level 7
Blinds: 500/1,000     Ante: 1,000

Second Break Posted Thursday 21st September, 2023 at 14:24(UTC+0) by Jason Glatzer

Players are on their second 20-minute break. Blinds will increase to 500/1,000 with a 1,000 big blind ante when the action resumes.

Swedish Father and Son Battling in the Main Event Posted Thursday 21st September, 2023 at 14:10(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 196/229

Cho Min Ho opened the pot from an early position to 1,800 and was called by two players, one of them being Skommar Hansson Jr., but he got re-raised from Henri Wagner on the big blind to 5,600.  Min Ho folded, Hansson called the three-bet, and one more player called.

The flop was dangerous and everyone checked it down. The turn was which paired the board and Wagner bet 7,200 into the pot followed by an all-in from Hansson who was wearing a black hoodie over his head and looked just as dangerous.

Not long after Wagner folded which led to the Swede scooping up a nice pot.

Meanwhile, Skommar Hansson Sr., the father of Skommar Hansson Jr., is also in the field beasting it up on a nearby table with 175,000 in chips.

Player		Chips	Progress
Skommar Hansson Sr.		175,000	125,000
Skommar Hansson Jr.		65,000	15,000
Henri Wagner		20,000	30,000

Flush for Pukk Posted Thursday 21st September, 2023 at 14:08(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 196/229

Edgars Beizaks checked with about 20,000 in the pot and the on the board.

Magnus Pukk (pictured below) tanked for a couple of minutes before he bet 9,000. Beizaks tossed in two black chips designating a call only to much his hand after Pukk exposed the for a flush.

Meanwhile, Lithuanian poker hero Andrius Bielskis was at the same table and has been continuing to climb up the chip count leaderboard with a stack of 160,000.

Player		Chips	Progress
Andrius Bielskis		160,000	20,000
Magnus Pukk		80,000	30,000
Edgars Beizaks		30,000	20,000
Anna-Mari Hursti		0	0
Ricardo Usai		0	0

13:43 (UTC+0)

Start of Level 6
Blinds: 400/800     Ante: 800

Parmasto Attempting to Multitable Posted Thursday 21st September, 2023 at 13:42(UTC+0) by Jason Glatzer

The 2023 WSOP Circuit Tallinn €1,500 Main Event is a huge tournament to be playing. For most it is about the money, the ring, and the prestige. For others, it is just about the ring and prestige. This is the case for Estonia's Priit Parmasto, who already has a big stack on Day 1c but is also multitabling high-stakes cash games on his telephone simultaneously.

Parmasto is an absolute cash game wizard according to any well-versed Estonian we asked and we tend to agree with this opinion. However, in recent times Parmasto showed he can beast it up in tournaments as well as back in March of this year, Parmasto shipped the €500,000 guaranteed Kings of Tallinn €1,100 Main Event here at Olympic Park Casino for €97,400.

We wish Parmasto the best of luck in his pursuit of the ring, and, of course, we also wish him to crush the cash games he is playing at the same time.

Player		Chips	Progress
Priit Parmasto		140,000	90,000

Avots Runs Into Sultanov's Big Slick Posted Thursday 21st September, 2023 at 13:36(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 199/224

Kaspars Avots three-bet jammed for close to 15,000 and was called by 2023 WSOPC Tallinn Event #1: €555 NLH champion Viacheslav Sultanov (pictured below), who originally opened from under the gun.

Kaspars Avots:
Viacheslav Sultanov:

Both players connected with their ace on the flop.

"Chop," a player not in the hand requested.

The turn reduced one of Avots' outs who now was down to a two outer.

"Eight," pleaded Avots.

No eight came, not even the which wouldn't have been good for him as this would have completed a flush for Sultanov. Instead, it was the river completing the board and Avots will need to re-enter if he wishes to advance to Day 2 and beyond.

Player		Chips	Progress
Viacheslav Sultanov		65,000	15,000
Kaspars Avots		0	0

Deuces Never Loses Posted Thursday 21st September, 2023 at 13:27(UTC+0) by Alaxandar Georgiev

Level 5: 300/600 (500)
Entries: 200/223

We had Aki Pyysing (pictured below) again in action against Ville Keranen, after some two-sided aggression both went all-in preflop for about 45,000 each.

Aki Pyysing:
Ville Keranen:

Aki managed to hold his hand on the all-low cards board and doubled up to a healthy 90,000 stack.

Player		Chips	Progress
Aki Pyysing		90,000	40,000
Ville Keranen		35,000	15,000

13:05 (UTC+0)

Start of Level 5
Blinds: 300/600     Ante: 600

Big Play From Modans Posted Thursday 21st September, 2023 at 13:05(UTC+0) by Alaxandar Georgiev

Level 4: 200/500 (500)
Entries: 192/214

Davis Modans was already in a three-bet pot against Karl Relander, in which he re-raised pre-flop.

The flop was bet from modas for 7,000 with already 14,000 in the pot. The turn was checked by both players.

The river was and Modans bet 9,000 which was quickly raised to 18,000 by Relander. Not long after Davis Modans pushed all of his chips in covering Relander's remaining stack.

Relander folded and Modans revealed his to everyone. The big play earned him more than 32,000 chips.

Player		Chips	Progress
Davis Modans		100,000	50,000
Karl Relander		22,000	28,000

Larsson Needs a Break - Wins Too Many Hands Posted Thursday 21st September, 2023 at 13:01(UTC+0) by Lina Olofsson

The Swede Greger Larsson was just seen walking around with his WSOPC bottle of water in the tournament room. After our last post, we assumed he might have lost a hand but it was the total opposite. We asked if something had happened since he looked a bit shaken up but he replied with a big smile on his face: "I'm running too good right now, I needed to walk around a little and shake it off a bit". "But if you're running hot you should sit at your table", we replied and he agreed and said it was between two hands.

He had just added another 35,000  to his stack and almost tripled his starting stack of today in only four levels and is one of the chip leaders in the big field we have here today which is up to 214 players in total. 

Player		Chips	Progress
Greger Larsson		140,000	35,000

"I Was So Happy!" Posted Thursday 21st September, 2023 at 12:37(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 189/199

Matti Lasanen bet 6,500 into a pot of around 10,000 with the on the board after the turn. Greger Larsson called and the action river completed the board.

Lasanen bet 16,500. Larsson went into the tank before he called.

Lasanen turned over the for a flush.

"Ooooh," Larsson said as if it was a pleasant surprise before turning over the for a stronger flush. "Lucky!"

"I was so happy to see that river," Lasanen said. "I was going to give up if I didn't get a heart."

Player		Chips	Progress
Greger Larsson		105,000	35,000
Matti Lasanen		22,000	28,000

Various Stacks at Break Posted Thursday 21st September, 2023 at 12:33(UTC+0) by Jason Glatzer

Player		Chips	Progress
Andrius Bielskis		140,000	100
Silver Simulask		108,000	0
Matus Fecisko		105,000	0
Yusuke Kakiuchi		90,000	40,000
Jevgenijs Udalovs		80,000	0
Greger Larsson		70,000	2,000
Steven Tool		65,000	0

12:27 (UTC+0)

Start of Level 4
Blinds: 200/500     Ante: 500

First Break Posted Thursday 21st September, 2023 at 12:00(UTC+0) by Jason Glatzer

Players are on their first break of Day 1c. The action will resume in 20 minutes with blinds at 200/500 along with a 500 big blind ante.

Friberg's Fives Get Fried Posted Thursday 21st September, 2023 at 11:59(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 162/171

Christopher Berggren called a jam by fellow Swede Erik Friberg with the on the board after the turn.

Erik Friberg:
Christopher Berggren:

Berggren was far ahead with his turned trips with Friberg down to just two outs. The river wasn't one of them and Friberg was on the rail.

Player		Chips	Progress
Christopher Berggren		135,000	85,000
Ramunas Mika		60,000	10,000
Erik Friberg		0	0

Salonen Connects With His King Posted Thursday 21st September, 2023 at 11:47(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 154/161

Riccardo Usai and Martti Keel both checked the board after the turn when Jarmo Salonen fired out for 6,000. Usai called and Keel shrugged his shoulders before he folded.

The floor then came by to ask Keel to move tables so he wasn't able to see the rest of the hand which first involved Usai and Salonen checking the river. Keel turned over the and let out a whisper of a celebration after his pair of kings was good against a pair of sevens after Usai failed to get there on the river with .

Player		Chips	Progress
Jarmo Salonen		70,000	70,000
Martin Keel		65,000	15,000
Ricardo Usai		35,000	15,000

11:21 (UTC+0)

Start of Level 3
Blinds: 200/400     Ante: 400

Hursti Left Short After Eeva Bets Out of Turn Posted Thursday 21st September, 2023 at 11:20(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 144/147

The floor was called over with the on the board and 50,000 in the pot due to Antti Eeva betting 12,000 out of turn.

The floor explained to Anna-Mari Hursti and the rest of the table that all of her options were open. She can check, and then the bet by Eeva would have stood. If she bets instead, Eeva's bet gets taken back and the hand moves on from there.

A few minutes passed by before Hursti opted to fold.

Player		Chips	Progress
Anna-Mari Hursti		20,000	30,000
Antti Eeva		0	45,000

Rasanen Display Aggression Posted Thursday 21st September, 2023 at 11:03(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 135/137

The Day 1c field stands at 137 entries and counting with 135 players in their seats after Yusuke Kakiuchi joined Adrians Imsa on the rail.

Meanwhile, things are proceeding slightly better for the formidable Tomi Rasanen. There was 7,000 in the pot with the on the flop when Claudio Cecchi fired out for 2,800. Marius Vaitkevicius folded before Rasanen jacked it up to 7,500. 

Cecchi took his time but eventually called to see the turn. Rasanen bet 12,000 after afte Cecchi checked and his opponent went into the tank for a couple of minutes before he folded.

Player		Chips	Progress
Tomi Rasanen		65,000	15,000
Aurelijius Sipavicius		60,000	10,000
Claudio Cecchi		55,000	5,000
Yusuke Kakiuchi		0	0

10:41 (UTC+0)

Start of Level 2
Blinds: 100/300     Ante: 300

Helppi, Pyysing, Sootla, and More in the Field Posted Thursday 21st September, 2023 at 10:39(UTC+0) by Jason Glatzer

WSOP bracelet winners Ranno Sootla and Juha Helppi went back to their roots last night and both entered different WSOPC Tallinn Main Event mega satellites.

Both players would have hopped into the Main Event regardless of whether they won a seat in their perspective satellites or not after a quick chat with both players late in the evening.

Finnish poker legend and journalist Aki Pyysing also is hunting for the most prestigious gold ring of them. Hassan Sey, Aurelijus Sipavicius, Justas Semaska, and the popular Swedish player Gregor Larsson are also already in the mix.

Player		Chips	Progress
Ranno Sootla		50,000	0
Justas Semeika		50,000	0
Juha Helppi		50,000	0
Gregor Larsson		50,000	0
Aurelijius Sipavicius		50,000	0
Aki Pyysing		50,000	0
Hassan Sey		50,000	0

Century Mark Achieved Posted Thursday 21st September, 2023 at 10:34(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 113/114

The Day 1c field has already grown to 114 entries. Adrians Imsa was the first players out on the rail on Day 1c but still has plenty of time to re-enter if he so chooses.

Player		Chips	Progress
Adrians Imsa		0	0

Cards in the Air Posted Thursday 21st September, 2023 at 10:26(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 61/61

Cards are in the air for Day 1c with 61 entries. There are many more gathering their seat slips at the cashier line, so expect this figure to grow quickly.

Welcome to Day 1c of the Main Event Posted Thursday 21st September, 2023 at 09:15(UTC+0) by Jason Glatzer

Get ready for some action on Thursday at the 2023 World Series of Poker Circuit (WSOPC) Tallinn with the final two of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event starting its action on Tuesday at noon. Not only will a play win a coveted WSOPC gold ring but also a lion's share of what promises to be a massive prize pool with a €1 million guarantee slapped on this event.

The four-day Main Event is a deep-stacked affair boasting four opening flights from Sept. 19-21 with players starting with 50,000 in opening chips. Blinds increase slowly at every 40 minutes during the first three opening flights with the final opening flight moving along a little quicker with 30-minute blind levels.

Players will have plenty of opportunities to accumulate chips with unlimited re-entries permitted throughout the four opening flights and during the first two blind levels of Day 2. The battle will continue on Sept. 22-24 with one hour blind levels until the first-ever WSOPC Tallinn Main Event winner is crowned.

We will see many big names, including Finnish poker legend and two-time WSOP bracelet winner Juha Helppi (pictured below), who built up a big stack on Day 1a only for bad beats and coolers to take it away, hunting for the Main Event gold ring awarded to the winner along with a healthy top prize and an invitation to a $1 million guaranteed 2023 WSOP Tournament of Champions freeroll where a WSOP bracelet is on the line.

The first two flights thus far attracted 246 entries with Estonian poker beast Urmo Velvelt advancing with the largest stack of 293,000 on Day 1b with Day 1a chip leader Joni Rantamaki from Finland is just behind with 276,000.

Our coverage starts at noon with blinds at 100/200 and a 200 big blind ante. Follow the Main Event journey throughout the week while we report the biggest hands, bad beats, and stories until a winner is crowned.

09:00 (UTC+0)

Day 1C of WSOPC Tallinn Started
Level: 1     Blinds: 100/200     Ante: 200

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter