0.0010 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0100 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event1_est/1B/updates'
ORDER BY `views` DESC
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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.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.0060 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.0004 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_event1_est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '134'
0.0298 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '316'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0462 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '318'
AND `published` = 1
0.0270 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0076 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '319'
AND `published` = 1
0.0704 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '322'
AND `published` = 1
0.0264 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '325'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '134'
AND `name` = '1B'
0.0565 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '318'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 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` = '318'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '14073'
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` = '14072'
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` = '14071'
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` = '14070'
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` = '14069'
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` = '14068'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14067'
ORDER BY `chip_change` DESC, `busted` ASC
0.0474 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14066'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14065'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14064'
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` = '14063'
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` = '14062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14061'
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` = '14060'
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` = '14059'
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` = '14058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0466 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14057'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14055'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14053'
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` = '14052'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14051'
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` = '14050'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14049'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14048'
ORDER BY `chip_change` DESC, `busted` ASC
0.0475 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14046'
ORDER BY `chip_change` DESC, `busted` ASC
0.0174 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14045'
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` = '14044'
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` = '14043'
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` = '14041'
ORDER BY `chip_change` DESC, `busted` ASC
0.0532 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14040'
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` = '14039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14038'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14037'
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` = '14036'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14035'
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` = '14034'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14033'
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` = '14032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14029'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '318'
ORDER BY `busted` ASC, `current_chips` DESC
0.0358 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` = '318'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '14073'
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` = '14072'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14071'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14070'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14069'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14068'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14067'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14066'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14065'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14063'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14061'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14060'
ORDER BY `chip_change` DESC, `busted` ASC
0.0163 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14059'
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` = '14058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14057'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14055'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14053'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14052'
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` = '14051'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14050'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14049'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14048'
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` = '14047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14046'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14045'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14044'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14043'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14041'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14038'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14037'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14036'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14035'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14034'
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` = '14033'
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` = '14032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14029'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '325'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
Eestlaste stäkid päeva 1B järel Posted Saturday 20th July, 2024 at 04:14(UTC+3) by maheaaatom
Päeval 1B tehti 97 sisseostu ning "ellu jäi" 31 parimat. Liidrid olid kogu aeg ühed ja samad: Jon Kyte (165 000) ja Phil Gros (140 000).
Eesti mängijaid pääses edasi seitse, kahjuks keegi mitte kuigi suure stäkiga. Parimana oli Aleksandr Hlabob alles 14.
Võistlus jätkub laupäeval kell 12:00, seniks head ööd!
Player
Chips
Progress
Aleksandr Hlabov
58,600
0
Roland Luik
49,400
0
Stanislav Smeljov
49,000
0
Nikita Mitrofanov
28,100
0
Ilja-Ülo Nukka
22,100
37,900
Ingmar Ivask
21,700
18,300
Viacheslav Martynenko
13,500
0
Jaanus langeb ikkagi läks sakslase Posted Saturday 20th July, 2024 at 03:26(UTC+3) by maheaaatom
Jaanus Veste lükkab -ga keskele ning ässa näinud Phil Gros muidugi foldima ei hakka, sest Jaanuse stäkk on samuti üsna väike.
Phil avab kõrvale ning on mõistagi ülimalt rahul.
Flop on intrigeeriv - mõlemale midagi. Jaanuse kahjuks turn ja river lauda masti ei too ning Phil hõiskab rõõmust. Sellega on mäng tänaseks ka läbi ning chipid aetakse kottidesse. Peagi avaldame allesjäänud eestlaste stäkid.
Viimased viis kätt Posted Saturday 20th July, 2024 at 03:20(UTC+3) by maheaaatom
Turniirikell pandi seisma ning mängijatele asuta jagama viit viimast jaotust. Konkurentsis 33 parimat.
Rasmusel ei sujunud Posted Saturday 20th July, 2024 at 03:17(UTC+3) by maheaaatom
Rasmus Sepping on elukutseline pokkerimängija, kes tegutseb peamiselt (nagu teisedki) internetis ning live-turniiridel käib eeskätt lõbutsemas.
Lõbus tal oli, kaart aga paraku ei jooksnud. Viimaseks käeks jäi Nikita Mitrofanovi vastu, kuid selleks hetkeks oli Rasmuse
le vaid 5500 järgi ning oodata polnud enam midagi.
Abiraha Saksamaalt Posted Saturday 20th July, 2024 at 03:10(UTC+3) by maheaaatom
Enne floppi olid sees kolm mängijat:
Aleksandr Hlabov:
Jaanus Veste:
Phil Gros:
Lauda nii neli kui seitse. Aleksandril oli selgelt kõige vähem ning ta kolmekordistas oma stäki. Jaanus jäi enam-vähem omadesse ning ka Phil Gros ei lasknud tujul langeda. On ta ju jätkuvalt oma laua liider.
Päeva viimane tase Posted Saturday 20th July, 2024 at 03:04(UTC+3) by maheaaatom
Päeva 1B viimast taset alustab 36 mängijat, eestlaste seis on endiselt üsna sama.
Turniiri domineerivad endiselt Kyte ja Gros, viimane mängib küll väga lahtiselt ning tema stäkk on päris palju kõikunud. Õnnestus ju Grosil vahepeal koguni veerand miljoni peal ära käia.
03:01 (UTC+3)
Start of Level 10 Blinds: 500/1,000 Ante: 1,000
Vanad sõbrad said jälle kokku Posted Saturday 20th July, 2024 at 02:55(UTC+3) by maheaaatom
Floppi vaatas neli mängijat. Kõik checkisid kuni Ilja-Üloni, kes pani 1500 ning sai kaks calli.
Turni järel checkiti taas ette, Ilja-Ülolt tuli 5500 ja Jon Kytelt taas call.
Riverisse avati , Jon Kyte checkis taaskord ning nüüd panustas Ilja-Ülo 8500. Norralane mõtles natuke ning teatas, et on all-in (laua chipliidrina kattis ta kindlalt meie meest).
Ilja-Ülo foldis lahtiselt , Jon Kyte aga . Huvitav, milline võis olla teine taskukaart? Ilmselgelt Ilja-Ülol oli kaheksa kõrval blank, kuid kas norralasest pokkerimiljonäril ikkagi oli mast? Või rida? Või ei olnud üldse midagi?
40 parimat Posted Saturday 20th July, 2024 at 02:36(UTC+3) by maheaaatom
Päeva 1B viimast mängutundi alustab 40 mängijat ning võib eeldada, et vähemalt veerandist neist jääme päeva lõpuks ka ilma. Eesti esindajaid on sees üheksa. Või siis õigemine juba kümme, sest äsja otsustas ka Jaanus Veste lauas istet võtta,
Ja kossusõpradele ka infoks, et kasiino suurelt ekraanilt saab näha live'is Henri Drelli mängu NBA suveliigas.
02:35 (UTC+3)
Start of Level 9 Blinds: 400/800 Ante: 800
Algas viimane paus Posted Saturday 20th July, 2024 at 02:16(UTC+3) by maheaaatom
Mängijad lubati 15 minutiks jalgu sirutama, pärast seda jääb veel täpselt tund mängida. Eestlaste seas viimase 10 minuti jooksul midagi põrutavat ei toimunud.
Kes juhivad mängu? Posted Saturday 20th July, 2024 at 02:05(UTC+3) by maheaaatom
Päeva 1B kaks suurimat stäkki on hetkeseisuga Phil Gros (180K) ning Jon Kyte (150K).
Phil fenomenist me juba kirjutasime, kuid Jon Kyte tänane saak on tulnud peamiselt Ilja-Ülolt. Ja Ilja-Ülo on omakorda koorinud teisi lauakaaslasi. Naljaga pooleks jääb kohati arusaamatuks, mida need teised mängijad siis üldse seal lauas teevad :)
Roland näeb soomlanna läbi Posted Saturday 20th July, 2024 at 01:58(UTC+3) by maheaaatom
Soomlanna Laura Hannele Sandström ning Roland Luik mängivad suure panga, kus meie mehel on positsioonieelis.
Flopis on , turni järel paneb Laura 2500 ning riveri järel juba 5000.
Roland callib kiirelt turni ja vastab riverile 12K ületõstega. Soomlannalt kiire fold, Roland näitab .
Laura muheleb, et tal polnud sedagi.
Valmistume ka homseks Posted Saturday 20th July, 2024 at 01:51(UTC+3) by maheaaatom
Laupäeval on turniirikavas juba kolm kõrvalturniiri:
Kell 13:00 €350 NLH Progressive Bounty, €100 Bounties, 8-handed
Kell 17:00 €250 OFC Pineapple (Hiina pokker), 3-handed, finaali (4 mängijat) mängitakse nii, et üks istub väljas.
Kell 21:00 €150 PLO4&5&6 Progressive Bounty (pearaha 40 eurot), 6-handed
Meie peamises fookuses on aga 250 € NLH päevad 1A ja 1B (vastavalt kell 12:00 ja 18:00) ning nagu täna - toimub ka homme kell 23:00 555 € NLH 80-eurone satelliit.
01:46 (UTC+3)
Start of Level 8 Blinds: 400/800 Ante: 800
Ilja-Ülo pääseb Posted Saturday 20th July, 2024 at 01:39(UTC+3) by maheaaatom
Ilja-Ülo Nukka on all-in'is Viktor Snõtko vastu ning kui lehed avatakse, siis paistab tulevat selline igapäevane tore flip.
Ilja-Ülo:
Viktor:
Turnis avatakse , mis annab Ilja-Ülole kõrgeima paari, Viktor saab aga poti masti tõmbe. Action-mängija Ilja-Ülo õnneks on river blank ning tema 17700 stäkk saab vajaliku duubli.
Showmehed omavahel Posted Saturday 20th July, 2024 at 01:27(UTC+3) by maheaaatom
Kes veel mäletab, kuidas sai Eestis kuulsaks sakslane Phil Gros? Ta saavutas üsna müstilise ja äraaimamatu mänguga (foldis suuri käsi ja paugutas ei-millegagi) teise koha 2023. aasta Summer Showdown põhiturniiril ning teenis koguni 72 700 eurot.
Phil on kohal ka WSOP Circuit'il ning näitab siingi lõbusat mängu, ütlemata vahel ära ka korralikust gämblingust.
Selle vastu, et võrdlemisi korraliku stäkiga Akseli Hosia all-in'i vastu -ga minna, pole Philil midagi. Ega pokkerit saagi alati liiga tõsiselt võtta.
Akseli avab ning ütleb otse, et kui sakslane peaks millelegi pihta saama, siis ega tal sellest kahju küll ei ole.
Ja tal polegi, Akseli jääb lõpuni heatujuliseks. Kuigi juba flopis sajab lauale talle saatuslik üheksa...
01:13 (UTC+3)
Start of Level 7 Blinds: 300/600 Ante: 600
No ei saa mehed rahu! Posted Saturday 20th July, 2024 at 01:13(UTC+3) by maheaaatom
Flop ajab taas kuumaks nii Jon Kyte kui Ilja-Ülo. Meie mehelt tuleb 4K panus, norralane vastab 14K-ga ning saab calli.
Turn checkitakse läbi.
Riveri järel checkib Ilja-Ülo ette ning Norra pokkerimiljonär paneb mõningase mõtlemise järel 8,2K, mille Ilja-Ülo ägisedes ära callib.
Jon Kyte:
Ilja-Ülo:
Valus flopi, midagi pole öelda...
Suur pank Ilja-Ülole Posted Saturday 20th July, 2024 at 01:03(UTC+3) by maheaaatom
Floppi vaatas 1500-ga koguni viis mängijat.
Turni järel checkiti kuni norra pokkerimiljonär Kyte'ni, kes panustas 3500 ning sai kaasa nii Ilja-Ülo kui Sakari Setälä.
Riverisse avati , Ilja-Ülo alustas 7300-ga, Kyte foldis ning soomlane pressis all-in. Meie mehelt instacall.
Sakari:
Ilja-Ülo:
Nupud loeti üle, soomlasel oli pisut rohkem. Ilja-Ülol nüüd pea 60K, mis on juba üsna mängitav stäkk.
Player
Chips
Progress
Ilja-Ülo Nukka
60,000
0
Poisid Marekile õnne ei toonud Posted Saturday 20th July, 2024 at 00:59(UTC+3) by maheaaatom
Marek Selgeveer sai viimaks enam-vähem mängitava käe - , kuid tema õnnetuseks leidis midagi ka Laura Hannele Sandström ning selleks leiuks osutusid emandada.
Preflop all-in lõppes kõrgema pocketi võiduga.
Eestlastel suuri stäkke ei ole Posted Saturday 20th July, 2024 at 00:50(UTC+3) by maheaaatom
Hardi Karolin on teinud re-entry, välja on langenud Aleksei Golov ning Philipp Mityurev.
Üldiselt ei paista eestlastel suuri stäkke olevat, parimas seisus võib vast olla Stanislav Smeljov, kuid temalgi on vaid napilt 40K. Keskmine stäkk ligineb 30K-le, hetkel on see umbes 60XBB.
00:46 (UTC+3)
Start of Level 6 Blinds: 200/500 Ante: 500
See laud on täis täielikke argpükse! Posted Saturday 20th July, 2024 at 00:36(UTC+3) by maheaaatom
Enne floppi kemplevad omavahel Rasmus Sepping ning leedulane Modestas Kryzanauskas. Modestas panustab lõpuks 4400 (blindid 200/400), Rasmus aga tõstab veelgi üle - 9400.
Leedulane mõtleb, kuid otsustav foldida. Eks ta all-in'i poole kiskis jah...
Modestasel olevat pocket soldatid olnud. See ei mahu aga pähe laua peamiselt mölamehele Akselile, kes oleks enda sõnul Rasmuse vastu kasvõi -ga all-in lükanud ning Modestase lüke tundub talle täiesti arusaamatu.
Mis Rasmusel oli? Eks mõelge välja. Käsi mängiti viis minutit tagasi ning on endiselt selle laua peamine jututeema.
Taas vanad sõbrad omavahel Posted Saturday 20th July, 2024 at 00:29(UTC+3) by maheaaatom
Vanad võistluspaarid jätkavad vastasseisu:
1) Kyte vs. Ilja-Ülo. Norralane kasutab taas ära positsioonieelise ning tõrjub Ilja-Ülo riveril pangast välja. Õnneks kaotab meie mees vaid umbes 4K.
2) Sultans Ertinhajevs vs. Ingmar. Ka sel korral on positsioonieelis vastasel, kuid Ingmari 5500 panus pärast riverit on piisav, et vastane pangast välja tõrjuda. Meie mehele umbes 5000 juurde.
Rasmuse lauas on muutunud juba üsna meeleolukaks, seejuures hoiab peamiselt juttu üleval soomlane Akseli Hosia ning ka ülejäänud lauakaaslased on väga jutukad. Ühesõnaga - seda ühte lauda on kuulda kordades paremini kui kõiki teisi kokku.
65 mängijat alles, 85 sisseostu.
00:17 (UTC+3)
Start of Level 5 Blinds: 200/400 Ante: 400
1B esimesele pausile, algas 80-eurone satelliit Posted Saturday 20th July, 2024 at 00:01(UTC+3) by maheaaatom
Saali tagumises nurgas algas 555 € turniiri satelliit (10 piletit GTD, sisseost 80 eurot). Mängijaid on 20 ringis.
250 € turniiri päev 1B läks esimesele pausile. Nagu päevalgi, on pause kaks ning mängitakse 10 taset (ehk läheb umbes poole kolmeni öösel).
Lätlane sunnib Ingmari foldima Posted Friday 19th July, 2024 at 23:57(UTC+3) by maheaaatom
Turniks on lauas ning pangas tubli 6K.
Sultans Ertinhajevs checkib ette, Roland paneb 2200, Ingmar teeb ületõste 7200 ning Sultans lükkab all-in (umbes 21K). Rolandilt tuleb imekiire fold, Ingmar veel mõtlen aga lõpuks foldib siiski oma kaardid.
Roland palun ühte näha ning avatakse . "Noh, kuningas-kaks tõenäoliselt. Suited," pakub Roland.
Ilja-Ülo peab Norra superässale alla vanduma Posted Friday 19th July, 2024 at 23:42(UTC+3) by maheaaatom
Norra pokkerimiljonär Jon Kristian Kyte on kahtlemata üks tõsisemaid mängijaid, kes Tallinna WSOP Circuit'il osaleb. Äsja naases mees Las Vegasest, kus jäi WSOP bracelet'ist kõige napimalt ilma.
Kolmandas lauas on laheda tiigrimütsiga Ilja-Ülo kahtlemata üks aktiivsemaid mängijaid ning koos Jon Kristiani ning ühe soomlasega vaadati ka 2K panuse peale floppi . Soomlane ja eestlane checkisid, Jon Kristian pani 3000 ning sai viimaks calli ainult Ilja-Ülolt.
Turni järel elevnes taas Ilja-Ülo, panustades esimesena 4K. Norralaselt call.
Riveri järel pani Ilja-Ülo juba 8000, kuid Jon Kristian vastas all-in'iga (umbes 14K). Paistis, et Ilja-Ülo bluffis tõenäoliselt ei-millegagi, sest fold tuli väga kiirelt. Aga tema seis pole õnneks väga kurta, endiselt on alles pisut üle algstäki.
Roland haukab natuke Ingmarilt Posted Friday 19th July, 2024 at 23:31(UTC+3) by maheaaatom
Lauas nr. 2 mängivad pisut suurema panga Roland Luik ning Ingmar Ivask. Riveriks on lauas ning pangas ligikaudu 3K. Umbes selleväärse panuse teeb ka Roland ning Ingmar callib selle ära. Rolandi on võiduks enam kui piisav.
Ainuke meeleolukas laud paistab olevat Rasmus Seppingu oma, kus arutatakse parajasti paradoksi üle, et miks soomlased tulevad Eestisse alkoholi ostma, eestlased teevad seda Lätis ja lätlased omakorda...
23:28 (UTC+3)
Start of Level 4 Blinds: 100/300 Ante: 300
VIDEO: Mida võiks teada iga WSOP Circuit'il osaleja? Posted Friday 19th July, 2024 at 23:22(UTC+3) by maheaaatom
Kohal ka Marek Selgeveer Posted Friday 19th July, 2024 at 23:20(UTC+3) by maheaaatom
Tuntud meelelahutusmängija Marek Selgeveer on samuti lauas ning hoolimata asjaolust, et samas lauas on ka näiteks Roland Luik, on Marek (siiani) veel vaiksemast vaiksem.
Selles lauas domineerib hoopis kolmas eestlane Ingmar Ivask, kes on suutnud oma algstäki juba umbes duubeldada.
Kas saame päeval 1B 100 mängijat täis? Välistatud see ei ole, sest hetkel on tehtud juba 74 sisseostu (langejaid on kuus).
Player
Chips
Progress
Ingmar Ivask
40,000
0
Kaotus omade leeris Posted Friday 19th July, 2024 at 23:04(UTC+3) by maheaaatom
Aleksandr Gamonovits pushib oma allesjäänud 4K stäki keskele pärast lauas avatud ning saab sellele ka calli.
Aleksandr avab naerdes , millel pole pocket seitsmete vastu mingit võimalust. Tema oli ka esimene Eesti värvides langeja, kokku on õnnetuid viis.
22:59 (UTC+3)
Start of Level 3 Blinds: 100/200 Ante: 200
Tähelepanu naised! Posted Friday 19th July, 2024 at 22:58(UTC+3) by maheaaatom
Tänavuse WSOP Circuit'i üks keskseid üritusi on naisteturniir, mille võitja teenib kuldsõrmuse ning koha WSOP meistrite turniirile. Naisteturniiri finaal kantakse üle TV-lauas ning selle auhinnafond on kindlasti vähemalt 10 000 eurot. Seega on põhjust osalemiseks küll ja küll.
Kui 250 € sisseost tundub palju, siis tasub kindlasti osaleda kahel satelliidil:
- 21. juulil kell 13:00, 3x250 € WSOP Circuit naisteturniiri piletit GTD
- 22. juulil kell 14:00, 5x250 € WSOP Circuit naisteturniiri piletit GTD
Lisaks mängitakse välja ka tasuta pileteid festivali viimasel nädalavahetusel toimuvale teisele naisteturniirile (võitja ei saa küll sõrmust, kuid au, kuulsust ja palju raha ikka). Freerollid toimuvad:
- 23. juulil kell 16:00 samaaegselt naiste sõrmuseturniiri finaaliga (5 x 150 € WSOP Circuit Queens Mystery Bounty piletid GTD).
- 27. juulil kell 12:00, 5x150 € WSOP Circuit Queens Mystery Bounty pileti GTD.
Cashgame ja staff-turniir Posted Friday 19th July, 2024 at 22:51(UTC+3) by maheaaatom
Kasiinos on melu turniirialast rohkemgi ning käimas cashgame seitsmel laual. 47 142-eurone Bad Beat Jackpot ahvatleb endiselt paljusid, sest nagu Rikardi imeline käsi näitas - võiduks ei ole ju vaja midagi eriti müstilist.
Samuti toimub ülemisel korrusel turniir festivali personalile, eeskätt diileritele. Auhinnad on pannud välja Olympic Casino ning võib võita nii mõndagi õige mõnusat. Osalejaid on mõnekümne kanti.
Kaheksa lauda Posted Friday 19th July, 2024 at 22:40(UTC+3) by maheaaatom
Oleme jõudnud kaheksa lauani ning hetkel istub nendes 58 mängijat. Võrreldes päevaga 1A on start märksa kiirem, sest koguni kolm meest on juba suutnud oma stäki õhku lasta ning re-entry järel käinud.
Meie meestest on lisandnud Stanislav Smeljov, kes käis (kahjuks küll ebaõnnestunult) kätt proovimas ka 1A-l. Kõik ülejäänud on uued näod.
22:37 (UTC+3)
Start of Level 2 Blinds: 100/100 Ante: 100
Rasmus ärgitab kaaslasi lõbutsema Posted Friday 19th July, 2024 at 22:28(UTC+3) by maheaaatom
"Ikkagi reede, mis te šottidest arvate?" uurib Rasmus vastastelt, kuid paistab, et keegi ei kipu vedu võtma.
Viimaks liitub lauaga üks noor soomlane, õlleklass kaasas. "Kas see oli alkoholiga?" uurib Rasmus ning saanud jaatava vastuse, kostab rahulolevalt: "Lõpuks ka üks inimene!"
Rasmuse suurim turnahitt pärineb 2022. aastast, mil ta võitis Kings of Tallinnal 193 osalejaga 550 € NLH turniiri ning teenis 27 140 eurot.
Kohal on Roland Luik ja Rasmus Sepping Posted Friday 19th July, 2024 at 22:16(UTC+3) by maheaaatom
Tuntud Eesti ässadest on kohal Olympic Casinos varemgi suuri võite saanud Roland Luik ja Rasmus Sepping. Kokku kaitseb meie riigi au umbes ümmekond mängijat.
Päeva 1B alustas 40 mängijat Posted Friday 19th July, 2024 at 22:12(UTC+3) by maheaaatom
"Õhtused ärkajad" on laudades ning mäng on läinud käima. Hetkel 40 alustajat ning suures saalis on endiselt väga vaikne. Arvestatud on kuni kümne lauaga.
Your search results are valid for .
Go to checkoutMore 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.