Kings of Tallinn - Kings of Tallinn 2024 - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0056 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-20'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est/1/updates'
ORDER BY `views` DESC

0.0073 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-20'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est/1/updates'

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

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

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

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

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

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

0.0004 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.0003 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.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

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

0.0006 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.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` = 'page'

0.0072 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.0006 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` = '2024_KOT_350_Tallinn_Cup_Est'

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

0.0208 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0040 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '220'
AND `published` = 1

0.0243 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '223'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
AND `name` = '1'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English

Kings of Tallinn 2024 Event #3: €350 Kings of Tallinn Cup (Estonian) Live Reporting - Day 2

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Current Level 28 Current Day 2

Blinds 50,000/100,000 Ante 100000

Entries 313 Remaining 1

Prize Pool (EUR) €92,680 First Prize (EUR) €0

Chip Leaders Day 2

1	Sven Otto Omland		9,396,000
2	Oskar Ojaveer		200,000

Day 1 Day 2

1 New Update - Click to refresh

Live Updates - Day 1

Tänaseks kõik Posted Saturday 24th February, 2024 at 01:59(UTC+2) by maheaaatom

Allesjäänud umbes 120 mängijat pakivad nuppe kottidesse, et homme taas mängulaudadesse naasta. Soovi korral võivad mänguga liituda ka need, kes täna välja langesid ning needki, kes üldse lauda ei istunudki. Hiline registeerimine on avatud kolm esimest taset ehk umbes kuni kell 13:30-13:45.

Homme jätkub mäng 30-minutiliste tasemetega ning tõenäoliselt on võitja keskööks teada. Aga 350 € CUP-i kõrval jälgime kindlasti ka kõiki teisi turniire ning vahendame festivali üldist melu.

Hetkel on Olympic Casinos jätkumas võimas cashgame ning Hiltoni konverentsisaalis käimas veel avaturniir (parimad 12, meie omadest sees Anna Astahhova) ning 555 € Championship turniiri satelliit. Tulemused avaldame juba homme, head ööd!

Viis viimast kätt Posted Saturday 24th February, 2024 at 01:52(UTC+2) by maheaaatom

350 € CUP-il asuti jagama viite viimast jaotust, seega on mäng peagi tänaseks läbi.

Fuajeest ka üks hea uudis - Aleksei Smirnovil on umbes 95K stäkk, mis on peaaegu kahekordne keskmine. Ja oma nuppe Aleksei juba hoida oskab!

Player		Chips	Progress
Aleksei Smirnov		95,000	65,000

Martti on väljas, Annal hea seis Posted Saturday 24th February, 2024 at 01:45(UTC+2) by maheaaatom

Avaturniiri jätkab 14 parimat ning kahjuks pole nende seas ka enam pokkeri-ja volleässa Martti Keelt.

Eesti au jääb kaitsma ainsana Anna Astahhova, kellel on umbes 1,5-kordne keskmine stäkk.

Hendrik jäi imekombel ellu Posted Saturday 24th February, 2024 at 01:41(UTC+2) by maheaaatom

5K peale langenud Hendrik Uibo läks all-in -ga ning sai kaks calli - -lt ja -lt.

Pole just kiita seis...Aga river maitses Hendrikule muidugi väga hästi.

Algas tänane viimane mängutase Posted Saturday 24th February, 2024 at 01:32(UTC+2) by maheaaatom

350 € CUP-il algas tänane viimane mängutase. Viimase paarikümne minuti jooksul pole ühtegi täiendavat sisseostu enam tehtud, väljalangejate mõtted paistavad olevat pigem juba homses.

01:31 (UTC+2)

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

Edgar seab end minekule Posted Saturday 24th February, 2024 at 01:28(UTC+2) by maheaaatom

Edgar Põhjamets sai oma 20BB stäki sisse heas seisus ülimalt lahtiselt mängiva Atte Jukanpoika Puolakka vastu, kuid paraku polnud tal lihtsalt õnne.

Edgar:

Atte:

Riverisse kolm...

Üle keskmise stäkiga Eesti mängijad Posted Saturday 24th February, 2024 at 01:19(UTC+2) by maheaaatom

Player	Chips	Progress
Kert Hallik	95,000	65,000
Peep Kivistik	75,000	45,000
Madis Müür	74,000	44,000
Allan Arjut	70,000	0
Stanislav Smeljov	65,000	35,000
Risto Pärnat	50,000	20,000
Oskar Ojaveer	50,000	20,000

Martti räägib mänguplaanidest Posted Saturday 24th February, 2024 at 01:05(UTC+2) by maheaaatom

