0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0709 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-18' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event7_fin/1/updates' ORDER BY `views` DESC

0.0181 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event7_fin/1/updates', 1, '2024-11-18')

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

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

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

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

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

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

0.0105 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.0138 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

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

0.0111 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.0108 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0035 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.0215 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0110 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.0100 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.0079 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '166'

0.0586 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0218 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '342' AND `published` = 1

0.0599 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0070 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '348' AND `published` = 1

0.0348 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '166' AND `name` = '1'

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

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

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` = '15072' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0137 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2553

English
Olympic Park Casino Event #7: €1,100 PLO4&5 (Finnish) Live Reporting - Day 2

Current Level 28 Current Day 2
Blinds 50,000/100,000 Ante 100000
Entries 198 Remaining 2
Prize Pool (EUR) €0 First Prize (EUR) €44,500
1 New Update - Click to refresh
Live Updates - Day 1
Varaa pokerimatkasi parhaalta matkan järjestäjältä! Posted Thursday 25th July, 2024 at 12:43(UTC+2) by Matthew Summers

-Nettisivumme toimii vaivattomasti mobiilissa

-Hintamme ovat kilpailukykyiset

-Voit maksaa matkasi heti tai vasta saavuttuasi

-ATOL-suojatut lentoliput

-GPS-pohjainen hotellien ja lentokenttien paikannus

-Turnauspaketit tai pelkät sisäänostot

-Tarjouksia ja promoja vain jäsenille

-Saat palvelua valitsemallasi kielellä 

-Runsaasti valuutta- ja maksuvaihtoehtoja

-Voit helposti muuttaa tai pidentää matkaasi 

Espen Sandvik finaalin bubble boy Posted Thursday 25th July, 2024 at 03:30(UTC+2) by Juhani Tyriseva

Finaalin bubble boy on Espen Sandvik. 

Suomalaiset: 

  • Jussi Mattila 695K 
  • Sami Paananen 210K 
  • Riku Koivurinne 505K 

Koska tämä päivä venyi hieman odotettua pidemmäksi, turnausjohto päätti että turnausta jatketaan vasta klo 14.00, niin pelaajat ehtivät hieman nukkuakin. 

Mattila Sorttia onnekkaampi Posted Thursday 25th July, 2024 at 03:06(UTC+2) by Juhani Tyriseva

Pudonneita:.

Jani Sortti. 

"Turnilta mentiin Jussi Mattilan kanssa sisään. Minulla oli kärki ja kaksi värinvetoa, Jussilla ylipari ja kärki. River ei tuonut minulle apuja, joten Jussin ylipari riitti pottiin", kertoi Jani. 

Jani tienasi 4.200€. 

Jukan pelit päättyivät Posted Thursday 25th July, 2024 at 02:44(UTC+2) by Juhani Tyriseva

Jukka Ylitalo ja Gisle Olsen menivät flopilla, kun Jukalla oli värinveto, ja Gislellä 14-outtinen suoran veto. 

Suora tuli jo turnista,  eikä Jukka edennyt. 

Jukka tienasi 4.200€. 

10  pelaajaa. Pidetään pikku tauko, ja sitten pelataan päivä päätökseen. Blindit 15K/30K. 

Jukalla oli outteja Posted Thursday 25th July, 2024 at 02:24(UTC+2) by Juhani Tyriseva

Jukka Ylitalo ja Espen Sandvik menivät all in ennen floppia.

Jukalla oli AA942, Espenilla KKQ86

Floppi Ks 7c 6h oli Jukan kannalta heikohko. 

Turn 5c

Rive 3s ja Jukalla oli suora, Espenillä ei.

Jukan pinossa nyt noin 400K. 

12 pelaajaa, lähellä päivän päättymistä aletaan olla. 

Jannen harava ei voittanut Posted Thursday 25th July, 2024 at 02:15(UTC+2) by Juhani Tyriseva

Janne Nevalainen ja  Jan Holte saivat merkit sisään haravillaan. Holten harava oli hieman laadukkaampi lähdössä ja parempi myös maalissa. 

Janne tienasi 3.150€.  

14 pelaajaa. 

Ei palautusta Posted Thursday 25th July, 2024 at 02:01(UTC+2) by Juhani Tyriseva

Pudonneita:

Jarkko Kivistö. 

"Parhaani koitin Jussia vastaan, mutta ei tällä kertaa riittänyt", mietti Jarkko.

"Loput hilut löin sitten keskelle kehnohkoilla, ilman palautusta", kertoi Jarkko.

Jarkko tienasi 2.750€. 

Good Luck Posted Thursday 25th July, 2024 at 01:57(UTC+2) by Juhani Tyriseva

Jarkko Kivistö ja Jussi Mattila menivät all in ennen floppia.  

Jarkolla tuplasuitti naulat, Jussilla tuplasuitti kunkut. 

Floppi As 5h 4c ei Jussille paljoa luvannut. "Good Luck", toivotti Jussi muille ja nousi jo seisomaan. 

Turn 6s 

River 8c ja kas, Jussilla oli apukortteina 7s  ja 4d, joilla sai suoran aikaan, ja tuplat. 

Jussilla nyt noin 380K. 

Suomalaisten pinot Posted Thursday 25th July, 2024 at 01:41(UTC+2) by Juhani Tyriseva

Suomalaiset: 

  • Jarkko Kivistö 280K 
  • Sami Paananen 90K 
  • Jani Sortti 310K 
  • Jukka Ylitalo 320K 
  • Jussi Mattila 90K 
  • Riku Koivurinne 140K 
  • Janne Nevalainen 310K 

Siirryttiin tasolle 21, blindit 10K/20K. 

Viekkaudella ja vääryydellä Posted Thursday 25th July, 2024 at 01:20(UTC+2) by Juhani Tyriseva

"Viekkaudella ja vääryydellä vietiin minun merkkini", virnisti Mika Hällström. 

Mika tienasi 2.450€. 

17 pelaajaa. 

Joonan vuoro lähteä kassalle Posted Thursday 25th July, 2024 at 01:15(UTC+2) by Juhani Tyriseva

Pudonneita: 

Joona Linna. 

"Vähän surullinen oli tämän turnauksen loppu, huonoja kortteja pukkasi jonkin aikaa", harmitteli jossain vaiheessa turnausta johdossakin ollut Joona. 

Joona tienasi 2.450€. 

19  pelaajaa. 

Iisakin pelit päättyivät Posted Thursday 25th July, 2024 at 01:07(UTC+2) by Juhani Tyriseva

Iisakki Ullakonoja sinnitteli läpi bubble porukan pienimmällä  pinolla, mutta pusku haravalla vihun rouvaparia vastaan ei ollut tällä kertaa voitokas. 

Iisakki tienasi 2.200€. 

22 pelaajaa. 

Olov Jansson oli kisan bubble boy Posted Thursday 25th July, 2024 at 01:02(UTC+2) by Juhani Tyriseva

Bubblea jouduttiin jonkin aikaa pelaamaan, mutta Ruotsin Olov Jansson sai kyseenalaisen kunnian olla kisan bubble boy. 

Turnissa Olov oli johdossa,  kun hänellä oli naulat, gutari ja patavärin veto. Vihulla oli rouva kiinni, gutari ja hertan veto. Riverin Ah täytti vihun värin, ja Olovin pelit päättyivät. 

10 suomalaista siis meni rahoille tästä kisasta, ei hullumpaa. 

Siirrytään tasolle 20,  blindit 10K/15K. 

Bubbleen on päästy Posted Thursday 25th July, 2024 at 00:19(UTC+2) by Juhani Tyriseva

Pudonneita: 

  • Henri Antikainen
  • Fredrik Lindström 
  • Mikael Haapaniemi
  • Olli Rummukainen 

24/198 pelaajaa, ollaan tasan bubblessa. 

Suomalaisten pinot Posted Wednesday 24th July, 2024 at 23:18(UTC+2) by Juhani Tyriseva

Suomalaiset:   

  • Jarkko Kivistö 80K 
  • Sami Paananen 165K 
  • Iisakki Ullakonoja 80K 
  • Olli Rummukainen 90K 
  • Jukka Ylitalo 210K 
  • Jussi Mattila 190K 
  • Riku Koivurinne 200K 
  • Henri Antikainen 180K
  • Mikael Haapaniemi 110K 
  • Janne Nevalainen 180K 
  • Joona Linna 350K 
  • Mika Hällström 200K 
Seppo lähti valmistautumaan Posted Wednesday 24th July, 2024 at 23:15(UTC+2) by Juhani Tyriseva

Pudonneita:

Seppo Parkkinen.

"Tällä kertaa hyökkäys epäonnistui, vihulla oli maalissa paremmat", totesi Seppo.

"Nyt unille ja huomenna sitten pääturnauksen erään 1E", suunnitteli Seppo.    

32 pelaajaa. 

Kolme meikäläistä vähemmän Posted Wednesday 24th July, 2024 at 22:50(UTC+2) by Juhani Tyriseva

Pudonneita: 

  • Jari Mähönen 
  • Jim Liljendal 
  • Antti Nieminen 

34 pelaajaa,  rahaa oli tarjolla 23 parhaalle, joten bubbleen on vielä vähän matkaa. 

Jyri ja Miika OUT Posted Wednesday 24th July, 2024 at 22:05(UTC+2) by Juhani Tyriseva

Pudonneita: 

Jyri Merivirta

Miika Töyräs

40 pelaajaa. Seuraava taso blindit 2K/5K. Veikataanpa että finaalipöytään päästään tasolla 15K/30K. 

Suomalaisten rivit harvenevat Posted Wednesday 24th July, 2024 at 21:21(UTC+2) by Juhani Tyriseva

Pudonneita: 

  • Tommi Lankinen 
  • Matias Arosuo
  • Toivo Rinne
  • Kai Välimäki 
  • Minh Thang Ngo

48 pelaajaa. Taso nyt blindit 1500/3000. Kyllä kello on aika paljon, kun kahdeksan finalistia on saatu selville. 

Rivit harvenevat Posted Wednesday 24th July, 2024 at 20:55(UTC+2) by Juhani Tyriseva

Pudonneita: 

  • Akseli Hosia 
  • Janne Peltoniemi
  • Akseli Paalanen 
  • Matias Kesänen 

55    pelaajaa. 

PLO:n payoutit ovat selvillä Posted Wednesday 24th July, 2024 at 20:54(UTC+2) by Juhani Tyriseva

1 €44,500
2 €29,200
3 €20,800
4 €15,400
5 €11,900
6 €9,280
7 €7,350
8 €6,000
9 €5,100
10-11 €4,200
12-13 €3,650
14-15 €3,150
16-17 €2,750
18-20 €2,450
21-23 €2,200

56 pelaajaa, joten rahoille on vielä matkaa. 

Suomalaisten chip count Posted Wednesday 24th July, 2024 at 20:40(UTC+2) by Juhani Tyriseva

66/198 pelaajaa. 

Suomalaiset: 

  • Akseli Hosia 65K 
  • Jarkko Kivistö 70K 
  • Jim Liljendal 55K 
  • Fredrik Lindström 33K 
  • Minh Thang Ngo 90K 
  • Sami Paananen 80K 
  • Janne Peltoniemi 40K 
  • Jani Sortti 40K 
  • Miika Töyräs 70K 
  • Iisakki Ullakonoja 170K 
  • Olli Rummukainen 250K 
  • Jukka Ylitalo 170K  
  • Antti Nieminen 55K 
  • Matias Arosuo 35K 
  • Jussi Mattila 75K 
  • Riku Koivurinne 260K 
  • Seppo Parkkinen 90K 
  • Henri Antikainen 20K 
  • Toivo Rinne 35K 
  • Mikael Haapaniemi 85K 
  • Akseli Paalanen 25K 
  • Kai Välimäki 60K 
  • Jari Mähönen 55K
  • Janne Nevalainen 150K 
  • Joona Linna 260K 
  • Jyri Merivirta 120K 
  • Mika Hällström 60K 
  • Matias Kesänen 40K 
20:15 (UTC+2)
Day 1 of Olympic Park Casino Started
Level:      Blinds: 0/0     Ante: 0

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.