0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0059 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/27/117/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/27/117/updates', 1, '2024-07-27')

0.0003 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.0232 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0051 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '96' AND `published` = 1

0.0233 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0049 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '117' AND `published` = 1

0.0230 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0049 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '121' AND `published` = 1

0.0057 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.0046 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.0055 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.0053 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.0053 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.0053 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.0053 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.0050 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.0053 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.0051 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.0053 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.0051 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.0050 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.0051 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.0157 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.0050 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.0054 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.0052 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.0058 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.0052 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.0050 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.0050 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.0050 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.0052 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.0053 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.0053 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.0053 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.0052 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.0052 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.0052 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.0149 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.0054 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.0052 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.0053 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.0054 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.0053 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.0053 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.0052 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.0055 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.0054 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.0051 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.0052 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.0053 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.0051 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.0053 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.0050 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.0050 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.0155 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.0051 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.0053 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.0053 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.0053 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.0054 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.0053 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.0053 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.0054 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.0058 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.0053 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.0053 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.0053 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.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

Translate
WSOPC Tallinn Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 1B
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 . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.