Valitsev HU Eesti meister Martti Keel on endale juba taganud avaturniiril vähemalt 600-eurose võidu ning tõdeb, et ega tal tõenäoliselt rohkematel turniiridel osaleda õnnestugi. Seega on eesmärgiks jõuda täna nii kaugele kui võimalik. Nii Martti kui Anna stäkid on igati mängitavad, kuid võiduni on veel väga pikk tee. 16 parimat alles.

01:02 (UTC+2)

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

Hannole avaturniiril bad beat Posted Saturday 24th February, 2024 at 00:54(UTC+2) by maheaaatom

Kolmekordne Eesti meister Hanno Kerem on kahjuks avaturniirilt väljas, seda veel üsna korraliku bad beadiga.

PFAI, Hannol , vastas ning kuus turni. Avaturniiri jätkab 17 parimat, Eesti au kaitsevad vaid Martti Keel ning Anna Astahhova.

Kaidar arutab, mida 600 euroga teha Posted Saturday 24th February, 2024 at 00:45(UTC+2) by maheaaatom

Valitsev Eesti pokkerimeister Kaidar Viikman langes avaturniirilt 20-ndana välja, saades lohutuseks 600 eurot auhinnaraha. "Noh nüüd on vähemalt millega järgmisi turniire mängida," sõnab mees, kes on korduvalt rõhutanud, et on lihtne, keskmist palka teeniv pokkerifänn ning niisama kuskil lahmimas ei käi.

Kaidar homme mängima ei tule - plaanis on teised asjad - küll on aga kindlasti kohal pühapäeval, mil toimub tema lemmikmäng 8-Game. Aga eks on mehe mängukavas mõni teinegi turniir.

Uudiseid avaturniirilt Posted Saturday 24th February, 2024 at 00:37(UTC+2) by maheaaatom

Hetkeseisuga on alles 21 parimat, eestlastest on langenud Erik Põlluveer, Mauro-Mark Musting ning paraku ka Kairit Leibold. Tema -st ei olnud paraku vastu kasu.

Allan annab natuke ära Posted Saturday 24th February, 2024 at 00:35(UTC+2) by maheaaatom

Allani lauas vaatavad neli mängijat - kaks soomlast, Allan ja Artur 1200-ga floppi

Algselt tõstnud noor agressiivne soomlane jätkab 2K-ga, Artur muckib ja teine soomlane koos Allaniga callivad.

Turn on , algne panustaja paneb nüüd juba 12K ning Allan callib ainsana.

Riverisse avatakse "plankude plank" ehk .

Nüüd tuleb soomlaselt juba 25K panus ning -ga mänginud Allanil pole enam kuskile pääsu. Soomlane avab flopanud masti ning korjab panga maha.

00:29 (UTC+2)

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

Avaturniiril on mängus veel 8 eestlast Posted Saturday 24th February, 2024 at 00:17(UTC+2) by maheaaatom

Avaturniiril jätkava 28 mängija seas on 8 eestlast, kellest Erik Põlluveer hängib küll juba mõnda aega sees õige pisikese punktisummaga. Aga kuniks alles on veel kasvõi üks nööp, pole ju midagi läbi.

29. koht läks Georgi Abuladzele, tema on siiani ka ainus rahadesse jõudnud, kuid mängu enam mitte jätkav eestlane.

350 € CUP läks tänasele viimasele pausile, mängida on veel 3x30 minutit. Ehk siis umbes kella kaheni öösel.

Tähelepanuks homsetele tulijatele Posted Saturday 24th February, 2024 at 00:05(UTC+2) by maheaaatom

Laupäeval ootab meid ees juba märksa rohkem turniire kui täna ning neli tähtsaimat neist, millele tasuks erilist tähelepanu pöörata, on järgmised:

Kell 12:00 jätkub 350 € CUP (re-entry on lubatud kuni 13:45-ni)
Kell 15:00 algab 150 € OFC Pineapple (Hiina pokker)
Kell 17:00 algab PLO 4/5 Cards (555 €)
Hobimängijatel tasub tulla kohale kell 19:00 algavale Iseseisvuspäeva eriturniirile, mille sisseost vägagi tasukohane 150 eurot.

188 sisseostu Posted Friday 23rd February, 2024 at 23:59(UTC+2) by maheaaatom

CUP-i auhinnafond paisub hoogsalt, juba on sisseoste 188 ning laudades 150 mängijat. Kuigi keskmine stäkk on umbes 60XBB, lükkavad nii mõnedki mängijad väga hoogsalt nuppe.

