0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0081 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/130/updates'
ORDER BY `views` DESC
0.0116 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/130/updates'
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '33'
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0286 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1
0.0287 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` = '132'
AND `published` = 1
0.0281 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` = '135'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '130'
ORDER BY `busted` ASC, `current_chips` DESC
0.0064 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` = '130'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5654'
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` = '5652'
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` = '5651'
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` = '5649'
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` = '5647'
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` = '5645'
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` = '5644'
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` = '5641'
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` = '5639'
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` = '5638'
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` = '5633'
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` = '5631'
ORDER BY `chip_change` DESC, `busted` ASC
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` = '5629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 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` = '5628'
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` = '5627'
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` = '5624'
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` = '5621'
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` = '5617'
ORDER BY `chip_change` DESC, `busted` ASC
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` = '5615'
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` = '5614'
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` = '5610'
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` = '5608'
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` = '5598'
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` = '5596'
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` = '130'
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_id` = '130'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5654'
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` = '5652'
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` = '5651'
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` = '5649'
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` = '5647'
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` = '5645'
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` = '5644'
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` = '5641'
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` = '5639'
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` = '5638'
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` = '5633'
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` = '5631'
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` = '5629'
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` = '5628'
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` = '5627'
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` = '5624'
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` = '5621'
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` = '5617'
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` = '5615'
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` = '5614'
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` = '5610'
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` = '5608'
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` = '5598'
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` = '5596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 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.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
WSOPC Tallinn
Event #6: €1,500 WSOPC Tallinn Main Event
Live Reporting - Day 4
Eemil Tuominen Bags Day 1d Chip Lead Posted Thursday 21st September, 2023 at 23:26(UTC+0) by Jason Glatzer
Day 1d added another 111 entries to the mix to bring the total up to 617 entries in the WSOPC Tallinn €1,500 Main Event. This figure will continue to grow as players can still late-register and re-enter during the first two blind levels of Friday's Day 2 which kicks off at noon.
Finland's Eemil Tuominen was the only player in the Day 1d flight to find a bag north of 200,000. Check out all of the chip counts from Day 1d below:
Player
Chips
Big Blinds
Eemil Tuominen
242,000
97
Jarmo Salonen
189,000
76
Henri Antikainen
165,000
66
Ingus Arajs
161,000
64
Vasilij Barna
154,000
62
Max Avela
152,000
61
Antti Veerberk
147,000
59
Khalid Dghaim
146,000
58
Albert Gorelik
145,000
58
Arturs Sutens
137,000
55
Eedi Kirves
134,000
54
Richard Koppel
127,500
51
Karl Relander
115,000
46
Julian Selinger
114,000
46
Joshua Marquardt
114,000
46
Karolis Kutkauskas
112,000
45
Christopher Berggren
109,500
44
Elias Vaaraniemi
104,500
42
Emanuele Mari
100,000
40
Giovanni Memola
99,500
40
Atte Franssila
99,000
40
Aleksandr Arutjunov
99,000
40
Kalle Salmela
98,500
39
Christoffer Bering
98,000
39
Steven Tool
93,500
37
Jari-Pekka Juhola
93,000
37
Konsta Heikkila
92,000
37
Benjamin Dixon
87,000
35
Ranno Sootla
84,000
34
Marek Selgeveer
84,000
34
Martin Koppl
83,000
33
Baavo Pohlak
82,500
33
Martin Piik
82,000
33
Jeffrey Sarwer
80,000
32
Egon Kaljulaid
75,500
30
Vladimiras Meckovskis
74,500
30
Rikard Relander
74,000
30
Jyrki Lampinen
73,500
29
Luca Beretta
73,500
29
Johan Karlsson
71,000
28
Rasmus Lundstrom
69,500
28
Anna-Mari Hursti
66,500
27
Vincas Tamasauskas
65,000
26
Saku Turtia
65,000
26
Martin Lategui
63,000
25
Justas Semaska
57,500
23
Mairo Tori
57,500
23
Teemu Sanaksenaho
57,500
23
Tomi Bondarew
55,000
22
Roope Holma
52,000
21
Janne Havio
50,000
20
Verneri Sivula
49,500
20
Joel Ylismaki
48,500
19
Charles-Eric Benoit
39,500
16
Herli Olop
36,500
15
Danel Kunman
36,000
14
Kaido Kuusemae
34,000
14
Inigo Serrano Robles
31,500
13
Juho Sallinen
30,000
12
Kalle Parkkinen
29,500
12
Tomas Molcan
27,000
11
Markku Koplimaa
26,000
10
Jose Koistinen
17,500
7
Stay Tuned for the Chip Counts! Posted Thursday 21st September, 2023 at 22:36(UTC+0) by Lina Olofsson
As the players bags their chips we wait for the official counts from the tournament staff.
Stay tuned to the blog to see the full one as soon as we lay our hands on it. Until then check out today's pictures in the Gallery or go to Olybet.tv to see the results from all of the side events going on here at the same time as the Main Event.
Last Five Hands! Posted Thursday 21st September, 2023 at 22:32(UTC+0) by Lina Olofsson
The clock stopped here at 09:43 minutes left of level 10 and the tournament director announced we are playing the last five hands for today and then the remaining players will bag their chips before it all resumes again tomorrow at noon.
66 players remain of the 110 entries made in the 1D flight but as we already said you can buy in until the tournament starts again at noon tomorrow.
Chess Genius Jeff Sarwer in the Main Event Posted Thursday 21st September, 2023 at 22:26(UTC+0) by Lina Olofsson
Level 10: 1,000/2,000 (2,000) Entries: 67/110
The chess protege Jeff Sarwer hasn't been seen for quite some time now as he popped up as one of the familiar faces in the Main Event sitting over at table ten together with some other familiar faces as Ranno Sootla, Vasilij Barna, and Johan Karlsson.
Last Chance to Satellite into the Main Event with 15 Seats Guaranteed Posted Thursday 21st September, 2023 at 22:21(UTC+0) by Lina Olofsson
The last satellite to the €1,500 Main Event here in the WSOPC Tallinn is about to start with a huge overlay as only 26 players are in and there's a 15-seat guarantee in this turbo satellite. If you are here in Tallinn, rush down (or up) to the casino for the last chance to grab a seat in this tournament with a guaranteed prize pool of €1 million.
Last Level of Tonight Posted Thursday 21st September, 2023 at 22:17(UTC+0) by Lina Olofsson
We're on the last level of the night with 69 players remaining of the 110 entries made in this flight. The blinds are now up to 1,000/2,000 with a big blind ante of 2,000.
Player
Chips
Progress
Johan Karlsson
77,000
0
Armend Sahiti
0
0
22:14 (UTC+0)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Karlsson: "I didn't even see the flush" Posted Thursday 21st September, 2023 at 21:56(UTC+0) by Lina Olofsson
Level 9: 1,000/1,500 (1,500) Entries: 69/110
Just before going to the break Johan Karlsson found himself in a difficult decision against Armend Sahiti. Before the flop Sahiti hade raised and Karlsson had pushed it up even further leaving 19,1K when the two saw the flop . Sahiti who had flat called pre flop pushed all-in for 22k and Karlsson tanked for quite a while before making the call.
Sahiti: Karlsson:
Sahiti had an open-ended straightdraw and the on the turn gave him the nut straight but the on the river gave Karlsson the nut flush and the pot of 60,000.
"Wait, what happened there? Did I get a flush?", Karlsson commented as the dealer pushed the pot over to him. "Wow, I only saw his straight there", said Karlsson and swiped away the sweat on his forehead as he laughed: "Nice".
The pot left the good old King's of Tallinn winner with a comfortable 118,000 going to the last break of the day until we have one more hour to go.
Player
Chips
Progress
Johan Karlsson
77,000
0
Armend Sahiti
0
0
21:47 (UTC+0)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Last Break for Tonight Posted Thursday 21st September, 2023 at 21:47(UTC+0) by Lina Olofsson
The players are on their last break of tonight here in the fourth and last flight in the WSOPC €1,500 Main Event. 79 out of the 110 entries still have chips in front of them and we picked up some notable stacks and names as they were away which you can below.
Swedens Christopher Berggren seems to be the chip leader with 192,000 in his stack even though he lost that big pot against Massimo Casabona (pictured below) a little bit earlier tonight.
Player
Chips
Progress
Christopher Berggren
192,000
137,000
Jarmo Juhani Salonen
155,000
105,000
Max Avela
143,000
93,000
Jari-Pekka Juhola
138,000
28,000
Gianpaolo Memola
127,000
77,000
Rasmus Lundstrom
116,000
66,000
Vasilij Barna
112,500
62,500
Roope Holma
105,000
55,000
Saku Turtia
92,500
42,500
Vincas Tamasauskas
88,000
38,000
Jeff Sarwer
51,000
1,000
Alexander Selinger
50,000
0
Last Two Levels of the Day Posted Thursday 21st September, 2023 at 21:03(UTC+0) by Lina Olofsson
We are on the last two levels of day 1D and 81 players remain from the field of 108.
One of the players who fired a bullet both in this field and in day 1C was the former WSOP finalist from back in the day is Swede Erik Friberg who we haven't seen playing for a while now. Welcome back, Erik!
Pictures from Day 1D Posted Thursday 21st September, 2023 at 20:58(UTC+0) by Lina Olofsson
Here are some pictures from the fourth starting day here in the WSOPC €1,500 Main Event from our brilliant photographer Tambert Kask. All of the pictures from the Main Event you'll find in the gallery above.
Photographer Elena Kask
Kristopher Kuusk
Martin Koppl
Kaljulaid Keito
Eedi Kirves
Hanno Kerem
Kristopher Kuusk
Massimo Casabona
Vladimiras Meckovskis
Niklas Mikael Vakkuri
Janne Olavi Havio
Verneri Topias Sivula
20:47 (UTC+0)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Karlsson Builds His Stack Posted Thursday 21st September, 2023 at 20:47(UTC+0) by Lina Olofsson
The former Kings of Tallinn winner Johan Karlsson decided to join the action and booked a flight here yesterday. He's also one of the players in day 1D and after playing some small ball poker he's built his stack to 77,000 as we reach the end of the event out of ten levels here tonight.
Player
Chips
Progress
Johan Karlsson
77,000
27,000
Over 100 Players in the Last Flight Posted Thursday 21st September, 2023 at 20:42(UTC+0) by Lina Olofsson
We are now over 100 players with a couple of hours left of the first day here in day 1D. We still haven't reached the guaranteed prize pool of €1 million and there's still time to buy in until the play starts tomorrow at noon.
Casabona Doubles through Berggren Posted Thursday 21st September, 2023 at 20:31(UTC+0) by Lina Olofsson
On the last hand of the last level three players saw the flop . The three musketeers was Sweden's Christopher Berggren, Lithuanian WSOP bracelet winner Vincas Tamasauskas and Italian Massimo Casabona.
Tamasauskas lead out 3,200 which was called by Casabona and Berggren decided to pop it up to 12,000. Tamasauskas went out of the way while Casabona pushed all-in for 33,000. After some consideration, Berggren called and we had a showdown.
Casabona: Berggren:
The turn came and river which doubled the Italian's stack to 70,000.
Player
Chips
Progress
Massimo Casabona
70,000
29,000
Christopher Berggren
55,000
5,000
20:19 (UTC+0)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Midnight Madness! Posted Thursday 21st September, 2023 at 20:04(UTC+0) by Jason Glatzer
WSOP Circuit Tallinn Tournament Director Teresa Nousiainen announced to the Main Event crowd a Midnight Madness mega satellite.
The €150 buy-in event, which guarantees 15 Main Event seats valued at €1,500 each, was just added to the schedule for tonight at midnight.
The 15 (or more) players that win a seat will join others for tomorrow's Day 2 when late registration will close before the start of the third blind level of the day.
Best of luck to all satellite players!
19:49 (UTC+0)
Start of Level 6 Blinds: 400/800 Ante: 800
Two WSOP Bracelet Winners in the Field Posted Thursday 21st September, 2023 at 19:48(UTC+0) by Lina Olofsson
As day 1D is on it's fifth level we've spotted two familiar faces in the tournament floor. Estonian Ranno Sootla and Vincas Tamasauskas are both former WSOP bracelet winners on the hunt for a ring to match with it in the €1,500 Main Event.
Player
Chips
Progress
Vincas Tamasauskas
50,000
0
Ranno Sootla
50,000
0
Another Bullet for Tool Posted Thursday 21st September, 2023 at 19:33(UTC+0) by Lina Olofsson
You can't accuse Steven Tool for not being eager to build his stack in this tournament as he just fired his fourth bullet in the Main Event when entering the day 1D flight here a couple of hours ago. He sit's with an healthy 90,000 in front of him and fingers crossed this bullet will be more successful than the first three for our Estonian player.
Player
Chips
Progress
Steven Tool
90,000
40,000
First Break! Posted Thursday 21st September, 2023 at 19:30(UTC+0) by Lina Olofsson
91 players decided to jump into this last starting day so far. This is the last of the four starting flights in the €1,500 Main Event and will be a turbo in comparison to the first three starting days.
After the first break of the day we have a few notable stacks in the field with Martin Koppl and Jari-Pekka Juhola as spotted with more than double the starting stack of 50,000 with 110,000 each. Below you'll find some other notable stacks.
Player
Chips
Progress
Jari-Pekka Juhola
110,000
60,000
Martin Koppel
110,000
60,000
Massimo Casabona
99,000
49,000
Kristian Kostiander
95,000
45,000
Robert Berg
87,000
37,000
Juhana Konttinen
77,000
27,000
Luka Sorainen
70,000
20,000
Kristopher Kuusk
65,500
15,500
Eedi Kirves
65,000
15,000
Welcome to Day 1D - Final Flight Of The Main Event Posted Thursday 21st September, 2023 at 18:02(UTC+0) by Alaxandar Georgiev
The action continues at full speed with the last flight of the 2023 WSOPC Tallinn €1,500 Main Event which started at 19:00 and already has more than 70 players registered. This is the player's last chance to enter Day 2 of the main event where the prize pool is €1 million guaranteed.
The flight starts with 50,000 chips for each player, but this one has the blinds increase every 30 minutes. The chips will be flying and players will battle it down for the last seats into Day 2.
We begin coverage for this event at 21:15 at level 5 with blinds at 300/600 and a 600 big blind ante, since the last flight overlaps with Main Event Day 1C.
17:45 (UTC+0)
Day 1D of WSOPC Tallinn Started Level: 5 Blinds: 300/600 Ante: 600
Your search results are valid for .
Go to checkoutMore 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.