0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est/1/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.0001 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.0003 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 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.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0034 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_KOT_350_Tallinn_Cup_Est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
0.0277 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` = '220'
AND `published` = 1
0.0277 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '223'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
AND `name` = '1'
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '220'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '220'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.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` = '9517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9515'
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` = '9514'
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` = '9512'
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` = '9511'
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` = '9509'
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` = '9508'
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` = '9507'
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` = '9504'
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` = '9503'
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` = '9501'
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` = '9500'
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` = '9499'
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` = '9498'
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` = '9496'
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` = '9493'
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` = '9492'
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` = '9491'
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` = '9489'
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` = '9488'
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` = '9487'
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` = '9485'
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` = '9483'
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` = '9482'
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` = '9481'
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` = '9480'
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` = '9479'
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` = '9478'
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` = '9477'
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` = '9476'
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` = '9475'
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` = '9474'
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` = '9473'
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` = '9472'
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` = '9471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9470'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '9469'
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` = '9468'
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` = '9467'
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` = '9466'
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` = '9465'
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` = '9390'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '220'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '220'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.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` = '9517'
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` = '9516'
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` = '9515'
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` = '9514'
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` = '9512'
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` = '9511'
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` = '9509'
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` = '9508'
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` = '9507'
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` = '9504'
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` = '9503'
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` = '9501'
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` = '9500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9498'
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` = '9496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9493'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '9492'
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` = '9491'
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` = '9489'
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` = '9488'
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` = '9487'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9485'
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` = '9483'
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` = '9482'
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` = '9481'
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` = '9480'
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` = '9479'
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` = '9478'
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` = '9477'
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` = '9476'
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` = '9475'
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` = '9474'
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` = '9473'
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` = '9472'
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` = '9471'
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` = '9470'
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` = '9469'
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` = '9468'
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` = '9467'
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` = '9466'
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` = '9465'
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` = '9390'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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.
Tänaseks kõik Posted Saturday 24th February, 2024 at 01:59(UTC+2) by maheaaatom
Allesjäänud umbes 120 mängijat pakivad nuppe kottidesse, et homme taas mängulaudadesse naasta. Soovi korral võivad mänguga liituda ka need, kes täna välja langesid ning needki, kes üldse lauda ei istunudki. Hiline registeerimine on avatud kolm esimest taset ehk umbes kuni kell 13:30-13:45.
Homme jätkub mäng 30-minutiliste tasemetega ning tõenäoliselt on võitja keskööks teada. Aga 350 € CUP-i kõrval jälgime kindlasti ka kõiki teisi turniire ning vahendame festivali üldist melu.
Hetkel on Olympic Casinos jätkumas võimas cashgame ning Hiltoni konverentsisaalis käimas veel avaturniir (parimad 12, meie omadest sees Anna Astahhova) ning 555 € Championship turniiri satelliit. Tulemused avaldame juba homme, head ööd!
Viis viimast kätt Posted Saturday 24th February, 2024 at 01:52(UTC+2) by maheaaatom
350 € CUP-il asuti jagama viite viimast jaotust, seega on mäng peagi tänaseks läbi.
Fuajeest ka üks hea uudis - Aleksei Smirnovil on umbes 95K stäkk, mis on peaaegu kahekordne keskmine. Ja oma nuppe Aleksei juba hoida oskab!
Player
Chips
Progress
Aleksei Smirnov
95,000
65,000
Martti on väljas, Annal hea seis Posted Saturday 24th February, 2024 at 01:45(UTC+2) by maheaaatom
Avaturniiri jätkab 14 parimat ning kahjuks pole nende seas ka enam pokkeri-ja volleässa Martti Keelt.
Eesti au jääb kaitsma ainsana Anna Astahhova, kellel on umbes 1,5-kordne keskmine stäkk.
Hendrik jäi imekombel ellu Posted Saturday 24th February, 2024 at 01:41(UTC+2) by maheaaatom
5K peale langenud Hendrik Uibo läks all-in -ga ning sai kaks calli - -lt ja -lt.
Pole just kiita seis...Aga river maitses Hendrikule muidugi väga hästi.
Algas tänane viimane mängutase Posted Saturday 24th February, 2024 at 01:32(UTC+2) by maheaaatom
350 € CUP-il algas tänane viimane mängutase. Viimase paarikümne minuti jooksul pole ühtegi täiendavat sisseostu enam tehtud, väljalangejate mõtted paistavad olevat pigem juba homses.
01:31 (UTC+2)
Start of Level 9 Blinds: 600/1,200 Ante: 1,200
Edgar seab end minekule Posted Saturday 24th February, 2024 at 01:28(UTC+2) by maheaaatom
Edgar Põhjamets sai oma 20BB stäki sisse heas seisus ülimalt lahtiselt mängiva Atte Jukanpoika Puolakka vastu, kuid paraku polnud tal lihtsalt õnne.
Edgar:
Atte:
Riverisse kolm...
Üle keskmise stäkiga Eesti mängijad Posted Saturday 24th February, 2024 at 01:19(UTC+2) by maheaaatom
Player
Chips
Progress
Kert Hallik
95,000
65,000
Peep Kivistik
75,000
45,000
Madis Müür
74,000
44,000
Allan Arjut
70,000
0
Stanislav Smeljov
65,000
35,000
Risto Pärnat
50,000
20,000
Oskar Ojaveer
50,000
20,000
Martti räägib mänguplaanidest Posted Saturday 24th February, 2024 at 01:05(UTC+2) by maheaaatom
Valitsev HU Eesti meister Martti Keel on endale juba taganud avaturniiril vähemalt 600-eurose võidu ning tõdeb, et ega tal tõenäoliselt rohkematel turniiridel osaleda õnnestugi. Seega on eesmärgiks jõuda täna nii kaugele kui võimalik. Nii Martti kui Anna stäkid on igati mängitavad, kuid võiduni on veel väga pikk tee. 16 parimat alles.
01:02 (UTC+2)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Hannole avaturniiril bad beat Posted Saturday 24th February, 2024 at 00:54(UTC+2) by maheaaatom
Kolmekordne Eesti meister Hanno Kerem on kahjuks avaturniirilt väljas, seda veel üsna korraliku bad beadiga.
PFAI, Hannol , vastas ning kuus turni. Avaturniiri jätkab 17 parimat, Eesti au kaitsevad vaid Martti Keel ning Anna Astahhova.
Kaidar arutab, mida 600 euroga teha Posted Saturday 24th February, 2024 at 00:45(UTC+2) by maheaaatom
Valitsev Eesti pokkerimeister Kaidar Viikman langes avaturniirilt 20-ndana välja, saades lohutuseks 600 eurot auhinnaraha. "Noh nüüd on vähemalt millega järgmisi turniire mängida," sõnab mees, kes on korduvalt rõhutanud, et on lihtne, keskmist palka teeniv pokkerifänn ning niisama kuskil lahmimas ei käi.
Kaidar homme mängima ei tule - plaanis on teised asjad - küll on aga kindlasti kohal pühapäeval, mil toimub tema lemmikmäng 8-Game. Aga eks on mehe mängukavas mõni teinegi turniir.
Uudiseid avaturniirilt Posted Saturday 24th February, 2024 at 00:37(UTC+2) by maheaaatom
Hetkeseisuga on alles 21 parimat, eestlastest on langenud Erik Põlluveer, Mauro-Mark Musting ning paraku ka Kairit Leibold. Tema -st ei olnud paraku vastu kasu.
Allan annab natuke ära Posted Saturday 24th February, 2024 at 00:35(UTC+2) by maheaaatom
Allani lauas vaatavad neli mängijat - kaks soomlast, Allan ja Artur 1200-ga floppi
Algselt tõstnud noor agressiivne soomlane jätkab 2K-ga, Artur muckib ja teine soomlane koos Allaniga callivad.
Turn on , algne panustaja paneb nüüd juba 12K ning Allan callib ainsana.
Riverisse avatakse "plankude plank" ehk .
Nüüd tuleb soomlaselt juba 25K panus ning -ga mänginud Allanil pole enam kuskile pääsu. Soomlane avab flopanud masti ning korjab panga maha.
00:29 (UTC+2)
Start of Level 7 Blinds: 400/800 Ante: 800
Avaturniiril on mängus veel 8 eestlast Posted Saturday 24th February, 2024 at 00:17(UTC+2) by maheaaatom
Avaturniiril jätkava 28 mängija seas on 8 eestlast, kellest Erik Põlluveer hängib küll juba mõnda aega sees õige pisikese punktisummaga. Aga kuniks alles on veel kasvõi üks nööp, pole ju midagi läbi.
29. koht läks Georgi Abuladzele, tema on siiani ka ainus rahadesse jõudnud, kuid mängu enam mitte jätkav eestlane.
350 € CUP läks tänasele viimasele pausile, mängida on veel 3x30 minutit. Ehk siis umbes kella kaheni öösel.
Tähelepanuks homsetele tulijatele Posted Saturday 24th February, 2024 at 00:05(UTC+2) by maheaaatom
Laupäeval ootab meid ees juba märksa rohkem turniire kui täna ning neli tähtsaimat neist, millele tasuks erilist tähelepanu pöörata, on järgmised:
Kell 12:00 jätkub 350 € CUP (re-entry on lubatud kuni 13:45-ni)
Kell 15:00 algab 150 € OFC Pineapple (Hiina pokker)
Kell 17:00 algab PLO 4/5 Cards (555 €)
Hobimängijatel tasub tulla kohale kell 19:00 algavale Iseseisvuspäeva eriturniirile, mille sisseost vägagi tasukohane 150 eurot.
188 sisseostu Posted Friday 23rd February, 2024 at 23:59(UTC+2) by maheaaatom
CUP-i auhinnafond paisub hoogsalt, juba on sisseoste 188 ning laudades 150 mängijat. Kuigi keskmine stäkk on umbes 60XBB, lükkavad nii mõnedki mängijad väga hoogsalt nuppe.
Avaturniiril on alles 33 parimat ning ei paista, et eestlastel oleks just hirmsuuri stäkke. Samas on seal ka mäng väga kiire (keskmine 20XBB) ning turniiri otsustav faas alles ees.
23:57 (UTC+2)
Start of Level 6 Blinds: 300/600 Ante: 600
Avaturniiril rahasaajad selged Posted Friday 23rd February, 2024 at 23:48(UTC+2) by maheaaatom
Avaturniiril lõhkes just mull ning floor õnnitles allesjäänud mängijaid rahadesse jõudmise puhul.
Kahjuks olid nii mullimees kui pre-mull Eesti mehed: vastavalt Vjatšeslav Jakušin ning Marek Selgeveer.
Elevust on ka 350 € CUP-il, nimelt õnnestub Aleksandr Hlabovil -ga mastirida saada.
Käimas ka 555 € Championship turniiri satelliit Posted Friday 23rd February, 2024 at 23:41(UTC+2) by maheaaatom
Umbes pool tundi tagasi algas 80-eurone satelliit 555 € Championship turniirile.
Osalejaid on hetkel küll veel vähevõitu, umbes tosina jagu. Aga aega liitumiseks on vähemalt kell 01:00-ni öösel.
555 € Championship algab pühapäeval ning see on üks Kings of Tallinna tähtsamaid turniire. Võitja selgub telelauas 28. veebruaril. Mullu oli turniiri auhinnafond võimas 277 098 eurot ning parima eestlasena oli Tarmo Tammel mäletatavasti kolmas. Tarmost, kes mängib hetkel Pariisi EPT-l, saate pikemalt lugeda selles Postimehe artiklis.
P.S. Kings of Tallinn teleülekanded algavadki just nimelt 555 € Championship turniiri finaaliga.
23:27 (UTC+2)
Start of Level 5 Blinds: 200/500 Ante: 500
Avaturniiril tempo maas Posted Friday 23rd February, 2024 at 23:25(UTC+2) by maheaaatom
Avaturniiril on käimas pre-mull mäng ning turniiri tempo on sellega üsna maas.
Eestlasi on mängus 11, nende seas ka kaks naist - lisaks Kairit Leiboldile ka suurfestivalidel üsna aktiivseks mängijaks muutunud Anna Astahhova.
Tuntud tegijatest jahibd tiitlit Georgi Abuladze, Kaidar Viikman, Erik Põlluveer ning ka volleäss Martti Keel.
Allanil 100K Posted Friday 23rd February, 2024 at 23:16(UTC+2) by maheaaatom
Allan Arjut särab, sest on kolme käega päris rikkaks saanud.
1. Artur Külanurk avab 800, Allan kolmpanustab 2,5K -ga. SB peal istub üks pidune soomlane, kes küsib Arturi stäkki ja flatib. Arturilt fold.
Flop , soomlane checkib ette ja snapcallib Allani 3K panust.
Turn on , soomlane taas checkib ja snapcallib Allani 6K panust.
Riverisse avatakse veel üks ning soomlane kiire all-in, Allanilt sama kiire call. Soomlasel "lumememmed" ehk siis pocket kaheksad.
2. Pisut hiljem floppab Allan neljadega kolmiku ning saab ühe rootslase käest kõik kolm tänavat maksu, sellega lisa veel umbes 20K.
3. Lauda tuleb uus mängija, kelle Allan kiirelt elimineerib ( vs. ). Allanil nüüd umbes 100K, mis on umbes 3X keskmine.
Veel põnevaid uusi mängijaid Posted Friday 23rd February, 2024 at 22:56(UTC+2) by maheaaatom
Turniiriga on liitunud ka Mark Metsla, Ranno Sootla, Edgar Põhjamets, Oskar Ojaveer ja Janek Hin.
Nii mõnigi neist on CUP-il põhjusel, et nende jaoks sai 250 € avaturniir just läbi. Viimasel ollakse rahadele juba päris lähedal (alles 47, marjamaale pääseb teatavasti 39).
Inflatsooni mõju Posted Friday 23rd February, 2024 at 22:53(UTC+2) by maheaaatom
Pausi ajal arutasid Hendri Uibo ja Silver Simulask esimese kolme mängutaseme sündmusi ning mõlemad mehed nentisid, et inflatsioon avaldab ikka kõvasti mõju. Leiduvat mängijaid, kes absoluutselt iga suvalise kaardiga nuppe lükkavad ning rahast sugugi ei hooli.
"See on seepärast, et raha prinditakse aina juurde. Printerid huugavad ja huugavad," arvab samal turniiril osalev Madis Tarum. "Seepärast ma Bitcoinis istungi," lisab Madis, kes on tavaelus muide tunnustatud crypto-koolitaja :)
22:49 (UTC+2)
Start of Level 4 Blinds: 200/400 Ante: 400
Esimene paus Posted Friday 23rd February, 2024 at 22:32(UTC+2) by maheaaatom
Turniir läks esimesele pausile, mis kestab 15 minutit. Täna on kavas kaks pausi, järgmine neist algab pärast kuuendat mängutaset ehk umbes kell 00:15.
Hetkel tehtud 148 sisseostu, laudades 132 mängijat.
Kuidas lõppes eilne warm-up turniir? Posted Friday 23rd February, 2024 at 22:22(UTC+2) by maheaaatom
Neljapäeval toimunud Kings of Tallinn Warm-Up turniir ei mahu küll otseselt suurfestivali kavasse, kuid olgu tulemused siiski märgitud.
Sisseoste (a 250 €) kogunes 47 ning kaksikvõit läks Soome. Ülejäänud auhinnasaajad olid aga eranditult eestlased - Kert Hallik teenis 1 640, Antti Suursalu 1180, Hendrik Uibo 790 ja Ott Krigul 660 eurot. Abiks ikka.
Otsid riideid ja varustust? Posted Friday 23rd February, 2024 at 22:15(UTC+2) by maheaaatom
Alumisel korrusel (Hiltoni fuajees) saab tavapäraselt osta ka Kings of Tallinn nänni ja riideid. Et hinnad on odavad ja tootevalik lai, siis soovitame sealtki läbi astuda.
350 € CUP kogub hoogu Posted Friday 23rd February, 2024 at 22:12(UTC+2) by maheaaatom
Oleme jõudnud juba 132 sisseostuni ning action toimub nii suures saalis kui ka fuajees. Nagu arvata oligi - Madis Müür on lauas istet võtnud ning mängust osa saamas.
Mängus on ka viiekordne Eesti meister Kert Hallik, nimekad pokkeriprofid Aleksei Smirnov, Martin Piik ja Oskar Ojaveer ning koguni mullusuvisel Summer Showdownil meeleolukat mängu näidanud ja põhiturniiril teiseks tulnud Phil Gross Saksamaalt.
Selgus avaturniiri auhindade jagunemine Posted Friday 23rd February, 2024 at 22:08(UTC+2) by maheaaatom
250 € avaturniirile tehti niisiis kokku 305 sisseostu ning mängijate vahel läheb jagamisele 63 074 eurot auhinnaraha.
See jaguneb 39 parima vahel, min-cash on 480 eurot, võitja teenib 12 174 eurot. Alustuseks päris kena noos!
Hetkel on alles 62 mängijat, nende seas ka näiteks nimekas Eesti naismängija Kairit Leibold.
22:06 (UTC+2)
Start of Level 3 Blinds: 100/300 Ante: 300
Cashile! Posted Friday 23rd February, 2024 at 21:58(UTC+2) by maheaaatom
Neile, kes ei köida niivõrd turniirid kui cashgame, anname teada, et alumine korrus (Olympic Park Casino) on uljaid cashimängijaid täis ning 87 378-eurone Jackpot, mis on tiksunud juba julgelt üle aasta, ootab mahavõtmist.
Kui juhtub ime ja seda tõesti ka Kings of Tallinna ajal maha ei võeta, siis märtsist võib Jackpot tõusta juba üle saja tuhande. Ja ärge unustage, et kätte võib selle saada õige pisikeste blindidega mängides!
Kalle üle pika aja taas pokkerilauas Posted Friday 23rd February, 2024 at 21:49(UTC+2) by maheaaatom
Eestlastest osalejate seas on 2017. aasta EMV põhiturniiri teine mees (see oli siis aasta, mil Rakvere pokkerimängijad kaksikvõidu said, esikoha teenis mõistagi Kristo Erala ise) Kalle Pops.
"Ma pole tõesti kaua mänginud, juba aastaid. Aga Paul (Koppe) kutsus ja mõtlesin, et miks mitte. Paar päeva mängin," räägib Kalle ise. Loodame, et hakkab meeldima.
Kiibitsejate seas on ka hirmkuulus pokkeriäss Madis Müür, kes olla 250 € avaturniiril kaks bulletit õhku lasknud. Kas ta 350 € CUP-iga liitub, pole veel kindel, aga julgeks pakkuda, et tõenäosus on ikka üle 50%.
Reporter pokkerilauas Posted Friday 23rd February, 2024 at 21:37(UTC+2) by maheaaatom
Infoks, et 350 € CUP-ist valmib blogi ainult eesti keeles, kuid järgmistele suurematele turniiridele saavad elada kaasa ka tuhanded inglise- ja soome keelt valdavad pokkerisõbrad.
Meile kõigile hästi tuntud blogitiimi juht Jason on aga juba kenasti Olympic Casinos ning hetkel testimas oma oskusi mängijana 250 € avaturniiril. Tavatsetakse öelda, et isegi kui reporteritel pole piisavalt mängukogemust, siis vähemalt riide on kõvasti. Nüüd on aeg näidata oma oskust neid kasutada!
21:34 (UTC+2)
Start of Level 2 Blinds: 100/200 Ante: 200
Tiimide võistlus! Posted Friday 23rd February, 2024 at 21:30(UTC+2) by maheaaatom
Julgustame kõiki osalejaid registeerima ka oma pokkeritiimi, mida saab teha siin.
Parimate tiimide vahel läheb jagamisele 2% kogu festivali auhinnafondist ning tiimikal osalemine on ilma igasuguse täiendava tasuta. Oma tiimi kirjapanekuks on aega kuni 1. märtsini kell 14:15.
Eestlased on pannud kokku vähemalt kaks tõelist supertiimi:
SOLID PUNTAMENTALS:
Oskar Ojaveer Ranno Sootla Markku Koplimaa Tõnis Viik
TIME
Tarmo Tammel Hendrik Uibo Marius Morel Allan Arjut
Kes on kohal? Posted Friday 23rd February, 2024 at 21:25(UTC+2) by maheaaatom
Eestlastest on juba laudades sügisesel WSOP Cirvuit põhiturniiril kolmandaks tulnud Artur Külanurk, põnev action-mängija Paul Koppe, kõikjale jõudev noor ja perspektiivikas pokkeriproff Hendrik Uibo, kogenud veteranmängija Silver Simulask, eestlastele hästi tuntud Kristjan Maasalu, Virgo Laansoo, Stanislav Smeljov, Dmitri Dudakov, Allan Arjut ja teised.
Teistest turniiridest Posted Friday 23rd February, 2024 at 21:11(UTC+2) by maheaaatom
Niisamuti on suures saalis käimas 250 € Opening Event, mis on osutunud väga populaarseks, sest sisseoste kogunes tervelt 305.
Hetkel on alles 115 parimat ning me lubame, et hoiame ka sel üritusel silma peal, eriti kui on midagi huvitavat rääkida eestlaste käekäigust. Avaturniirile toimus muide täna ka reigivaba satelliit, kuhu kogunes 187 sisseostu.
Hilistele ärkajatele on täna tulemas ka 555 € Championship satelliit, kuhu pääseb mängima 80 euroga. See turniir algab kell 23:00.
350 € CUP on alanud! Posted Friday 23rd February, 2024 at 21:07(UTC+2) by maheaaatom
Kahepäevane turniir on Hiltoni suures saalis alanud, esialgu on laudades 68 mängijat.
Täna mängime 9 taset, igaüks 30 minutit. Lubatud on piiramatu re-entry ning kes täna mängima ei jõua, võib seda teha ka homme, sest ka teise päeva esimese kolme taseme jooksul on lubatud hiline registreerumine.
21:05 (UTC+2)
Day 1 of Kings of Tallinn 2024 Started Level: 1 Blinds: 100/100 Ante: 100
Tere tulemast Kings of Tallinnale! Posted Thursday 22nd February, 2024 at 13:55(UTC+2) by maheaaatom
Reedel, 23. veebruaril algab Olympic Park Casinos regiooni suurim pokkerifestival Kings of Tallinn 2024, mille kavas on 55 turniiri. Läbi OlyBet TV saate lugeda koguni kuue tähtsaima turniiri eestikeelset blogi ning oma lemmikutele kaasa elada. Nendeks:
- 23.02 ja 24.02: Kings of Tallinn Cup 350 € (kaks päeva)
- 25.02 kuni 27.02: Kings of Tallinn Championship 555 € (kolm päeva)
- 27.02: Celebrity Special 150 € (üks päev)
- 28.02 kuni 03.03: Kings of Tallinn põhiturniir (viis päeva)
- 1.03 ja 02.03: Highroller 5000 € (kaks päeva)
- 2.03 ja 03.03: Highroller 3000 € (kaks päeva)
Me alustame ülekannet Olympic Park Casinos ning Hiltoni konverentsisaalist reedel kell 21:00. Seadke vaim valmis ning peatse kohtumiseni!
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.