Avaturniiril on alles 33 parimat ning ei paista, et eestlastel oleks just hirmsuuri stäkke. Samas on seal ka mäng väga kiire (keskmine 20XBB) ning turniiri otsustav faas alles ees.

23:57 (UTC+2)

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

Avaturniiril rahasaajad selged Posted Friday 23rd February, 2024 at 23:48(UTC+2) by maheaaatom

Avaturniiril lõhkes just mull ning floor õnnitles allesjäänud mängijaid rahadesse jõudmise puhul.

Kahjuks olid nii mullimees kui pre-mull Eesti mehed: vastavalt Vjatšeslav Jakušin ning Marek Selgeveer.

Elevust on ka 350 € CUP-il, nimelt õnnestub Aleksandr Hlabovil -ga mastirida saada.

Käimas ka 555 € Championship turniiri satelliit Posted Friday 23rd February, 2024 at 23:41(UTC+2) by maheaaatom

Umbes pool tundi tagasi algas 80-eurone satelliit 555 € Championship turniirile.

Osalejaid on hetkel küll veel vähevõitu, umbes tosina jagu. Aga aega liitumiseks on vähemalt kell 01:00-ni öösel.

555 € Championship algab pühapäeval ning see on üks Kings of Tallinna tähtsamaid turniire. Võitja selgub telelauas 28. veebruaril. Mullu oli turniiri auhinnafond võimas 277 098 eurot ning parima eestlasena oli Tarmo Tammel mäletatavasti kolmas. Tarmost, kes mängib hetkel Pariisi EPT-l, saate pikemalt lugeda selles Postimehe artiklis.

P.S. Kings of Tallinn teleülekanded algavadki just nimelt 555 € Championship turniiri finaaliga.

23:27 (UTC+2)

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

Avaturniiril tempo maas Posted Friday 23rd February, 2024 at 23:25(UTC+2) by maheaaatom

Avaturniiril on käimas pre-mull mäng ning turniiri tempo on sellega üsna maas.

Eestlasi on mängus 11, nende seas ka kaks naist - lisaks Kairit Leiboldile ka suurfestivalidel üsna aktiivseks mängijaks muutunud Anna Astahhova.

Tuntud tegijatest jahibd tiitlit Georgi Abuladze, Kaidar Viikman, Erik Põlluveer ning ka volleäss Martti Keel.

Allanil 100K Posted Friday 23rd February, 2024 at 23:16(UTC+2) by maheaaatom

Allan Arjut särab, sest on kolme käega päris rikkaks saanud.

1. Artur Külanurk avab 800, Allan kolmpanustab 2,5K -ga. SB peal istub üks pidune soomlane, kes küsib Arturi stäkki ja flatib. Arturilt fold.

Flop , soomlane checkib ette ja snapcallib Allani 3K panust.

Turn on , soomlane taas checkib ja snapcallib Allani 6K panust.

Riverisse avatakse veel üks ning soomlane kiire all-in, Allanilt sama kiire call. Soomlasel "lumememmed" ehk siis pocket kaheksad.

2. Pisut hiljem floppab Allan neljadega kolmiku ning saab ühe rootslase käest kõik kolm tänavat maksu, sellega lisa veel umbes 20K.

3. Lauda tuleb uus mängija, kelle Allan kiirelt elimineerib ( vs. ). Allanil nüüd umbes 100K, mis on umbes 3X keskmine.

Veel põnevaid uusi mängijaid Posted Friday 23rd February, 2024 at 22:56(UTC+2) by maheaaatom

Turniiriga on liitunud ka Mark Metsla, Ranno Sootla, Edgar Põhjamets, Oskar Ojaveer ja Janek Hin.

Nii mõnigi neist on CUP-il põhjusel, et nende jaoks sai 250 € avaturniir just läbi. Viimasel ollakse rahadele juba päris lähedal (alles 47, marjamaale pääseb teatavasti 39).

Inflatsooni mõju Posted Friday 23rd February, 2024 at 22:53(UTC+2) by maheaaatom

Pausi ajal arutasid Hendri Uibo ja Silver Simulask esimese kolme mängutaseme sündmusi ning mõlemad mehed nentisid, et inflatsioon avaldab ikka kõvasti mõju. Leiduvat mängijaid, kes absoluutselt iga suvalise kaardiga nuppe lükkavad ning rahast sugugi ei hooli.

