0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0073 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/27/117/updates'
ORDER BY `views` DESC
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` = '27'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '27'
0.0278 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` = '96'
AND `published` = 1
0.0320 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0095 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '117'
AND `published` = 1
0.0323 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` = '121'
AND `published` = 1
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '117'
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` = '117'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4972'
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` = '4971'
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` = '4970'
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` = '4969'
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` = '4968'
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` = '4967'
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` = '4966'
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` = '4965'
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` = '4964'
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` = '4963'
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` = '4962'
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` = '4961'
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` = '4960'
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` = '4959'
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` = '4958'
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` = '4956'
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` = '4955'
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` = '4953'
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` = '4952'
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` = '4950'
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` = '4949'
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` = '4948'
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` = '4947'
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` = '4946'
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` = '4945'
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` = '4944'
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` = '4943'
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` = '4942'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '117'
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` = '117'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4972'
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` = '4971'
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` = '4970'
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` = '4969'
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` = '4968'
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` = '4967'
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` = '4966'
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` = '4965'
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` = '4964'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 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` = '4963'
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` = '4962'
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` = '4961'
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` = '4960'
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` = '4959'
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` = '4958'
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` = '4956'
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` = '4955'
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` = '4953'
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` = '4952'
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` = '4950'
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` = '4949'
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` = '4948'
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` = '4947'
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` = '4946'
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` = '4945'
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` = '4944'
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` = '4943'
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` = '4942'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '121'
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 #3: €350 WSOPC Tallinn Ring Event (Estonian)
Live Reporting - Day 2
TOP3 + Eestlaste stäkid päeva 1B järel Posted Sunday 17th September, 2023 at 22:12(UTC+0) by maheaaatom
Päeva 1B elas üle neli Eesti mängijat, kelle kohtume juba homme.
350 NLH Ring Event #3 otsustav päev saab avapaugu esmaspäeval kell 12:00 ning selle turniiri ülekanne jätkub ka eestikeelses live-blogis. Head ööd ja head uut nädala algust!
Player
Chips
Progress
James Stewart
346,000
326,000
Michele Tocci
316,000
296,000
Algirdas Saveikis
291,000
271,000
Vladislav Topilskiy
202,000
139,000
Evely Pihela
196,000
44,000
Marius Morel
140,000
0
Keito Kaljulaid
57,000
11,000
Mull on lõhkenud Posted Sunday 17th September, 2023 at 21:31(UTC+0) by maheaaatom
Kahel laual kukkus korraga välja üks mängija, seega on kõik allesjäänud kenasti rahades. Üldise TOP3 chipcounti + kõikide eestlaste stäkid leiate juba vähem kui poole tunni pärast.
Alanud on ka Omaha Posted Sunday 17th September, 2023 at 21:18(UTC+0) by maheaaatom
Ööinimestest Omaha-sõpru on hetkel 19 ning see on täiesti piisav, et kaardid laudades laiali jagada.
Osalejate seas ka kaks eestlast.
Hand-by-hand Posted Sunday 17th September, 2023 at 21:14(UTC+0) by maheaaatom
Virgo Laansool ei õnnestunud oma väikese stäkiga imet teha, pisut enne teda oli mängust langenud ka soomlane Naski.
Seega oleme jõudnud 25 parimani ning alanud on mullimäng. Esimene, kes langeb jääb kõigest ilma. Kõik ülejäänud on endale WSOP Circuit cashi (mis on kindlasti ka Hendon andmebaasi vääriline) taganud.
Tänane intervjuu: Eestis elav super-highroller Anatoly Filatov Posted Sunday 17th September, 2023 at 20:50(UTC+0) by maheaaatom
Triple draw-l 45 sisseostu Posted Sunday 17th September, 2023 at 20:44(UTC+0) by maheaaatom
Kõrvalsaalis toimuva 2-7 Triple Draw lõplik sisseostude arv on 45. Seegi turniir mängitakse täna kuni rahadeni. Eesti esindajad Nikiforov, Vaabel ja Arutjunov on kenasti sees, alles 19 mängijat.
Satelliidil on isegi võimalik, et täna overlayd ei teki. Hetkel 78 sisseostu (100 on "piirid") aga pausini on veel 20 minutit aega.
350 € turniiri päev 1B jätkub kolmel laual ning alles 27 parimat. Kolme väljalangeja järel on rahad käes ja päev läbi.
Jaanus jookseb Evely ässade otsa Posted Sunday 17th September, 2023 at 20:33(UTC+0) by maheaaatom
Kõik foldivad kuni blindideni (Jaanus ja Evely) ning Jaanus lükkab kiirelt all-in. See liigutus on tal veres.
Aga veelgi kiiremini tuleb Evely call. Eelmisel korral kunnid, nüüd punased ässad.
Jaanus hüppeb toolilt nagu kuulist lastu ja laseb kuuldavale paar vandesõna. Puhas bluff - !
Flopis on küll üks kuus, kuid Evely õnneks turn ja river midagi ei muuda. Tal nüüd umbes 240K.
Player
Chips
Progress
Evely Pihela
240,000
86,000
Jaanus Veste
0
0
Virgo duubeldab oma ministäki Posted Sunday 17th September, 2023 at 20:25(UTC+0) by maheaaatom
Virgo Laansoo on pärast floppi oma 19K-ga keskel ning saab calli Algirdas Saveikiselt.
Virgo näitab flopand rida , paraku pole tal ühtegi ärtut.
Kui Saveikis oma kaarte () näitab, võib Virgo kergemalt hingata. Samuti ei ühtegi ärtut.
Turn on neljas ärtu, river Virgo õnneks blank.
29 mängijat on järgi, veel 5 kohta rahadeni.
Rikardi nupud lähevad Mariusele Posted Sunday 17th September, 2023 at 20:17(UTC+0) by maheaaatom
Rikard Relander on keskel -ga ning mõistagi on vastas laua agressor Marius Morel.
Mariusel seekord , mis ka kenasti vastu peab. Rikardi all-in'i eelne stäkk oli umbes 30K.
Player
Chips
Progress
Rikard Relander
0
0
Öine Omaha Posted Sunday 17th September, 2023 at 20:16(UTC+0) by maheaaatom
Veelkord infoks, et lisaks kahele käimasolevale sõrmuseturniirile saab hetkel osaleda ka põhiturniiri satikal ning kell 23:00 on algamas tänane ainus kõrvalturniir - 250 € PLO 4/5 Cards.
All kasiinos on avatud ka mõned cashilauad, kuid üldiselt on tänane õhtu pühapäevale iseloomulikult märksa rahulikum kui eilne.
Algas tänane viimane paus Posted Sunday 17th September, 2023 at 19:49(UTC+0) by maheaaatom
Mängijad lubati 20 minutiks puhkama ning see on tõenäoliselt ka viimane paus 1B ajal.
Alles on 34 mängijat, blindid pärast pausi 2500/5000/5000 ja keskmine stäkk kõigest 22XBB. 24 parima selgumisel on päev kotis.
Evelyle duubeldab läbi Jaanuse Posted Sunday 17th September, 2023 at 19:47(UTC+0) by maheaaatom
Vladislav Topilskiy avab 8K-ga, saab ühe calli ning buttonil istuvalt Jaanus Vestelt 45K ületõste. Tema järel lükkab all-in SB-l istuv Evely Pihela (65K).
Teised foldivad, Jaanusel tuleb mõistagi callida.
Evely:
Jaanus:
Lauda numbripuru ning Evelyl nüüd 154K. Jaanusel jääb umbes 70K alles, ka temal pole midagi väga hull veel lahti.
Player
Chips
Progress
Evely Pihela
154,000
84,000
Jaanus Veste
70,000
15,000
Kõva kisa satelliidilauast Posted Sunday 17th September, 2023 at 19:40(UTC+0) by maheaaatom
Satelliidilauast oli kosta kõva kisa ja naeru. Põhjus selles, et Priit Ojal õnnestus mingi täieliku mudakaardiga family-all-in ära võita. Üks, kes kassa poole sörkis, oli igatahes Marek Selgeveer.
Satelliidil hetkel 47 sisseostu.
Marius hoiab agressiivset joont Posted Sunday 17th September, 2023 at 19:35(UTC+0) by maheaaatom
Marius Morel on oma lauas selgelt kõige agressiivsem mängija, olles viimased 3 kätt järjest EP-lt tõstega avanud.
Esimesel korral sai ta vastu all-in'i laua chipliidrilt (ja foldi), teisel tulid blindid koju ja kolmandal vastas all-in'iga Mariuse kõrval istuv shortstäkk (umbes 25K) Glen Kolmer. Mariuselt mõistagi call.
Glen:
Marius:
Glen saab flopis seitsmele pihta ning tagatipuks ka masti. See duubel teda aga ei päästa, juba ülejärgmise käega kukub ta ikkagi välja.
Player
Chips
Progress
Glen Kolmer
0
0
Ranno koht on tühjaks jäänud Posted Sunday 17th September, 2023 at 19:21(UTC+0) by maheaaatom
Piisas vaid hakata rääkima meie mängijate stäkkidest ja hakata neid kirja panema, kui juba tuhises mängusaalist välja Ranno Sootla. Tema lauas on kaks väga suure stäkiga välismängijat, ju ta neile oma stäki kaotas.
Satelliit läks ka käima, mängijaid on 38. PL 2-7 Triple draw pole aga endiselt auhinnafondi kasvatanud, hetkel kõigest 34 sisseostu, neistki omajagu korduvaid.
Eestlaste stäkid Posted Sunday 17th September, 2023 at 19:16(UTC+0) by maheaaatom
Eestlastest on suurima stäkiga Marius Morel (ca. 140K), ka Ranno Sootla ja Evely Pihela seis on igati kiiduväärne. Kokku 9 Eesti mängijat.
Kahjuks on aga mängust väljas vastne meister Aleksei Smirnov nagu ka Annemar Neiland ja Tarmo Tammel.
Player
Chips
Progress
Marius Morel
140,000
120,000
Ranno Sootla
87,000
67,000
Evely Pihela
70,000
0
Keito Kaljulaid
68,000
48,000
Virgo Laansoo
65,000
45,000
Vladislav Topilskiy
63,000
43,000
Jaanus Veste
55,000
35,000
Rikard Relander
40,000
20,000
Glen Kolmer
35,000
15,000
1B mängitakse kuni 24 parimani Posted Sunday 17th September, 2023 at 19:07(UTC+0) by maheaaatom
1B-lt jõuab homsesse päeva ehk rahadesse 24 parimat (koos 1A-ga seega 50 mängijat).
Selleks peavad täpselt pooled hetkel lauas istuvatest 48 mängijat välja langema. Keskmine stäkk on umbes 30XBB kandis, blindid 1000/2500/2500.
Satelliidi ootel Posted Sunday 17th September, 2023 at 18:58(UTC+0) by maheaaatom
Tänasele põhiturniiri satelliidile on reganud 13 mängijat ning paar minutit veel aega. Seega pole väga tõenäoline, et mäng kell 21:00 algaks, küllap lähevad mõned minutid üle. Aga käima peaks action kindlasti minema.
Pole vist päris eestlaste mäng? Posted Sunday 17th September, 2023 at 18:45(UTC+0) by maheaaatom
Kõrvalruumis on käimas Ring Event #4 2-7 Triple Draw. Võimalik, et just selles formaadis on kõige lihtsam sõrmus võita, sest hetkel leiame lauast kõigest 28 mängijat (kokku 31 sisseostu).
Kätt on küll juba proovinud ka maailmakuulus high-roller Ilari Sahamies, kuid ning suurem osa mängijatest ongi soomlased. Eesti mehi esindavad Jaan Vaabel, Aleksandr Arutjunov ja Ilya Nikiforov.
Evely on rahul Posted Sunday 17th September, 2023 at 18:38(UTC+0) by maheaaatom
Evely mäng on kulgenud selgelt ülesmäge, ta on enam kui duubeldanud ning ka ühe konkurendi välja löönud.
Meie mängijatest on veel väljas Mark Metsla, Arko Akenpärg, Taago Tamm ja Janek Tammsaar. Jätkab 66 parimat, hetkel tase 1000/2000/2000.
Aleksei järgmise sõrmuse jahile Posted Sunday 17th September, 2023 at 18:32(UTC+0) by maheaaatom
1100 € turniiril oma elu esimese WSOP Circuit kuldsõrmuse võitnud Aleksei Smirnov (muuhulgas ka 2018. aasta maailmameister!) on lauas ka 350 € turniiril ning sattunud kõrvuti Ranno Sootla endaga. Vaata, mida Aleksei pärast võitu rääkis!
Kvalifitseeru WSOP Circuit'ile online'is! Posted Sunday 17th September, 2023 at 18:20(UTC+0) by maheaaatom
Täna on sind hea võimalus ka OlyBetist WSOP Circuit turniiripilet võita. Kui jälgid võistlusi internetis ning sul on ka plaanis ka pokkerit kõrvale mängida, siis pööra tähelepanu nendele turniiridele:
Kell 20:00 - €11 WSOPC Tallinn Online Event W11 Overlay Hunt Final - 5x €350 kohta GTD Kell 21:00 - €100 WSOPC Tallinn W100 Final - 3x €1,500 kohta GTD Kell 21:35 - WSOPC Tallinn Online Ring Event Satellite - 10x €350 kohta GTD Kell 22:00 - €250 WSOPC Tallinn W250 Final - 4x €1,500 kohta GTD
Pidi see Tammel ka need ässad leidma! Posted Sunday 17th September, 2023 at 18:16(UTC+0) by maheaaatom
Kolmest Eesti naisest on üks välja langenud ning end tagasi ostnud ta pole.
Maili vajus üsna lühikeseks ning siis kui ta viimaks lükkas, leidis (samuti lühike) Tarmo Tammel ässade paari.
Teistest Eesti naistest on Annemaril 21,5K ning Evelyl 14K, alustati 20 000 punktiga. Olgu ka mainitud, et väikseim stäkk, millega päevalt 1B edasi jõuti, oli 30K.
Re-entryd läbi, kokku 383 sisseostu Posted Sunday 17th September, 2023 at 18:12(UTC+0) by maheaaatom
Kui 1A-l tehti 200, siis 1B-l 89 sisseostu, seega võime oodata siitki umbes 7-8 tunnist avapäeva.
Hetkel on 89 mängijat laudades ning juurde tulla enam keegi ei saa, sest re-entry periood on läbi.
Blindid 1000/1500/1500, keskmine stäkk 41124.
Rahvaturniir või tõsine action? Posted Sunday 17th September, 2023 at 17:41(UTC+0) by maheaaatom
Laudades võib näha kahte tüüpi mängijaid - ühed võtavad asja väga tõsiselt, teistele on tegemist justkui 10-eurose kodumänguga, kuhu on tuldud pigem lõbusalt aega viitma.
Tõsi on muidugi see, et peagi enam re-entryt teha ei saa. Sellest hoolimata on juba tehtud tubli 172 sisseostu ning pausi jooksul saab neid veel juurdegi teha.
Turniiri lõplik osalejate arv saab niisiis selgeks pärast kohe algavat 20-minutilist pausi.
Kes mängivad? Posted Sunday 17th September, 2023 at 17:29(UTC+0) by maheaaatom
1B-l domineerivad välismaalased, kuid kohal on ka palju nimekaid Eesti mängijaid eeotsas ühe selle aasta komeedi Keito Kaljulaiu, suure actioni mehe Mark Metsla, kõikjale jõudva Tarmo Tammeli, WSOP käevõtu omaniku Ranno Sootla, showmehe Jaanus Veste ning high-roller Taago Tammega.
Naistest on võistlustules juba 1A-l kätt proovinud Annemar Neiland, ürituse hostess Evely Pihela ning eelkõige pubipokkeris tuntud Maili Tannbaum. "Noh, eks ma siis tulin ka sellele n.ö. rahvaturniirile," ütles alati heatujuline Maili enne mänguga liitumist.
Alustame päeva 1B ülekannet Posted Sunday 17th September, 2023 at 17:24(UTC+0) by maheaaatom
WSOP Circuit Ring Event #3 NLH 350 € on täies hoos. Avapäeval 1A tehti 200 sisseostu, kuid 1B on samuti väga populaarne. Hetkel juba 166 sisseostu koos (89 mängijat) laudades ning late reg. on veel avatud kuni esimese pausi lõpuni.
Käimas on 10. tase, blindid 600/1200, nimetatud pausini jääb umbes veerand tundi.
17:22 (UTC+0)
Day 1B of WSOPC Tallinn Started Level: 1 Blinds: 100/200 Ante: 200
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.