0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Fin/1B/updates', 1, '2024-05-20')

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.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0003 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.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.0005 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.0003 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.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.0062 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_1100_Main_Event_Fin'

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

0.0219 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '243'
AND `published` = 1

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` = '246'
AND `published` = 1

0.0209 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0044 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '248'
AND `published` = 1

0.0214 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0043 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '253'
AND `published` = 1

0.0209 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0038 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '259'
AND `published` = 1

0.0310 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0044 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '265'
AND `published` = 1

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

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

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

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` = '10910'
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` = '10889'
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` = '10888'
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` = '10883'
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` = '10880'
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` = '10876'
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` = '10868'
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` = '10862'
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` = '10856'
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` = '10855'
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` = '10852'
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` = '10845'
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` = '10842'
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` = '10841'
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` = '10836'
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` = '10834'
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` = '10824'
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` = '10820'
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` = '10817'
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` = '10813'
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` = '10811'
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` = '10805'
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` = '10804'
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` = '10802'
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` = '10797'
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` = '10794'
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` = '10791'
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` = '10785'
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` = '10782'
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` = '10775'
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` = '10773'
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` = '10769'
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` = '10766'
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` = '10759'
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` = '10752'
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` = '10751'
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` = '10749'
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` = '10746'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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` = '10910'
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` = '10889'
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` = '10888'
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` = '10883'
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` = '10880'
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` = '10876'
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` = '10868'
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` = '10862'
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` = '10856'
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` = '10855'
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` = '10852'
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` = '10845'
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` = '10842'
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` = '10841'
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` = '10836'
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` = '10834'
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` = '10824'
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` = '10820'
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` = '10817'
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` = '10813'
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` = '10811'
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` = '10805'
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` = '10804'
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` = '10802'
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` = '10797'
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` = '10794'
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` = '10791'
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` = '10785'
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` = '10782'
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` = '10775'
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` = '10773'
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` = '10769'
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` = '10766'
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` = '10759'
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` = '10752'
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` = '10751'
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` = '10749'
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` = '10746'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

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(3)
  • APAT(7)
  • APPT(2)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(8)
  • Battle Of Malta(1)
  • Borgata Poker(0)
  • Bratislava Poker Festival(1)
  • British Poker Series(7)
  • BSOP(4)
  • Caesars Palace(1)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(10)
  • EAPT(1)
  • EPT(3)
  • Estrellas Poker Tour(2)
  • Eureka Poker Tour(3)
  • France Poker Series(2)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(1)
  • Grosvenor Casino Coventry(4)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(30)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's Summer Fest(1)
  • GUKPT Grosvenor(5)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(0)
  • Irish Poker Tour(9)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(1)
  • Mid States Poker Tour(8)
  • North American Poker Tour(1)
  • OlyBet Showdown Vilnius (1)
  • Olympic Park Casino(0)
  • Orleans Summer Open(1)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(0)
  • Resorts World Las Vegas(1)
  • Sky Poker Tour(2)
  • The Casino at Portomaso(3)
  • The Festival(3)
  • The Poker Room(1)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(3)
  • Unibet DeepStack Open(7)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(1)
  • WPT(6)
  • WPT Alpha 8(3)
  • WPT Prime(5)
  • WPT Special Events(1)
  • WSOP(1)
  • WSOP Circuit Events(2)
  • WSOP International Circuit(1)
  • 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
  • Flight FAQs
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll
  • Luxon Pay IPT 5% Travel Credit T&Cs

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

Kings of Tallinn 2024 Event #29: €1,100 Main Event (Finnish) Live Reporting - Day 4

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 34 Current Day 4

---

Blinds 150,000/300,000 Ante 300000

Entries 853 Remaining 1

---

Prize Pool (EUR) €859,270 First Prize (EUR) €120,910

Chip Leaders Day 4

Day 1A Day 1B Day 1C Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 1B

Suomalaisten pinot erästä 1B Posted Thursday 29th February, 2024 at 22:46(UTC+2) by Juhani Tyriseva

Suomalaiset: 

Henri Wagner 193K
Jani Tuovinen 173K 
Roope Tarmi 156K 
Kaisa Suorsa 121K 
Sauli Haapaniemi 117K 
Jani Vilmunen 107K
Aleksi Naski 103K 
Antti Perttula 102K
Simo Räikkönen 102K 
Mikael Haapaniemi 100K 
Mikko Ylämäki 93K
Santtu Leinonen 92K 
Kyösti Isberg 86K
Juuso Wiksten 83K
Arto Lehtonen 81K
Kalle Parkkinen 79K
Ville Jantunen 76K
Miro Lehtinen 76K 
Jan-Mikael Kesänen 74K
Petteri Laiho 72K
Jussi Vanhanen 62K
JP Juhola 61K
Jyrki Lampinen 58K
Jari Mähönen 55K 
Jimi Koponen 54K 
Jari Hurri 52K
Aki Pyysing 51K
Hengtao Zhu 51K
Erkka Lepola 44K
Kristian Kostiander 41K 
Tommi Lankinen 40K 
Henri Ojala 34K 
Silja Kinnunen 32K 
Seppo Parkkinen 32K 
Jonatan Fors 28K
Mikko Aro 27K
Ari Varonen 26K 
John Lundqvist 26K 
Juho Suutari 24K 
Pekka Ikonen 23K 

Erässä 1B tehtiin 385 sisäänostoa, jatkopaikan sai 167 pelaajaa. 

Muistakaa rannekkeet Posted Thursday 29th February, 2024 at 20:58(UTC+2) by Juhani Tyriseva

Tässä on myös hyvä hetki muistuttaa tärkeästä asiasta: 

Huomenna kasinon respassa on todella pitkä jono ennen turnauksen alkua. Jos asut tässä hotellissa, hae ranneke aamiaisreissulla. Jos asut muualla, ole silti kasinolla jo klo 11.30. Sateessa ei ole mukava seisoa, jono on todennäköisesti pisimmillään luokkaa 100 henkeä!!

Päivä 1B on päättynyt, merkit pussiin Posted Thursday 29th February, 2024 at 20:50(UTC+2) by Juhani Tyriseva

Päivä 1B on saatu päätökseen. Merkit alkavat olla pussissa, joten melko pian päästään aloittamaan päivää 1C. 

Alustavien numeroiden mukaan erässä 1B tehtiin 385 sisäänostoa, ja jatkopaikan pelasi 167 pelaajaa. 

Toimitus kaivaa meikäläisten chip countit järjestäjien listoista, eiköhän ne tunnin sisällä saada näkyviin (jos en kämmäile). 

Juho törmäsi suoraan Posted Thursday 29th February, 2024 at 20:29(UTC+2) by Juhani Tyriseva

Riverissä pöydässä oli: 

 

Marius Morel meni all in 24K, hieman yli potillisen. Juho Suutari miettimään, maksu.

Marius näytti suoran. 

Juho näytti rattaat, joten Marius tuplasi, hänellä nyt noin 70K. 

Lyhyttukkaisten tiukka matsi päättyi Akin voittoon Posted Thursday 29th February, 2024 at 20:20(UTC+2) by Juhani Tyriseva

Jani Vilmunen reissasi 3K total pienestä, Aki Pyysing maksoi isosta. 

Floppi Aki löi 4K, maksu.

Turn Aki löi 7K, maksu. 

River sököteltiin. 

Jani näytti kuutoset ja neloset. 

Aki näytti kuutoset ja viitoset, ja vei potin. 

Juusolle mukavaa nousua Posted Thursday 29th February, 2024 at 19:53(UTC+2) by Juhani Tyriseva

Riverissä pöydässä oli: 

 

Adrians Imsa löi 5500, Juuso Wiksten meni all in 16000, Jyrki Lampinen miettimään, kippi. Adrians mietti hetken ja maksoi. 

Juuso näytti värin. 

Adrians näytti pienemmän värin. 

"Kymppi oli, mutta ei täyskättä",  huokaili Jyrki. 

Juuson pinossa nyt noin 50K. 

Suomalaiset tason 7 lopulla Posted Thursday 29th February, 2024 at 19:28(UTC+2) by Juhani Tyriseva

Suomalaiset: 

Silja Kinnunen 18K
John Lundqvist 26K 
Jani Tuovinen 140K 
Jari Mähönen 55K 
Henri Ojala 30K
Simo Räikkönen 105K
Kyösti Isberg 85K
Sauli Haapaniemi 130K
Henri Wagner 175K 
Miro Lehtinen 65K
Arto Lehtonen 60K 
Tomi Arponen 100K 
Jari Hurri 35K 
Juuso Wiksten 13K 
Jyrki Lampinen 48K 
Antti Perttula 70K 
JP Juhola 85K
Seppo Parkkinen 28K 
Petteri Laiho 60K 
Aki Pyysing 68K 
Jonatan Fors 35K 
Jani Vilmunen 75K 
Pekka Ikonen 68K
Jussi Vanhanen 30K 
Kristian Kostiander 46K 
Roope Tarmi 45K 
Jan-Mikael Kesänen 60K 
Juuso Kauppi 12K 
Jimi Koponen 55K
Kasper Mellanen 23K 
Mikko Ylämäki 100K
Veli-Pekka Penttinen 20K 
Kaisa Suorsa 75K 
Terno Palmroos 37K 
Santtu Leinonen 33K
Anne Bezdek 16K 
Ilari Sahamies 33K 
Ari Varonen 55K 
Mikael Haapaniemi 75K 
Ville Jantunen 58K 
Tommi Lankinen 48K
Teemu Kailasvuo 35K 
Luka Sorainen 37K
Aleksi Naski 75K 

 

Unlucky Sevens Posted Thursday 29th February, 2024 at 19:03(UTC+2) by Juhani Tyriseva

Risto Pönniö ja Mairo Tori menivät all in ennen floppia. 

Risto

Mairo

Floppi  

Turn

River ja Mairon suora oli voitokas. Risto poistui kassan suuntaan, katsotaan tekeekö hän vielä comebackin. 

18:42 (UTC+2)

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

Pidetäänpä vielä yksi tauko Posted Thursday 29th February, 2024 at 18:42(UTC+2) by Juhani Tyriseva

Erässä 1B on nyt saatu kuusi tasoa pelattua, kaksi jäljellä. Tauon jälkeen huiskaistaan nuokin, ja sitten merkit pussiin. 

Näillä näkymin pussittamaan päästään noin 20.45, joten erä 1C saataneen käyntiin melko tarkkaan klo 21.00. 

Matte hakemaan uutta vauhtia Posted Thursday 29th February, 2024 at 18:27(UTC+2) by Juhani Tyriseva

Matte Karjalainen ja Ranel Käsi menivät all in ennen floppia.

Matte

Ranel

Floppi

Turn

River ja Matten merkit siirtyivät Ranelin pinoon. Matte puolestaan lähti pohtimaan, tehdäkö re-entry vai ostaa sisään erään 1C. 

Rattaat voittavat yhden parin Posted Thursday 29th February, 2024 at 17:53(UTC+2) by Juhani Tyriseva

Sergejs Kacapovs avasi, Teemu Kailasvuo puolusti isoa.

Floppi [6c3d2d) Sergejs löi 2600, maksu.

Turn sököteltiin.

River Sergejs löi 3200, maksu.

Sergejs näytti kärkiparin.

Teemu käänsi näkyviin rattaat ja vei potin. 

Toimitukselle menestystä sivuvedossa Posted Thursday 29th February, 2024 at 17:45(UTC+2) by Juhani Tyriseva

Jo perinteeksi muodostuneet allekirjoittaneen ja Jason Glatzerin väliset sivuvedot saatiin vasta tänään vauhtiin. Kohteena oli erän 1B sisäänostojen määrä: 

Jason 309

Juhani 352

Kun arvaukset oli saatu paperille, Jason totesi: "Toivon että voitat tämän vedon". 

Nyt taululla on jo 359 sisäänostoa.  Tappion kärsinyt osapuoli käy seuraavalla tauolla hakemassa baarista oluen kaikille kisaan osallistuneille. 

Petterin naulat eivät pärjänneet Posted Thursday 29th February, 2024 at 17:41(UTC+2) by Juhani Tyriseva

Reissatussa potissa floppi oli: 

Morten Norland löi 4200, Petteri Laiho reissasi 12K total, Norland all in 25K, maksu.

Petteri

Morten

Turn

River   ja Norland tuplasi värillään. 

Petterille jäi noin 80K. 

17:32 (UTC+2)

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

Suomalaispinot tason 5 puolivälissä Posted Thursday 29th February, 2024 at 17:24(UTC+2) by Juhani Tyriseva

Silja Kinnunen 31K
John Lundqvist 10K 
Jani Tuovinen 95K 
Jari Mähönen 16K 
Henri Ojala 22K
Simo Räikkönen 65K
Kyösti Isberg 100K
Sauli Haapaniemi 58K
Henri Wagner 80K 
Miro Lehtinen 70K
Arto Lehtonen 40K 
Tomi Arponen 125K 
Jari Hurri 51K 
Juuso Wiksten 20K 
Jyrki Lampinen 30K 
Antti Perttula 23K 
JP Juhola 80K
Roope Holma 25K 
Seppo Parkkinen 20K 
Petteri Laiho 85K 
Aki Pyysing 36K 
Jonatan Fors 18K 
Jani Vilmunen 25K 
Pekka Ikonen 65K
Jussi Vanhanen 58K 
Konsta Heikkilä 13K 
Kristian Kostiander 31K 
Roope Tarmi 75K 
Matte Karjalainen 22K
Jan-Mikael Kesänen 44K 
Juuso Kauppi 68K 
Jimi Koponen 20K
Kasper Mellanen 22K 
Mikko Ylämäki 82K
Torsti Kettula 22K 
Veli-Pekka Penttinen 35K 
Kaisa Suorsa 90K 
Terno Palmroos 37K 
Anne Bezdek 25K 
Juha Kaitanen 33K 
Ilari Sahamies 35K 
Henri Tanskanen 28K
Ari Varonen 45K 
Mikael Haapaniemi 10K 
Ville Jantunen 25K 

Noin 10 meikäläistä on tällä hetkellä pudonnutkin. Osa heistä tietysti tulee takaisin tähän erään, osa palaa erään 1C.  Ja muutamille yksi yritys saattaa tällä kertaa riittää. 

Suomalaisilmeitä päivän alussa Posted Thursday 29th February, 2024 at 16:50(UTC+2) by Juhani Tyriseva

Elias Jalovaara. 

Henri Wagner. 

Pekka Virtanen.

Anna-Mari Hursti. 

Antti Perttula. 

16:35 (UTC+2)

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

Aleksin kympit olivat lujat Posted Thursday 29th February, 2024 at 16:34(UTC+2) by Juhani Tyriseva

Aleksi Naski ja Sander Lithun menivät all in ennen floppia.

Aleksi

Sander

Floppi  

Turn

River ja Aleksin kympit tuottivat hänelle tuplat, hänellä nyt noin 26K. 

Juholan poliisivoimat tehokkaina Posted Thursday 29th February, 2024 at 15:56(UTC+2) by Juhani Tyriseva

Riverissä pöydässä oli: 

 

JP Juhola löi 6000, isäntämaan Martjan Romet reissasi 12500 total buttonista, JP miettimään, maksu. 

Romet näytti rouvahain. 

JP käänsi näkyviin kolmoset, ja vei mukavan potin. 

John törmäsi tiilimuuriin Posted Thursday 29th February, 2024 at 15:46(UTC+2) by Juhani Tyriseva

John Lundqvist ja Yana Gorskaya reissatussa potissa, floppi oli: 

John löi 1500, maksu. 

Turn John löi 3500, maksu. 

River John löi 6400, Yana mietti hetken ja meni all in. John miettimään, kippi. 

"Näytä neloset", kannusti yksi pelaajista. Hieman vastahakoisesti Yana näytti saletit. 

Suomalaiset tason 4 alussa Posted Thursday 29th February, 2024 at 15:24(UTC+2) by Juhani Tyriseva

Suomalaiset: 

Elias Jalovaara 12K 
Silja Kinnunen 16K
John Lundqvist 33K 
Mikko Saarremaa 29K 
Noel Suomalainen 20K
Verneri Häkkinen 33K 
Anna-Mari Hursti 32K 
Jani Tuovinen 53K 
Jari Mähönen 28K 
Henri Ojala 24K
Simo Räikkönen 44K
Kyösti Isberg 35K
Sauli Haapaniemi 20K
Henri Wagner 105K 
Arto Lehtonen 68K 
Tomi Arponen 60K 
Jari Hurri 26K 
Juuso Wiksten 35K 
Jyrki Lampinen 27K 
Antti Perttula 32K 
JP Juhola 42K
Roope Holma 25K 
Seppo Parkkinen 20K 
Petteri Laiho 36K 
Aki Pyysing 44K 
Niklas Vakkuri 27K 
Jonatan Fors 23K 
Jani Vilmunen 24K 
Jussi Vanhanen 55K 
Konsta Heikkilä 25K 
Kristian Kostiander 35K 
Roope Tarmi 35K 
Mika Surakka 22K 
Matte Karjalainen 37K
Jan-Mikael Kesänen 36K 
Markus Ylänne 30K
Juuso Kauppi 26K 
Jimi Koponen 18K
Kasper Mellanen 36K 
Mikko Ylämäki 38K
Torsti Kettula 27K 
Veli-Pekka Penttinen 38K 

15:23 (UTC+2)

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

Seppo tarkisti turhaan Posted Thursday 29th February, 2024 at 14:49(UTC+2) by Juhani Tyriseva

Riverissä pöydässä oli: 

Mihkel Vitsur löi 4K, Seppo Parkkinen miettimään, maksu. 

Mihkel näytti ja Seppo kippasi. 

"Toivoin, että siellä olisi AK tai AQ", pohti Seppo. 

Henri vei Hannan merkit Posted Thursday 29th February, 2024 at 14:41(UTC+2) by Juhani Tyriseva

Henri Wagner avasi, Hanna Heinlo reissasi takaa, maksu. 

Floppi Hanna löi jatkolyönnin, maksu.

Turn Hanna löi, Henri checkreissasi, Hanna all in, maksu. 

Hanna

Henri

River ja Henrin nelossetti lähetti Hannan miettimään re-entryä. 

Aki haki uusia ammuksia Posted Thursday 29th February, 2024 at 14:30(UTC+2) by Juhani Tyriseva

Aki Pyysingin päivä alkoi vähän nihkeästi. "Ensin en osannut kipata kättäni riverissä, vaikka oli pitänyt. Vihu löi pelokkaan näköisenä boardiin ja sieltä sitten tuli kurkattua. 

Tuon jälkeen löysin kädelläni vastaan josta ei ohi menty, joten ei muuta kuin kättä taskuun ja iloista ilmettä", virnisteli Aki. 

14:17 (UTC+2)

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

Suomalaisten chip countit tason 2 lopulla Posted Thursday 29th February, 2024 at 13:56(UTC+2) by Juhani Tyriseva

Suomalaiset tason 2 lopussa: 

Elias Jalovaara 20K 
Silja Kinnunen 20K
John Lundqvist 32K 
Mikko Saarremaa 26K 
Noel Suomalainen 9K
Verneri Häkkinen 30K 
Anna-Mari Hursti 16K 
Jani Tuovinen 32K 
Jari Mähönen 24K 
Henri Ojala 28K
Simo Räikkönen 50K
Kyösti Isberg 29K
Sauli Haapaniemi 28K
Henri Wagner 34K 
Pekka Virtanen 27K
Arto Lehtonen 57K 
Tomi Arponen 35K 
Jari Hurri 30K 
Juuso Wiksten 31K 
Jyrki Lampinen 23K 
Antti Perttula 25K 
JP Juhola 33K
Rasmus Lundström 25K 
Roope Holma 34K 
Seppo Parkkinen 30K 
Petteri Laiho 37K 
Aki Pyysing 17K 
Niklas Vakkuri 32K 
Jonatan Fors 24K 
Jani Vilmunen 32K 
Jussi Vanhanen 33K 
Konsta Heikkilä 36K 

Yksi huone nopealle Posted Thursday 29th February, 2024 at 13:34(UTC+2) by Juhani Tyriseva

"Hilton on täyteen bookattu, mutta loppuviikoksi minulla on peukalon alla yksi huone", kertoi TD Teresa Nousiainen. 

Tässä nopeat syövät hitaat, jos siis olet tulossa ja ilman huonetta, ota nyt heti yhteys Teresaan.

Suomalaisten pinot erästä 1A Posted Thursday 29th February, 2024 at 13:27(UTC+2) by Juhani Tyriseva

Tekniikka on ihmeellistä, olen näköjään (kiitos tarkkaavaiselle lukijalle) onnistunut ampumaan eilisen chip countin erästä 1A bittien taivaaseen. 

87/238 pelaajaa siis pelasi jatkopaikan. Tanskalais-Liettualainen Christian Ryssgaard johtaa 304K pinollaan. Toivotaan että Christian ei huomenna nuku pommiin. 

Suomalaisten pinot: 

Roni Berg 142K 
Ville Mesiranta 138K
Jarmo Salonen 107K
Sebastian Wahl 103K
Mathias Siljander 79K
Jarkko Suokas 78K
Petteri Miettinen 67K
Joni Liimatta 65K 
Matias Arosuo 64K 
Matias Knaapinen 60K
Jussi Mattila 59K
Tomi Rissanen 57K 
Touko Berndtson 52K
Tapio Aaltonen 52K 
Samuli Hietala 47K 
Juha Elo 20K 

Mukana olevat suomalaiset Posted Thursday 29th February, 2024 at 13:14(UTC+2) by Juhani Tyriseva

Suomalaisia mukana tänään: 

Tomi Arponen 
Sauli Haapaniemi 
Konsta Heikkilä 
Anna-Mari Hursti 
Elias Jalovaara 
Silja Kinnunen 
Jyrki Lampinen 
Arto Lehtonen 
John Lundqvist
Jari Mähönen 
Henri Ojala
Antti Perttula 
Mikko Saarremaa
Noel Suomalainen 
Pekka Virtanen 
Henri Wagner 
Juuso Wiksten 

Nyt on neljä pelaajaa jo menettänyt koko pinonsa, joten re-entrysuunnitelmia tehdään.  Meikäläisiä ei kassalle ole vielä joutunut.

13:03 (UTC+2)

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

Erä 1B tulee olemaan todella suuri Posted Thursday 29th February, 2024 at 12:29(UTC+2) by Juhani Tyriseva

Erässä 1B tullaan näkemään vauhtia ja vaarallisia tilanteita, sen tietää jo nyt. Peliä on nyt pelattu 30 minuuttia ja salissa on 126 pelaajaa! 

Kukaan ei ole ihme kyllä vielä pudonnut. 

Mitäs kaikkea muuta voi tänään pelata? Posted Thursday 29th February, 2024 at 12:15(UTC+2) by Juhani Tyriseva

Päivän ohjelma: 

Klo 12.00 1.100€ NLH Main Event 1B 
Klo 14.00 150€ Olybet Flip&Go to Mystery Bounty
Klo 15.00 80€ NLH Satellite to Main Event 1C (5 Guaranteed) 
Klo 17.00 250€ NLH 
Klo 19.00 350€ PLO4/5 Progressive Bounty 
Klo 21.00 1.100€ NLH Main Event 1C 
Klo 21.30 350€ NLH 6 Max 
Klo 23.00 150€ NLH Satellite to 5.000€ NLH Highroller (3 Guaranteed) 

Päivän kulku on selkeä Posted Thursday 29th February, 2024 at 12:08(UTC+2) by Juhani Tyriseva

Päivän kulku on todella selkeä. Alkupino on 30.000 ja tasot tunnin mittaisia. Ensimmäinen taso on bb ante 100, blindit 100/100. Kahdeksan tasoa pelataan, viimeinen taso on bb ante 1000, blindit 500/1000. 

Aina kahden tunnin jälkeen pidetään 15 minuutin tauko. Näin erä 1B päättyy noin klo 21.00, jos mitään isompia viivytyksiä ei matkalle satu. 

Pä

Shuffle Up and Deal! Posted Thursday 29th February, 2024 at 12:03(UTC+2) by Juhani Tyriseva

Kings of Tallinn turnausviikon pääturnauksen erä 1B alkaa nyt. 80 pelaajaa on jo nyt salissa ja lisää tulee tasaisena virtana. Oletus on, että tämä erä 1B on kolmesta aloituserästä selvästi suurin. 

Toimitukselle tämä päivä on selkeä, seurataan aloituserä 1B ja sitten siirrytään melko suoraan erään 1C. 

Pysykää kanavalla! 

Paljon mielenkiintoista seurattavaa siis luvassa, pysykää kanavalla! 

11:59 (UTC+2)

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

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