"See on seepärast, et raha prinditakse aina juurde. Printerid huugavad ja huugavad," arvab samal turniiril osalev Madis Tarum. "Seepärast ma Bitcoinis istungi," lisab Madis, kes on tavaelus muide tunnustatud crypto-koolitaja :)

22:49 (UTC+2)

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

Esimene paus Posted Friday 23rd February, 2024 at 22:32(UTC+2) by maheaaatom

Turniir läks esimesele pausile, mis kestab 15 minutit. Täna on kavas kaks pausi, järgmine neist algab pärast kuuendat mängutaset ehk umbes kell 00:15.

Hetkel tehtud 148 sisseostu, laudades 132 mängijat.

Kuidas lõppes eilne warm-up turniir? Posted Friday 23rd February, 2024 at 22:22(UTC+2) by maheaaatom

Neljapäeval toimunud Kings of Tallinn Warm-Up turniir ei mahu küll otseselt suurfestivali kavasse, kuid olgu tulemused siiski märgitud.

Sisseoste (a 250 €) kogunes 47 ning kaksikvõit läks Soome. Ülejäänud auhinnasaajad olid aga eranditult eestlased - Kert Hallik teenis 1 640, Antti Suursalu 1180, Hendrik Uibo 790 ja Ott Krigul 660 eurot. Abiks ikka.

Otsid riideid ja varustust? Posted Friday 23rd February, 2024 at 22:15(UTC+2) by maheaaatom

Alumisel korrusel (Hiltoni fuajees) saab tavapäraselt osta ka Kings of Tallinn nänni ja riideid. Et hinnad on odavad ja tootevalik lai, siis soovitame sealtki läbi astuda.

350 € CUP kogub hoogu Posted Friday 23rd February, 2024 at 22:12(UTC+2) by maheaaatom

Oleme jõudnud juba 132 sisseostuni ning action toimub nii suures saalis kui ka fuajees. Nagu arvata oligi - Madis Müür on lauas istet võtnud ning mängust osa saamas.

Mängus on ka viiekordne Eesti meister Kert Hallik, nimekad pokkeriprofid Aleksei Smirnov, Martin Piik ja Oskar Ojaveer ning koguni mullusuvisel Summer Showdownil meeleolukat mängu näidanud ja põhiturniiril teiseks tulnud Phil Gross Saksamaalt.

Selgus avaturniiri auhindade jagunemine Posted Friday 23rd February, 2024 at 22:08(UTC+2) by maheaaatom

250 € avaturniirile tehti niisiis kokku 305 sisseostu ning mängijate vahel läheb jagamisele 63 074 eurot auhinnaraha.

See jaguneb 39 parima vahel, min-cash on 480 eurot, võitja teenib 12 174 eurot. Alustuseks päris kena noos!

Hetkel on alles 62 mängijat, nende seas ka näiteks nimekas Eesti naismängija Kairit Leibold.

22:06 (UTC+2)

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

Cashile! Posted Friday 23rd February, 2024 at 21:58(UTC+2) by maheaaatom

Neile, kes ei köida niivõrd turniirid kui cashgame, anname teada, et alumine korrus (Olympic Park Casino) on uljaid cashimängijaid täis ning 87 378-eurone Jackpot, mis on tiksunud juba julgelt üle aasta, ootab mahavõtmist.

Kui juhtub ime ja seda tõesti ka Kings of Tallinna ajal maha ei võeta, siis märtsist võib Jackpot tõusta juba üle saja tuhande. Ja ärge unustage, et kätte võib selle saada õige pisikeste blindidega mängides!

Kalle üle pika aja taas pokkerilauas Posted Friday 23rd February, 2024 at 21:49(UTC+2) by maheaaatom

Eestlastest osalejate seas on 2017. aasta EMV põhiturniiri teine mees (see oli siis aasta, mil Rakvere pokkerimängijad kaksikvõidu said, esikoha teenis mõistagi Kristo Erala ise) Kalle Pops.

"Ma pole tõesti kaua mänginud, juba aastaid. Aga Paul (Koppe) kutsus ja mõtlesin, et miks mitte. Paar päeva mängin," räägib Kalle ise. Loodame, et hakkab meeldima.

Kiibitsejate seas on ka hirmkuulus pokkeriäss Madis Müür, kes olla 250 € avaturniiril kaks bulletit õhku lasknud. Kas ta 350 € CUP-iga liitub, pole veel kindel, aga julgeks pakkuda, et tõenäosus on ikka üle 50%.

Reporter pokkerilauas Posted Friday 23rd February, 2024 at 21:37(UTC+2) by maheaaatom

