0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0065 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_estonian_championship_olybet_bounty_king'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2023_estonian_championship_olybet_bounty_king', 1, '2024-12-26')

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

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

0.0005 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0002 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0035 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

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

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

0.0285 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0067 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '62'
AND `published` = 1

0.0062 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` = '62'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0062 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` = '62'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '2836'
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` = '2835'
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` = '2834'
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` = '2833'
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` = '2832'
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` = '2831'
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` = '2830'
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` = '2829'
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` = '2828'
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` = '2827'
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` = '2826'
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` = '2825'
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` = '2824'
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` = '2823'
ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2822'
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` = '2821'
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` = '2820'
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` = '2819'
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` = '2818'
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` = '2817'
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` = '2816'
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` = '2815'
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` = '2814'
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` = '2813'
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` = '2812'
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` = '2811'
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` = '2810'
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` = '2809'
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` = '2808'
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` = '2807'
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` = '2806'
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` = '2805'
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` = '2804'
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` = '2803'
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` = '2802'
ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2801'
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` = '2800'
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` = '2799'
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` = '2798'
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` = '2797'
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` = '2796'
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` = '2795'
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` = '2794'
ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2793'
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` = '2792'
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` = '2791'
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` = '2790'
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` = '2789'
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` = '2788'
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` = '2787'
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` = '2786'
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` = '2785'
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` = '2782'
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` = '2781'
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` = '2780'
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` = '2779'
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` = '2778'
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` = '2777'
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` = '2776'
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` = '2775'
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` = '62'
ORDER BY `busted` ASC, `current_chips` DESC

0.0060 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` = '62'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2836'
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` = '2835'
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` = '2834'
ORDER BY `chip_change` DESC, `busted` ASC

0.0093 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2833'
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` = '2832'
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` = '2831'
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` = '2830'
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` = '2829'
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` = '2828'
ORDER BY `chip_change` DESC, `busted` ASC

0.0083 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2827'
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` = '2826'
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` = '2825'
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` = '2824'
ORDER BY `chip_change` DESC, `busted` ASC