Infoks, et 350 € CUP-ist valmib blogi ainult eesti keeles, kuid järgmistele suurematele turniiridele saavad elada kaasa ka tuhanded inglise- ja soome keelt valdavad pokkerisõbrad.

Meile kõigile hästi tuntud blogitiimi juht Jason on aga juba kenasti Olympic Casinos ning hetkel testimas oma oskusi mängijana 250 € avaturniiril. Tavatsetakse öelda, et isegi kui reporteritel pole piisavalt mängukogemust, siis vähemalt riide on kõvasti. Nüüd on aeg näidata oma oskust neid kasutada!

21:34 (UTC+2)

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

Tiimide võistlus! Posted Friday 23rd February, 2024 at 21:30(UTC+2) by maheaaatom

Julgustame kõiki osalejaid registeerima ka oma pokkeritiimi, mida saab teha siin.

Parimate tiimide vahel läheb jagamisele 2% kogu festivali auhinnafondist ning tiimikal osalemine on ilma igasuguse täiendava tasuta. Oma tiimi kirjapanekuks on aega kuni 1. märtsini kell 14:15.

Eestlased on pannud kokku vähemalt kaks tõelist supertiimi:

SOLID PUNTAMENTALS:

Oskar Ojaveer
Ranno Sootla
Markku Koplimaa
Tõnis Viik

TIME

Tarmo Tammel
Hendrik Uibo
Marius Morel
Allan Arjut

Kes on kohal? Posted Friday 23rd February, 2024 at 21:25(UTC+2) by maheaaatom

Eestlastest on juba laudades sügisesel WSOP Cirvuit põhiturniiril kolmandaks tulnud Artur Külanurk, põnev action-mängija Paul Koppe, kõikjale jõudev noor ja perspektiivikas pokkeriproff Hendrik Uibo, kogenud veteranmängija Silver Simulask, eestlastele hästi tuntud Kristjan Maasalu, Virgo Laansoo, Stanislav Smeljov, Dmitri Dudakov, Allan Arjut ja teised.

Teistest turniiridest Posted Friday 23rd February, 2024 at 21:11(UTC+2) by maheaaatom

Niisamuti on suures saalis käimas 250 € Opening Event, mis on osutunud väga populaarseks, sest sisseoste kogunes tervelt 305.

Hetkel on alles 115 parimat ning me lubame, et hoiame ka sel üritusel silma peal, eriti kui on midagi huvitavat rääkida eestlaste käekäigust. Avaturniirile toimus muide täna ka reigivaba satelliit, kuhu kogunes 187 sisseostu.

Hilistele ärkajatele on täna tulemas ka 555 € Championship satelliit, kuhu pääseb mängima 80 euroga. See turniir algab kell 23:00.

350 € CUP on alanud! Posted Friday 23rd February, 2024 at 21:07(UTC+2) by maheaaatom

Kahepäevane turniir on Hiltoni suures saalis alanud, esialgu on laudades 68 mängijat.

Täna mängime 9 taset, igaüks 30 minutit. Lubatud on piiramatu re-entry ning kes täna mängima ei jõua, võib seda teha ka homme, sest ka teise päeva esimese kolme taseme jooksul on lubatud hiline registreerumine.

21:05 (UTC+2)

Day 1 of Kings of Tallinn 2024 Started
Level: 1 Blinds: 100/100 Ante: 100

Tere tulemast Kings of Tallinnale! Posted Thursday 22nd February, 2024 at 13:55(UTC+2) by maheaaatom

Reedel, 23. veebruaril algab Olympic Park Casinos regiooni suurim pokkerifestival Kings of Tallinn 2024, mille kavas on 55 turniiri. Läbi OlyBet TV saate lugeda koguni kuue tähtsaima turniiri eestikeelset blogi ning oma lemmikutele kaasa elada. Nendeks:

- 23.02 ja 24.02: Kings of Tallinn Cup 350 € (kaks päeva)

- 25.02 kuni 27.02: Kings of Tallinn Championship 555 € (kolm päeva)

- 27.02: Celebrity Special 150 € (üks päev)

- 28.02 kuni 03.03: Kings of Tallinn põhiturniir (viis päeva)

- 1.03 ja 02.03: Highroller 5000 € (kaks päeva)

- 2.03 ja 03.03: Highroller 3000 € (kaks päeva)

Me alustame ülekannet Olympic Park Casinos ning Hiltoni konverentsisaalist reedel kell 21:00. Seadke vaim valmis ning peatse kohtumiseni!

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

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.

Browse

Useful Links

Subscribe to our newsletter