0.0080 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2823'
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` = '2822'
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` = '2821'
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` = '2820'
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` = '2819'
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` = '2818'
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` = '2817'
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` = '2816'
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` = '2815'
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` = '2814'
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` = '2813'
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` = '2812'
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` = '2811'
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` = '2810'
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` = '2809'
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` = '2808'
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` = '2807'
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` = '2806'
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` = '2805'
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` = '2804'
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` = '2803'
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` = '2802'
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` = '2801'
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` = '2800'
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` = '2799'
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` = '2798'
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` = '2797'
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` = '2796'
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` = '2795'
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` = '2794'
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` = '2793'
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` = '2792'
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` = '2791'
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` = '2790'
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` = '2789'
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` = '2788'
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` = '2787'
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` = '2786'
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` = '2785'
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` = '2782'
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` = '2781'
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` = '2780'
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` = '2779'
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` = '2778'
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` = '2777'
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` = '2776'
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` = '2775'
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` = '62'
ORDER BY `busted` ASC, `current_chips` DESC

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2020

    

Open Modal

Hi,

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

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

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

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

• £   GBP
• $   USD
• €   EUR

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

Login / Register

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

English

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

• £   GBP
• $   USD
• €   EUR

Estonian Poker Championship OlyBet Bounty King – EMV 2023 Opening Event Live Reporting - Day 1

Estonian Poker Championship - Live Reporting

OlyBet Bounty King – EMV 2023 Opening Event See other events

OlyBet Bounty King – EMV 2023 Opening Event Team Event 2023 Põhiturniir (Main Event)

Estonian Poker Championship - Live Reporting OlyBet Bounty King – EMV 2023 Opening Event Team Event 2023 Põhiturniir (Main Event)

---

Current Level 0 Current Day 1

---

Blinds - Ante -

Entries 155 Remaining 1

---

Prize Pool (EUR) €7,291 First Prize (EUR) €1,715

Chip Leaders Day 1

1

Danel Kunman

4,650,000

Day 1

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 1

18:05 (UTC+2)

Day 1 of Estonian Poker Championship Ended
Level: 0     Blinds: 0/0     Ante: 0

1. koht Danel Kunman - 1715 € Posted Sunday 2nd April, 2023 at 09:52(UTC+2) by maheaaatom

Eesti meistrivõistluste soojendusturniiri võitis Danel Kunman, kes teenis 1715 eurot + bountyd. Eesti meistrisõrmust selle turniiri võitmisega küll ei kaasnenud, kuid turniirivõit teeb au igaühele.

Teise koha saavutas Joosep Tool (1181 eurot) ning kolmanda Heimar Lill (897 eurot). Võitja selgus pisut enne kell nelja hommikul.

Tiilivõistlused jätkuvad pühapäeval kell 12:00 Olympic Casinos algava 100-eurose sisseostuga rahvaturniiriga, millel on kavas kaks avapäeva - 1A ja 1B. Sellel kanalil toimub järgmine ülekannet esmaspäeval, mil viiakse läbi põnev ning meeleolukas tiimiturniir.

Player		Chips	Progress
Danel Kunman		4,650,000	4,450,000
Marek Liiva		0	0
Andres Samarüütel		0	0
Vladimir Iljunin		0	0
Taras Melnyk		0	0
Yanis Sahli		0	0
Vitali Rakov		0	0
Heimar Lill		0	0
Joosep Tool		0	0

10. koht Rain Ikla - 175 € Posted Sunday 2nd April, 2023 at 02:01(UTC+2) by maheaaatom

Rain Ikla proovib -ga Andres Samarüüteli vastu, kuid üheksad peavad ilusti vastu. Sellega sai tänase turniiri finaallaud kokku enam-vähem täpselt selleks ajaks, mida me ka prognoosisime.  

Ühtlasi lõpetame tänase live-blogi, sest finaallaus toimuvat saavad öised pokkerisõbrad jälgida telelauas. Homme leiate siit ülekandest turniiri lõpptulemused ning Olympic Casino lehelt ka kokkuvõtliku artikli.

Player		Chips	Progress
Rain Ikla		0	0

Haruldased külalised Posted Sunday 2nd April, 2023 at 01:57(UTC+2) by maheaaatom

Mõnda aega tagasi väisas turniiriala ETPF-i asutajaliige ning aastatel 2010-2012 juhatusse kuulunud Rainer "Ranka" Roomet. 

Nii elukutselise mängijana kui Pokkeriprode veebilehe eestvedajana tuntuks saanud "Ranka" ise EMV-l osaleda ei plaani, vaid tuli lihtsalt üle aastate vanadele sõpradele tere ütlema. Tänapäeval tegutseb mees ettevõtjana ning veab mitmesuguseid veebiärisid. 

11. koht Helina Tamm - 175 € Posted Sunday 2nd April, 2023 at 01:48(UTC+2) by maheaaatom

Kaotasime tänase parima naismängija Helina Tamme. Ta oli vahepeal koguni turniiri chipliider, kuid lõpus läks mäng juba loteriiks ning õigel ajal sai ka õnn otsa. 

Kindlasti näeme aga Helinat sel EMV-l aktiivselt mängimas ning loodame, et tal õnnestub saada ka palju paremaid kohti. 

Kuigi paar jaotust hiljem on kuningas-kõrgega all-in ministäkiga Joosep Tool, me veel finaallauani ei jõua. Nimelt on Yanisel vastu panna vaid emand-kõrge (mõlemal ebaõnnestunud mastitõmme). Joosep tõuseb umbes 250K peale. 

Player		Chips	Progress
Helina Tamm		0	0

River päästab Heimari Posted Sunday 2nd April, 2023 at 01:44(UTC+2) by maheaaatom

Heimar Lill on täna samuti üsna rahulikult kulgenud, kuid oma stäkki kenasti hoidnud ning õigetel hetkedel kasvatanud.

Oma 170K stäki lükkas ta sisse -ga Yanise vastu. Prantslase jaoks oli kõik hea kuni riverini, mis oli äss. 

Heimari stäkk on muide endiselt alla keskmise. Blindid 12000/24000/24000 ning keskmine stäkk 19XBB. 

12. koht Reido Sepp ja 13. koht Deniss Davõdov - mõlemad 160 € Posted Sunday 2nd April, 2023 at 01:33(UTC+2) by maheaaatom

Oleme lähenemas finaallauani, ühe minuti jooksul veel kaks langejat. 

Player		Chips	Progress
Reido Sepp		0	0

14. koht - Leino Piller 160 € Posted Sunday 2nd April, 2023 at 01:31(UTC+2) by maheaaatom

Leino on heaks näiteks sellele, kui halvasti võib laua vahetus mõnikord mõjuda. Ta valitses täielikult telelauda ja tõusis seal võimsaks chipliidriks.

Pärast pausi ja uude lauda minekut jagas Leino oma nööpe vasakule ja paremale. Suurem osa allesjäänud 300K-st läks Andres Samarüütelile vs. , turnis kuningas. 

Player		Chips	Progress
Leino Piller		0	0

15. koht Birgit Tammel - 146 € Posted Sunday 2nd April, 2023 at 01:13(UTC+2) by maheaaatom

Samuti väikese stäkiga virelenud Birgit Tammel langes -ga vastu. Nagu pokkeris juba kombeks, määras jaotuse võitja river. Aga ega see Birgiti alati suurepärast head tuju siis ära rikkunud. Elu on ilus ja jätkub juba järgmistel turniiridel! 

Player		Chips	Progress
Birgit Tammel		0	0

16. koht Andrei Mjagkov - 146 € Posted Sunday 2nd April, 2023 at 01:10(UTC+2) by maheaaatom

Telelauast veel üks langeja - Andrei Mjagkov. Andrei suutis mängida terve turniiri nii, et teda oli väga vähe märgata. Aga tasuks siiski rahadesse tulek.

Vahelduseks ka rahameeste jutte. Leino väidab, et on saanud kätte oma 20 bountyt. See tundub siiski väike liialdus, kuid 5-euroseid žetoone on tema ees siiski hulgim.  

Reido duubeldab läbi Leino Posted Sunday 2nd April, 2023 at 01:05(UTC+2) by maheaaatom

Reido Sepp saab oma 72K ministäki duublisse Leino Pilleri vastu. Reidol , Leinol . Mõlemad mehed saavad laua toel kaks paari. Leino on oma hiidstäkist üle poole ära andnud ning hetkel umbes 300K peal. 

Player		Chips	Progress
Leino Piller		300,000	333,500

Mauno on mull, Janek Hin 17. koht - 146 € Posted Sunday 2nd April, 2023 at 01:01(UTC+2) by maheaaatom

Telelauas on kolm mängijat preflopist sees: 

Janek Hin: Danel Kunman:  ja Mauno Pihu:  . Lauda ....ja ! Mauno mullimees, Janekile 17. koht ja lohutuseks 146 eurot. 

Player		Chips	Progress
Janek Hin		0	0
Mauno Pihu		0	0

Algas mullimäng Posted Sunday 2nd April, 2023 at 00:49(UTC+2) by maheaaatom

PFAI Arko Akenpärg vs. Joosep Tool . Flopis äss ning kuigi turni järel oli Arkol veel kuus outi, neist paraku ükski pärale ei jõudnud. 

Toimus ka väike re-grupeering, mille käigus viidi mängijad kahele lauale.

Pre-mull venib Posted Sunday 2nd April, 2023 at 00:40(UTC+2) by maheaaatom

Endiselt on laudades 19 mängijat ning välja kukkuda ei taha keegi. Birgit Tammel oli sellele küll üsna lähedal, sattudes -ga endast pisut suurema Andres Samarüüteli vastu. Tema õnneks avati lauas kaks paari ning mõlemal mängis ainult ässa-kicker.

Mäng jätkub Leino juhtimisel Posted Sunday 2nd April, 2023 at 00:25(UTC+2) by maheaaatom

Turniir jätkub ning meid ootab ees 100 minutit pokkerit. Tõenäoliselt jõuame selle aja sees ka finaallauni või vähemalt sellele väga lähedalt. 

Viimased kaks tundi telelauas möllanud Leino Piller on turniiri võimas chipliider 633 500 punktiga. Prantslane Yanis Sahli on suutnud kokku kraapida 352 000 punkti, ülejäänud (endised telelaualised) on aga kõik selgelt alla keskmiste stäkkidega.

Player		Chips	Progress
Leino Piller		633,500	437,500
Yanis Sahli		352,000	0

Kesköine paus 15 minutit Posted Sunday 2nd April, 2023 at 00:08(UTC+2) by maheaaatom

Mängijad saadeti 15 minutiks puhkama. Alles on 19 parimat, seega on mull vaid kahe koha kaugusel.

Pärast pausi jätkame blindidega 6000/12000/12000, keskmine stäkk on hetkel 244737 ehk vaid 20XBB. 

Henri plaanid Posted Sunday 2nd April, 2023 at 00:04(UTC+2) by maheaaatom

Eesti Pokkeri Kuuluste Halli liige ning viiekordne Eesti pokkerimeister Henri Käsper tänaste osalejate hulka ei kuulu, küll näeme teda aga tiimiturniiril ja loodetavasti ka high-rolleril. 

Juba eelmisel sajandil Eesti tippu kuulunud Henri on endiselt tippvormis ning hetkel peamine kandidaat 2023. aasta live-mängija auhinnale. Samas tuleb arvestada, et aasta on veel noor. 

Tahaks, et läheks lõpuni nii hästi Posted Saturday 1st April, 2023 at 23:49(UTC+2) by maheaaatom

Helina Tamm on omas lauas kindel liider, tal juba 400K stäkk. Seda on umbes sama palju kui Vladimiril. 

"Tahaks vaid, et läheks nii hästi kuni lõpuni," sõnab silmnähtavalt õnnelik Helina ise. No miks ei peaks?

Viimane langeja Vitaly Titov, kel läks pisut õnnetult - tema sai PFAI tappa teise Vitali (Rakovi) käest, sest floppi prantsatas kaks. Alles 23 pokkerimängijat.

Player		Chips	Progress
Helina Tamm		400,000	150,000

Kertu mängust väljas, Janek Hin kukkus neliku otsa Posted Saturday 1st April, 2023 at 23:38(UTC+2) by maheaaatom

Janek Hini näost paistab kerge pilvitus, seevastu särab Vitali Rakov nagu jõulupuu. 

Nimelt olla Rakov juba turnis neliku saanud ning riveril masti tabanud Janek arvas, et just temal on parim kaart. See läks talle maksma umbes 100K. 

Samast lauast langes äsja Kertu Paju, kelle suur stäkk oli umbes 70K peale kahenenud. Viimased nupud läksid Danel Kunmanile. Väljas ka Raimo Kaljulaid ja Stanislav Smeljov. vs.

Player		Chips	Progress
Kertu Paju		0	0
Raimo Kaljulaid		0	0
Stanislav Smeljov		0	0

Turniiril on uus liider Posted Saturday 1st April, 2023 at 23:23(UTC+2) by maheaaatom

Action-laua hiiglased on natuke üksteist söönud ning teistelegi andnud, seega liidrite sealt lauast enam otsima ei pea.

Küll leiame ta aga kõrvallauast. Vladimir Iljuninil on umbes 400 000 nuppu! Tema lauas on veel üks suur stäkk Danel Kunmanil - ca. 200K. 

Player		Chips	Progress
Vladimir Iljunin		400,000	287,000

Kolm lauda Posted Saturday 1st April, 2023 at 23:17(UTC+2) by maheaaatom

Oleme jõudnud 27 viimase mängija ning kolme viimase lauani. Keskmine stäkk on endiselt pisut alla 30xBB ning väljalangejaid vaikselt lisandub. Väljas on näiteks Hanno Kerem ja Egon Kaljulaid, naismängijatest aga Jelena Maidla. 

Action-lauast viidi telelauda Birgit Tammel, kellel on ka kindlasti palju kaasaelajaid.

Sama palju kui turniirilauda - 3 - on avatud ka cashilauda, kus mängima nii mõnigi rahalaua ekspert kui ka Bounty-turniirilt väljalangenu.

Ma armastan live-pokkerit! Posted Saturday 1st April, 2023 at 22:52(UTC+2) by maheaaatom

Nii kordab rõõmus Helina Tamm, kes on tõusnud umbes veerand miljoni peale ning korjab lisa sellest hoolitama, et tema lauas on sellised saurused nagu Joosep Tool ja Rain Ikla.

Veel 15 tagasi pelgas Helina live-pokkerit väga, kuigi internetipokkeris oli ta tõenäoliselt Eesti edukaim naismängija. Nüüd tunneb ta end live-laudades aga nagu kala vees. 

Player		Chips	Progress
Helina Tamm		250,000	100,000

Tal on "liiga palju" Posted Saturday 1st April, 2023 at 22:43(UTC+2) by maheaaatom

Nii öeldakse Jan Hini stäki kohta, kes laiutab oma lauas 300K nööbiga. 

Joosep Tool paistab endiselt olema turniiri kapten, kuigi ka tema kõrvalt võime leida ühe väga võimsa stäki - Rain Iklal on ca. 200K.

Käimas on ka cashgame, blindid 1/3. DJ-puldis endiselt Alvar Orula, kes mängib tõesti head biiti, mis peaks sobima suhtkoht kõigile vanuses 21-50. 

Player		Chips	Progress
Janek Hin		300,000	94,000
Rain Ikla		200,000	0

Henrik langes ässadega Posted Saturday 1st April, 2023 at 22:32(UTC+2) by maheaaatom

Tänane viimane kuulsus Henrik Raave langes telelauas pocket ässadega emandate vastu, lauas ka üks emand. See tähendab lõpparvestuses 45. kohta. Henriku seis ei olnud muidu üldse paha, ta oleks võinud vabalt ka (vähemalt) rahadesse venitada.

Enam väljalööjat "kümne tonniga" ei õrritatud, tasuks siiski kena napsupudel.

Player		Chips	Progress
Henrik Raave		0	0

Jäime ilma ka Kristinast Posted Saturday 1st April, 2023 at 22:30(UTC+2) by maheaaatom

Kahe "i"-ga Kristiina on väljas, nüüd siis ka ühe "i"-ga sõbranna Kristina N.

Tema jäi jõuetuks vastu. Aga ega Kristina stäkk kuigi suur olnud ka. Viimaste langejate seas on ka Urmo Einard ja Ruben Rahumägi.

Seitse naist Posted Saturday 1st April, 2023 at 22:18(UTC+2) by maheaaatom

48 allesjäänu seas on veel seitse naismängijat, kellest nii mõnelgi on täiesti arvestatav stäkk. Eriti vinge on Kertu Paju ja Helina Tamme seis, neist esimesel on umbes 180K. 

Aga virisema ei pea ka Birgit Tammel. Ja ega Birgit üldiselt olegi mingi viriseja. Temal ca. 100K. 

Player		Chips	Progress
Kertu Paju		180,000	50,000

Mäng jätkub Posted Saturday 1st April, 2023 at 22:09(UTC+2) by maheaaatom

Pokkerisõbrad on taas laudades ning diilerid kaarte jagamas. Nüüd on meid ootamas 6 järjestikkust levelit ehk mängime jutti umbes südaööni. 

Finaallauni peaksime jõudma vast umbes kahe-kolme paiku öösel, võib-olla ka pisut varem. Mänguruumi just ülearu palju ei ole - hetkel blindid 1500/3000/3000, keskmine stäkk 87736.

Kertu saab Andi ümbriku. Kas tõesti 10 tonni? Posted Saturday 1st April, 2023 at 22:03(UTC+2) by maheaaatom

Andi Raig on all-in ning saab kolm calli. Lauda jookseb ning kuni riverini on kõik mängus. Siis teeb Kertu Paju 20K panuse, millele calle ei järgne. Kertu avab ning näitab riveris saadud kahte paari. Andi juhtis seejuures kuni riverini...

Värisevate kätega tegi Kertu ümbriku lahti. Kümme tonni teeks ju õnnelikuks igaühe. Ümbrikus on aga OlyBeti kuldsed kaardid, seega ikkagi aprill! Õnneks on Kertul ca. 130K stäkk, mis jääb samas lauas alla vaid Reido Sepale (150K).

Mängijad saadeti taas pausile, mis kestab seekord 40 minutit. Laval on taas Tom Cats Laura Prits, kelle esituses kõlab Queeni legendaarne We Will Rock You.

Jätkame kell 22:00, konkurentsis on 54 parimat. Chipliider on endiselt Joosep Tool umbes 350K stäkiga.

Player		Chips	Progress
Joosep Tool		350,000	100,000
Kertu Paju		130,000	0
Kertu Paju		0	120,000

Kristina ja Kristiina Posted Saturday 1st April, 2023 at 21:12(UTC+2) by maheaaatom

Toreda paari on tänasel turniiril moodustanud algusest peale kõrvuti istunud Kristiina Sultangarejev-Tuder ja Kristina N. Naised on nautinud vaikselt eelkõige teineteise seltskonda, palju juttu vestnud ning veetnud üheskoos lõbusa turniiri.

Paraku jäime kahe "i"-ga Kristiinast just ilma - ta kaotas oma stäkinatukese -ga Mahdieh Mahmoudi -le. Mahdieh noppis lisa ka kohe järgmises jaotuses, mil tema sai jagu konkurentide -st ja -st. Naise stäkk nüüd pea 100K. 

Maarja-Liis väljas, kes saab 10 tonni? Posted Saturday 1st April, 2023 at 21:00(UTC+2) by maheaaatom

Telelauast võeti välja Maarja-Liis Ilus ning tema "pearahaks" osutus Blackjack Rum. 

Üks ümbrik on veel alles, nimelt Andi Raigi pea eest. Andres Puusepp on mängijaid juba pikka aega õrritanud sellega, et ümbrikus on kümme tonni. Kas see on tõsi või mitte, me ei tea. Tasub siiski meelde tuletada, et täna on esimene aprill. Aga mine võta kinni...

Robert sai naiselt loa flipata Posted Saturday 1st April, 2023 at 20:58(UTC+2) by maheaaatom

Kui eelmisele Flip & Go eelvoorule joosti sõna otseses mõttes tormi, siis teisel katsel läks kaheksa mängija kokkusaamisega juba märksa rohkem aega. 

Oma shotti tegi ka Robert Rool, kes olla selleks õhtujuhi sõnul naiselt loa saanud. Finaali piletit Robertil siiski kahjuks ära flipata ei õnnestunud. 

Turniiri liidrid on Joosep Tool ja Janek Hin Posted Saturday 1st April, 2023 at 20:54(UTC+2) by maheaaatom

Kiire ülevaatus näitab, et turniiri kaks kõige rikkamat meest on Joosep Tool (umbes 250K) ja Janek Hin (206K).

Üle 100K stäkke on teisigi, nt. Stanislav Smeljov, Raimo Kaljulaid ja Vladimir Iljunin. 

Naistest paistab parimas hoos olevat endiselt Helina Tamm, kes on koos Maarja-Liisiga telelauas.

Tormijooks lauale nr. 10 Posted Saturday 1st April, 2023 at 20:43(UTC+2) by maheaaatom

Andres Puusepal piisab vaid öelda, et ühel lauas on algamas järjekordne Flip & Go eelvoor, kui mängijad juba ründasid seda lauda nagu Nõukogude inimesed Tallinna Kaubamaja A-korpuse ust pärast avamist. 

Kaheksa inimest saadi sõna otseses mõttes kokku ühe hingetõmbega. Mängitakse Crazy Pineapple formaadis, 3 kaarti kätte ning pärast floppi tuleb üks foldida. Seejärel võidab juba see, kes saab pärast turni ja riverit parima viie kaardi kombinatsiooni. 

Ühesõnaga tegemist on hullumeelse mänguga, mis võimaldab jõuda EMV-l rahadesse ka sel, kes üldse pokkerist mitte midagi ei tea. Siiski on lauas võtnud koha sisse eranditult tuntud ja hinnatud mängijad. Flippama läksid ka mitmed need, kes Bounty-turniiril veel kenasti sees. 

Jagamisele läheb 7291 eurot pluss bountyd Posted Saturday 1st April, 2023 at 20:32(UTC+2) by maheaaatom

Turniiri üldisesse potti läheb täpselt 7291 eurot. Ülejäänu moodustavad bountyd, 20 eurot näo pealt. 

Auhinnaraha jagub 17 parimale. Võitja teenib 1715 eurot (+ bountyd), viimane rahakoht 146 eurot. 

Tekstiblogi kestab kuni finaallaua selgumiseni. Kuna turniiril on ka TV-laud, siis tasub finaali vaadata juba live-pildis. On tuntud huvi ka piltide kohta - need leiate hõlpsalt OlyBet Events lehelt seda pisut allapoole kerides. Seal on ühtlasi ka muu vajalik EMV info - kava, uudised, oluline teave ning nii live- blogi kui pilt. 

Turniir jätkub 90 mängijaga Posted Saturday 1st April, 2023 at 20:23(UTC+2) by maheaaatom

Tom Cats Laura Prits lõbustasid meid ligikaudu kolmveerand väldanud särtsaka kontserdiga. Esitati erinevaid tuntud rockhitte nii maailmast kui ka Eestist.

Seejärel peatuti pisut ka eelmise aasta põhiturniiril ning allesjäänud 90 mängijat võisid taas laudades istet võtta. DJ on astunud pulti ning mäng võib jätkuda. 

P.S. Ühtlasi alustab telelaud, kuhu sattus ka paljude lemmilaulja Maarja-Liis Ilus. 

Kõnelevad Laur Sibold ja Eve Järve Posted Saturday 1st April, 2023 at 19:29(UTC+2) by maheaaatom

Oma lühikeses kõnes soovitab Laur liituda ETPF-iga ning räägib algavatest turniiridest. Samuti edastab ta oma tänusõnad ETPF-i toetajatele, Olympic Casinole ning ETPF-i juhatuse liikmetele, kes on "looma moodi tööd teinud".

Sõna saab ka Olympic Casino ja OlyBeti turundusjuht Eve Järve, kes soovib kõikidele osalejate head kaardijooksu ning palju häid emotsioone. '

Laval on Tom Cats Laura Prits.

Henriku õnnelikud kümned Posted Saturday 1st April, 2023 at 19:25(UTC+2) by maheaaatom

Henrik Raave on all in vsvs. Lauda jookseb numbripuru, äss-kuningaga mänginud Ilona Sibold on igatahes mängust väljas. 

"Mis asja, kas ma võitsin või?" uurib Henrik. "Jah, kõik võitsid!" kõlab vastuseks. "Okei, ma siis lähen käin korraks ära," märgib Henrik ning kaob lauast. 

Tegelikult pannaksegi kogu turniir pausile ning algab avamispidu.  Avasõnad on ETPF-i presidendil Laur Siboldil.

Juba alla saja mängija Posted Saturday 1st April, 2023 at 19:20(UTC+2) by maheaaatom

Hetkel on blinditase 600/1200/1200 ning keskmine stäkk pisut üle 40xBB. See tähendab, et langejaid tuleb pea iga minutiga ning juba ongi konkurentsis alla 100 mängija. 

Teiste seas ei saa me täna enam kaasa elada Laur Siboldile, Leino Pillerile, Kristo Eralal, Roland Luigele, Kaidar Viikmanile ja Tanel Evertile. 

Show algab kell 19:20 Posted Saturday 1st April, 2023 at 19:15(UTC+2) by maheaaatom

Avapeo ametlikku osa lükati pisut edasi ning see peaks esialgse info kohaselt algama kell 19:20. See tähendab ühtlasi ka väikest pausi turniiril. 

Üldislet valitseb Pargis juba igati kena laupäevane pokkerimeeleolu, kõlistatakse klaase ning elatakse üritusse sisse.

Baarileti ääres õnnestus kinni püüda ka Mati Pirn, kes tänasel bounty-turniiril ei osale, kuid saab tõenäoliselt olema väga aktiivne mängija tiitlijahis, mis algab homme. Idividuaalset Eesti meistritiitlit Matil siiani pole, küll on ta võidutsenud korra paaristurniiril koos Maili Tannbaumiga. Mailit tänasel turniiril pole, kuid küllap saame tedagi näha.

Keegi saab Meelisega öö veeta Posted Saturday 1st April, 2023 at 19:12(UTC+2) by maheaaatom

ETPF-i mees Kaidar ja Olympicu mees Meelis jagavad turniiril osalejatele loosikuponge. Täida vaid ära, pane oma nimi kirja ning osaled loosimises. Aga mis auhinnaks on?

Pokkeriproff Kaido Koorits viskab nalja, et "keegi saab Meelisega öö veeta." Tegelikult läheb loosi majutus Hilton Park hotellis ehk igati väärtuslik kingitus, mis aitab pärast turniiri hästi välja puhata.

Helina kukutas Müüri Posted Saturday 1st April, 2023 at 19:05(UTC+2) by maheaaatom

Helina Tamm on olnud esimestel mängutasemetel päris heas hoos ning võtnud elimineerinud juba kolm mängijat. Tema saagiks langeks äsja ka 2013. aasta EMV põhiturniiri tšempion Madis Müür. See võib tunduda võib-olla isegi üllatav, kuid tegemist on Eesti rahalistis kõrget kolmandat kohta hoidva Madise ainsa Eesti meistritiiliga. Madis kavatseb teistelgi EMV 2023 turniiridel osaleda ning tuli täna koha selleks, et "riidid paika saada." Või siis eelkõige ikkagi lihtsalt lõbutsema.

Uudiseid ka kuulsuste rindel. Mairold Millert kaotas ka oma teise elu ning tema elimineerija teenis OlyBeti plasku. Veel on mängus Maarja-Liis ilus umbes 20K stäkiga ning Andi Raig, mõlema väljalööjat ootab salapärane ümbrik.

Väidetavalt pidi ühes ümbrikus olema päris magus auhind. Kas võib see tõepoolest olla näiteks põhiturniiri pilet?

Robert langes ja tümm läks käima Posted Saturday 1st April, 2023 at 18:52(UTC+2) by maheaaatom

DJ Alvar Orula on võtnud puldis oma koha sisse ning muusika on käimas. Kuulsutest langes kohe pärast pausi Robert Rool, kelle pea eest pandi välja OlyBeti chipikohver. 

Auhinnafond on hetkeseisuga üle 10 000 euro ning sisseoste kogunes esialgse info kohaselt 150. 

Teine paus Posted Saturday 1st April, 2023 at 18:22(UTC+2) by maheaaatom

Mängijad saadeti teist korda puhkama ja nüüdseks on ka re-entry periood läbi. Henrik Raave lauas mängitud viimases jaotuses jagati lauale koguni nelik...

Ühtlasi algasid Flip & Go eelvoorud ning mõistagi on kõik mängijad kogunenud juba selle laua ümber.

7-2 toob kaardipaki Posted Saturday 1st April, 2023 at 18:06(UTC+2) by maheaaatom

Andres Puusepp liigub vahel mängijate keskel ringi ning loobib lõbusaid repliike. Enamasti on tal varuks ka mõni tore pakkumine. Näiteks teenib mängija, kes esimesena kõige viletsaima võimaliku pokkerikäega panga maha võtab, Olybeti kaardipaki. Üks pakk on juba välja läinud, teine alles ootab omanikku. 

Viimane level lisaostude tegemiseks Posted Saturday 1st April, 2023 at 17:56(UTC+2) by maheaaatom

Algamas on kaheksas mängutase, mis on ka viimane re-entryde tegemiseks. Uutest mängijatest on turniiriga liitunud Laur Sibold, Heimar Lill jt. 

Henrik Raave käis just all-in pärast floppi Kaasa paraku keegi ei tulnud ning Henrik avas pocket ässad. "No mida ma siis oleks pidanud tegema," pärib ta ühe vastase küsimuse peale, et miks siis ikkagi all-in. 

Igatahes tuli siit korralik chipilisa ning kõik meie kuulsused on endiselt all-in. Paistab, et lauljatele neid ässasid ikka jagub...

Millal flippama hakatakse? Posted Saturday 1st April, 2023 at 17:48(UTC+2) by maheaaatom

Täna on kavas ka 50 € Flip & Go eelvoorud, mis algavad siis kui oleme jõudnud 9 viimase lauani. Hetkel on laudades jätkuvalt 109 mängijat ning re-entry'sid on kogunenud 20 ligi.

Flip & Go on siis selline tore turniir, kus finaali pääsemiseks on vaja ainult õnne ning soovi korral saab iga mängija piiramatu arvu võimalusi. Kõik, kes jõuavad finaali, on juba rahades, kuid seal mängitakse siiski "päris pokkerit".  

Tosin naist Posted Saturday 1st April, 2023 at 17:16(UTC+2) by maheaaatom

Turniiril osaleb tosin naismängijat, kellest üks - Heli Annok - on pidanud tegema ka re-entry. 

Viimastena liitusid turniiriga Pillerid, kelle naispool sai 2022. aasta põhiturniiril hakkama millegi ennaolematuga - suutis mullimängus 1xBB-ga ellu jääda, hiljem finaali jõuda ja seal tubli kolmanda koha saavutada. Ja vabalt oleks võinud ka võita!

Christel plaanib ka nendel "eestikatel" umbes neljal-viiel turniiril osaleda. Kõlab võib-olla imelikult, kuid kummalgi Pilleril siiani veel Eesti meistritiitlit ei ole. 

Algas esimene paus Posted Saturday 1st April, 2023 at 16:44(UTC+2) by maheaaatom

Esimesed neli taset sai mängitud ning mängijad lubati 15 minutiks jalgu sirutama. Re-entry periood kestab ka järgmised neli mängutaset, mille järel enam mänguga liituda ei saa.

Hetkel käib action 11 laual, mängijaid on 109 ja sisseoste 119. See tähendab juba üle 8000-eurost auhinnafondi.

Maarja-Liis duubeldas ässadega Posted Saturday 1st April, 2023 at 16:33(UTC+2) by maheaaatom

Seitsmendas lauas olid all-in Maarja-Liis Ilus ja Hendrik Lepik, viimasel märksa suurem stäkk. Põhjus selles, et Maarja-Liis on täna juba ühe suure käe ässadega kaotanud...

Maarja-Liis: 

Hendrik:

Laud jooksis tühja ning Eesti üks läbi aegade populaarsemaid lauljaid jätkab mängu. Maarja-Liisi enda sõnul on see tema ainus EMV 2023 turniiri, teistel üritustel ta mängida ei jõua.

Esimene kuulsus on väljas Posted Saturday 1st April, 2023 at 16:24(UTC+2) by maheaaatom

Mairold Millert on esimene kuulsus, kes pidi lauast püsti tõusma. Mairoldi väljalööja sai auhinnaks OlyBeti saunalina. Hea uudis on see, et Mairold tuleb uuesti mängu ning tema eest pannakse taas bounty välja.

Täna mängitavatest kuulsustest on Mairold kindlasti kõige tituleeritum. Ta on võitnud kaks Eesti meistritiitlit ning osalenud paljudel turniiridel ka lihtmängijana oma raha eest.

Kristo Erala: Üks tiitel oleks kordaminek Posted Saturday 1st April, 2023 at 16:12(UTC+2) by maheaaatom

Kolm mängijat on juba esimese re-entry "kätte saanud", nende hulgas ka Rakvere au ja uhkus Kristo Erala.  Olevat olnud emandad äss-kuninga vastu pärast 5-high floppi. River äss. 

Kristo plaanib mängida kõiki Holdem-turniire, high-rollerile loodab ta küll saada peale läbi satika. Segamänge Kristo enda sõnul ei oska ning nendes ta tiitleid jahtima ei lähe. 

"Siiani olen igal OPEM-il või EMV-l saanud ühe TOP3 koha läbi aastate. Kui õnnestuks nüüd üks tiitel saada, siis oleksin väga rahul," kommenteerib mees ise. 

"Naxeril" on elu võimalus? Posted Saturday 1st April, 2023 at 15:59(UTC+2) by maheaaatom

Marko "Naxer" Keskel istub samas lauas Robert Rooliga. Kui võiks nagu eeldada, et Robert peaks olema selle laua jutukaim mängija, siis päris nii see (veel) ei ole. "Naxer" on jutuohjad kindlalt enda kätte võtnud.

Tema mänguplaanides on rahvaturniir, tiimiturniir...ja kindlasti ka põhiturniir. "Ma ei tea, kas ma päris neid kõiki heads-up'e ja Omahasid mängin, aga eks näib," vastab Marko. 

"Naxer" on viiekordne Eesti pokkerimeister, temast enam on suutnud vaid Meelis Ahman. Aga Meelis täidab Olympicu pokkerimänedžeri kohuseid ning seetõttu mõistagi mängida ei saa. 

Niisiis "Naxer" - kas võtad seekord kaks tiitlit endale ja lähed Meelisest mööda? "Seda peaks vist Moreli käest küsima, tal on ikka kombeks kaks võitu korraga," naljatleb Marko.  

REM: Ka Marius Morel on viiekordne Eesti meister. 

Eelinfoks tiimimängijatele Posted Saturday 1st April, 2023 at 15:46(UTC+2) by maheaaatom

Esmaspäeva õhtul toimub Hilton Park kasiinos EMV võistkondlik turniir, kus pääseb mängima kuni 20 viieliikmelist tiimi. Hetkel on registreerunud 14 tiimi, seega on veel võimalik kuus võistkonda kokku panna. 

ETPF-i esindaja Kaidar Viikmann lubas erakordselt meeleolukat üritust ning tõelist pokkeripidu, kus möll käib algusest lõpuni. Iga punkt on kulla hinnaga ning mistahes vastase väljakukutamine tõeline rõõm.

Ka sellest turniirist viiakse läbi live-blogi MainEventTravel.com keskkonnas. Osalejate seas on nii mõnigi tuntud pokkerifiguur, keda me oleme harjunud pigem kaadri taga kui lauas nägema. Näiteks blogimeister Mariliis Jõras jt.

Helina Tamm lubab aktiivselt konkurentsi pakkuda Posted Saturday 1st April, 2023 at 15:41(UTC+2) by maheaaatom

Helina Tammest saime esimest korda kuulda 15 aastat tagasi, mil foorumites liikusid kõlakad, et Eestis on "keegi naismängija, kes biidib internetis kõrgeid turniire". Peagi ilmus kangelanna ka välja ning andis ka mõned live-lahingud, võites näiteks 2009. aastal esmakordselt toimunud Eesti Naiste Pokkeriliiga. 

Vahepeal elas Helina välismaal ning oli suurest mängust eemal, kuid nüüd on ta tagasi ning mängib vägagi aktiivselt. Ta tuli 2021. aastal (lõpuks) Eesti naistemeistriks. Helinat sai palju näha ka Kings of Tallinnal, kus ta oli kaugelt Eesti aktiivseim naismängija ning sai muide ka kaks cashi.

Küllap näeme Helinat palju ka EMV 2023 turniiridel. Ka põhiturniiri pilet on tal juba ammu olemas.

Roland Luik plaanib Eestisse naasta Posted Saturday 1st April, 2023 at 15:29(UTC+2) by maheaaatom

2017. aasta Eesti suurim pokkerikomeet Roland Luik pole pärast üliedukat aastat enam nii säravalt esinenud, kuigi neljakohalisi cashe on ta kogunud ka hiljem. Näiteks tuli ta rahadesse mullusel Battle of Maltal.

 Viimastel aastatel on Roland eelkõige Soomes tööd rassinud, kuid plaanib peagi Eestisse tagasi tulla. "No kaua sa nii ikka jõuad, tuleb ikka Eestis ka olla," kommenteerib Roland ise. EMV-l plaanib ta kindlasti osaleda nii rahva- kui põhiturniiril ning võib-olla mõnel üritusel veel. 

Eesti rahalistis on Roland hetkel kõrgel 33. kohal. Just tema oli ka see mees, kes sai 2017. aasta Kings of Tallinn põhiturniiril suurima auhinnaraha ning vandus aasta varem Tallinnas toimunud MPN Poker Tour põhiturniiril alla vaid Ranno Sootlale. Rolandi imeliselt kiire teekond "Mustika Mudaliigast" Eesti pokkeri absoluutsesse tippu pälvis omal ajal kõvasti tähelepanu ning andis tunnistust, et ka vähese mängukogemuse ja julge mänguga on võimalik kaugele jõuda.

Tänased pokkeristaarid Posted Saturday 1st April, 2023 at 15:19(UTC+2) by maheaaatom

Kui mitte-pokkeristaare on laudades seitse, siis suurimatest pokkeriässadest on kohal näiteks: 

• Kristo Erala
• Marko Keskel
• Sven Reimaa
• Madis Ormisson
• Roland Luik
• Helina Tamm
• Andres Samarüütel

Lisaks neile on mõistagi kohal ka Olympic Casinos juba enam kui 3000 (!) turniiri mänginud Aleksandr Klepatš ning päevitanud ETPF-i töölööm Kaidar Viikman, kes saabus just Kagu-Aasia turneelt.

Esimesed kaardid on välja jagatud! Posted Saturday 1st April, 2023 at 15:14(UTC+2) by maheaaatom

Nüüd on kaardid ka lõplikult õhus ning nagu arvata võis - kõik 90 kohta on täitunud mängijatega.

Tänase turniiri mänguformaat on Deepstack Bounty - algstäkk 30000 punkti, tasemed 20 minutit ning esimese 160 minuti jooksul on lubatud piiramatu re-entry. Sisseostust 55 eurot läheb üldisesse auhinnafondi, 20 eurot on bounty. Lisaks ootavad mängijad tasuta Gin-Tonicud ja snäkilaud.

Pilte teeb staarpokkerifotograaf Elena "Lenka" Kask ning tema loomingut saame avalikult näha juba tunni-paari pärast. 

Eesti meistrivõistlused on alanud! Posted Saturday 1st April, 2023 at 15:07(UTC+2) by maheaaatom

Avaturniiri mängijad on istumas laudadesse, alustatakse üheksal laual. Seega kokku pääseb esialgu mängima täpselt 90 pokkerisportlast.

Päris nii palju mängijad veel kohal ei ole, sest hetkel on alustajaid 75. Nende vahel loositi just välja ka kolm 50-eurost piletit. Üsna suure tõenäosusega saavad aga ka kõik tühjad kohad peagi täis. 

Turniiril osaleb lisaks "lihtsurelikele" ka mitmeid kuulsusi, kelle väljavõitjaid ootavad lisaauhinnad:

• Henrik Raave
• Robert Rool
• Andi Raig
• Mairold Millert
• Maarja-Liis Ilus
• Andres Puusepp
• Toomas Tilk a.k.a. "Tommyboy"

Tere tulemast 2023. aasta Eesti meistrivõistlustele! Posted Saturday 1st April, 2023 at 12:12(UTC+2) by maheaaatom

Head pokkerisõbrad! Meid on ootamas kaks nädalat vältavad 2023. aasta turniiripokkeri Eesti meistrivõistlused. Festivali paneb käima laupäeval kell 15:00 algav OlyBet Bounty Kings – Deepstack Bounty turniir, mille sisseost on kõigest 80 eurot. Selle turniiri võitjale küll Eesti meistrisõrmust ei anta, küll on aga võimalik võita palju raha ning nautida suurepärast õhkkonda. 

Turniiril on telelaud, mis algab kell 17:00. Ühtlasi algab laupäeval kell 19:00 festivali avapidu, mida juhib Andres Puusepp. Muusikat mängib DJ Alvar Orula, funki lisab Tom Cats Laura Prits ning saab ka klaase kokku lüüa ja ETPF-i presidendi kõnel kuulata. Seega tasub kohale tulla ka juhul, kui sa ise ei plaani avaturniiril mängida.

Ürituse blogi valmib Olympic Casino ja OlyBeti tellimusel keskkonnas MainEventTravel.com. See leht on juba tuttav paljudele, kes jälgisid tänavust Kings of Tallinn ingliskeelset ülekannet.  Räägime mängijatega, kogume muljeid, vaatame mis Olympic Casinos täna toimub ning hoiame vargsi ka turniiril silma peal.

Kohtumiseni juba laupäeval kell 15:00!

18:11 (UTC+2)

Day 1 of Estonian Poker Championship Started
Level:      Blinds: 0/0     Ante: 0

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

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter