0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0068 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/jacks_of_june_main_event_2024'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 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.0004 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.0070 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'jacks_of_june_main_event_2024'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '132'
0.0257 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '309'
AND `published` = 1
0.0257 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '310'
AND `published` = 1
0.0258 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '311'
AND `published` = 1
0.0256 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '312'
AND `published` = 1
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '313'
AND `published` = 1
0.0045 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '313'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '132'
AND `name` = '3'
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '313'
ORDER BY `busted` ASC, `current_chips` DESC
0.0046 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` = '313'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '13902'
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` = '13901'
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` = '13896'
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` = '13895'
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` = '13894'
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` = '13893'
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` = '13892'
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` = '13891'
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` = '13890'
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` = '13889'
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` = '13888'
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` = '13887'
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` = '13886'
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` = '13885'
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` = '13884'
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` = '13883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13882'
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` = '13881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13880'
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` = '13879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13876'
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` = '13877'
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` = '13875'
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` = '13874'
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` = '13873'
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` = '13872'
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` = '13871'
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` = '13870'
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` = '13869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13868'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13866'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13865'
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` = '13864'
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` = '13863'
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` = '13862'
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` = '13861'
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` = '13860'
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` = '13859'
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` = '13858'
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` = '13857'
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` = '13856'
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` = '13855'
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` = '13854'
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` = '13853'
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` = '13852'
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` = '13851'
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` = '13850'
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` = '13849'
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` = '13848'
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` = '13846'
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` = '13847'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '309'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '311'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '312'
ORDER BY `busted` ASC, `current_chips` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '313'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '313'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '13902'
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` = '13901'
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` = '13896'
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` = '13895'
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` = '13894'
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` = '13893'
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` = '13892'
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` = '13891'
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` = '13890'
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` = '13889'
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` = '13888'
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` = '13887'
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` = '13886'
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` = '13885'
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` = '13884'
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` = '13883'
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` = '13882'
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` = '13881'
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` = '13880'
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` = '13879'
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` = '13878'
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` = '13876'
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` = '13877'
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` = '13875'
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` = '13874'
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` = '13873'
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` = '13872'
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` = '13871'
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` = '13870'
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` = '13869'
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` = '13868'
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` = '13867'
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` = '13866'
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` = '13865'
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` = '13864'
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` = '13863'
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` = '13862'
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` = '13861'
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` = '13860'
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` = '13859'
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` = '13858'
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` = '13857'
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` = '13856'
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` = '13855'
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` = '13854'
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` = '13853'
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` = '13852'
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` = '13851'
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` = '13850'
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` = '13849'
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` = '13848'
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` = '13846'
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` = '13847'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '313'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2526
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.
Day 3 of Jacks of June Ended Level: 28 Blinds: 40,000/80,000 Ante: 80,000
Ovidijus Berenis Wins OlyBet Vilnius Showdown Jacks of June Main Event (€34,950) Posted Saturday 8th June, 2024 at 11:49(UTC+2) by Jason Glatzer
The buzz was brewing at Olympic Casino Vilnius as Ovidijus Berenis celebrated his victory in the inaugural 2024 OlyBet Vilnius Showdown Jacks of June €555 Main Event after denying Martynas Racinskas yet another big title in Vilnius after shipping the Fisherman’s Challenge in 2020.
Racinskas was in control throughout the final table until heads-up play began when he never held the chip lead. The €555 Main Event not only smashed the €150,000 guarantee but it established a new OlyBet Vilnius Showdown record with 390 entries getting into the mix to create a €187,200 prize pool.
Several other winners were crowned on Friday, including Matas Sabulis, shipping the €80 Low Roller; Yauheni Novik, winning the €250 NLH Friday Deepstack; and Nikita Amosenko, coming out on top in the €150 Friday Mix.
Meanwhile, the €1,100 High Roller already attracted 73 entries on its opening day. The field will grow after it resumes at 1 p.m. on Saturday, as late registration will remain open for the first blind level of the day. You can follow along Day 2 of the High Roller in our dedicated blog.
Ovidijus Berenis Enters Lithuanian Poker History Books
The Main Event was down to just 21 hopefuls on its final day. Martynas Kaulakys began the day with the chip lead and was still near the top of the pack to start the final table after he eliminated Vytautas Kacerauskas on the final table bubble when his eights won a flip against ace-nine suited.
Ovidijus Berenis had a small lead to start the final table, but that quickly changed when Martynas Racinskas won a huge pot with a set of tens against Kaulakys to snag the chip lead, which he held onto in a dominating fashion until heads-up play began.
Racinskas padded his lead by eliminating WSOP bracelet winner Karolis Sereika when his king-queen got there against ace-king before winning a flip with big slick against jacks to eliminate Rokas Skridulis.
Tomas Bassus then eliminated the short-stacked Paulius Mikaliunas before Racinskas was back at it again, eliminating Kaulakys with jack-nine against jack-deuce.
Some drama occurred shortly after when Vitalijus Piskunovas got his stack in with tens and was up against Berenis with queens. A ten spiked the flop but it was Berenis’s rail celebrating at the end as a queen spiked the river to leave just four players remaining.
Berenis’s ladies held shortly after in a different hand against ace-ten to eliminate Bassus and Racinskas’s once unsurmountable chip lead began falling apart. Racinskas doubled Berenis after his king-queen suited was unable to win a flip against jacks. Berenis then doubled against to come close to the chip lead when his pocket rockets were more than good against ace-nine suited.
Shortly after, Berenis delivered a bad beat to Audrius Navickas when his king-queen suited flopped a straight to defeat ace-king.
The duo discussed a deal which they quickly agreed upon guaranteeing both players a €30,000 payout with the winner taking home €34,950.
A hero call decided it at the end. Racinskas bricked his flush draw with ace-six suited with the eight-king-deuce-five-three on the board. He jammed his stack, hoping to get back into the lead if his opponent folded. However, Berenis wasted no time in calling with ace-five suited to win the title and celebrate with his loyal friends on the rail.
Congrats to Ovidijus Berenis on a historic victory at the 2024 OlyBet Vilnius Showdown Jacks of June.
Final Table Payouts of the Jacks of June Main Event Posted Friday 7th June, 2024 at 20:38(UTC+2) by Jason Glatzer
Ovidijus Berenis - €34,950
Martynas Racinskas - €30,000
Audrius Navickas - €17,720
Tomas Bassus - €13,690
Vasilijus Piskunovas - €10,480
Martynas Kaulakys - €8,050
Paulius Mikaliunas - €5,990
Rokas Skridulis - €4,520
Karolis Sereika - €3,400
Martynas Racinskas Eliminated in 2nd Place (€30,000) Posted Friday 7th June, 2024 at 20:32(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 2/390
Martynas Racinskas (pictured below) min-raised the button before he called a three-bet to 600,000 by Ovidijus Berenis.
Both players checked the flop before Berenis led out for 525,000 on the turn. Racinskas tanked for about 30 seconds before he raised to 1,700,000. Berenis quickly called before the river completed the board.
Berenis checked and moments later Racinskas jammed for about 2,700,000. Berenis only paused for about 15 seconds before he made the hero-call of the event.
Racinskas turned over the for a bricked flush draw and he couldn't get Berenis to fold his five with Berenis tabling the to win the Main Event.
Thanks to the deal, Racinskas will take home a cool €30,000, while Berenis won the trophy and the €34,950 top prize.
Stay tuned for a recap on the OlyBet.tv home page on Saturday morning. Until then, good luck to all of the players in the High Roller (which we will be live reporting the final day of tomorrow) and other events at Olympic Casino Vilnius.
Deal Agreed on Break Posted Friday 7th June, 2024 at 20:17(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 2/390
A deal was agreed upon during the break, with both players locking up €30,000. They will still play for another €4,950, with the winner going home with a €34,950 top prize.
Best of luck to both of the heads-up players in their quest to become the inaugural Jacks of June Main Event champion.
Audrius Navickas Eliminated in 3rd Place (€17,720) Posted Friday 7th June, 2024 at 20:06(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 2/390
Ovidijus Berendis opened for 380,000 from the small blind. Audrius Navickas (pictured below) three-bet shoved for about 1.7 million and Berendis called.
Audrius Navickas: Ovidijus Berendis:
Berendis nailed a straight right off the bat with the landing on the flop. He took the chip lead while ending Navickas's impressive run in third place for €17,720 after the turn and river completed the board.
Berendis and Martynas Racinskas took a short break before the start of heads-up play.
Player
Chips
Progress
Ovidijus Berenis
6,860,000
3,560,000
Martynas Racinskas
4,820,000
2,680,000
Audrius Navickas
0
0
Ace-Nine Does the Job for Racinskas Posted Friday 7th June, 2024 at 19:38(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 3/390
Martynas Racinskas min-raised the button and was called by Ovidijus Berenis from the small blind. Berenis check-called a bet of 125,000 on the flop before both players checked the turn.
Berenis checked again on the river. Racinskas fired out for 650,000 and Berenis found a call.
"Nice hand," Berenis said to Racinskas after his opponent tabled .
Berenis mucked his hand before the pot was delivered to Racinskas.
Player
Chips
Progress
Martynas Racinskas
7,500,000
1,500,000
Ovidijus Berenis
3,300,000
1,300,000
19:11 (UTC+2)
Start of Level 28 Blinds: 40,000/80,000 Ante: 80,000
Berenis Soaring With Rockets Posted Friday 7th June, 2024 at 19:09(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 3/390
Ovidijus Berenis opened the button for 125,000. Audrius Navickas called from the small blind before Martynas Racinskas three-bet jammed his massive stack from the big blind.
Berenis snap-called while Navickas's cards quickly went into the muck.
Ovidijus Berenis: Martynas Racinskas:
Berenis's rail has grown, and they all gathered near the table to witness his double-up after his rockets were good on the board.
Player
Chips
Progress
Martynas Racinskas
6,000,000
1,500,000
Ovidijus Berenis
4,600,000
2,000,000
Berenis Doubles With Jacks Posted Friday 7th June, 2024 at 19:01(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 3/390
Martynas Racinskas opened the button for 125,000. Ovidijus Berenis (pictured below) three-bet jammed for 1,240,000 from the small blind. Racinskas called, and Berenis was flipping to stay alive.
Ovidijus Berenis: Martynas Racinskas:
Jacks were good on the runout for Berenis to double his stack instead of hitting the rail.
Player
Chips
Progress
Martynas Racinskas
7,500,000
1,250,000
Ovidijus Berenis
2,600,000
1,250,000
Short Break Posted Friday 7th June, 2024 at 18:49(UTC+2) by Jason Glatzer
The final three players opted to take their break a little early. Here is a look at the chip counts at the unscheduled break with Martynas Racinskas still holding the majority of the chips in play. The scheduled break in 15 minutes will be pushed back.
Player
Chips
Progress
Martynas Racinskas
8,750,000
750,000
Audrius Navickas
1,550,000
550,000
Ovidijus Berenis
1,350,000
350,000
Tomas Bassus Eliminated in 4th Place (€13,690) Posted Friday 7th June, 2024 at 18:43(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 3/390
Ovidijus Berenis jammed for 750,000 from under the gun. Tomas Bassus (pictured below) called off his three big blind stacks from the small blind, and the cards were tabled.
Tomas Bassus: Ovidijus Berenis:
Queens held on the board to eliminate Bassus in fourth place for €13,690.
Player
Chips
Progress
Ovidijus Berenis
1,000,000
0
Tomas Bassus
0
0
Two Pair for Racinskas Posted Friday 7th June, 2024 at 18:38(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 4/390
It's been all Martynas Racinskas (pictured below) ever since he took over the chip lead early in the final table, and now he has around two-thirds of the total chips in play. He recently took a decent pot off of Ovidijus Berenis as follows.
Berenis min-raised from under the gun before Racinskas defended his big blind. Berenis continued for 125,000 on the flop, and Racinskas check-called.
Racinskas bet 200,000 on the turn and 450,000 on the river. Berenis called both times only to muck his hand after Racinskas tabled for two pair to win the hand.
Player
Chips
Progress
Martynas Racinskas
8,000,000
2,500,000
Ovidijus Berenis
1,000,000
1,300,000
Everyone Loves a Chop Posted Friday 7th June, 2024 at 18:31(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 4/390
There hasn't been a ton of action since the last elimination. However, recently, there was an all-in and a call.
Tomas Bassus three-bet shoved his nine big blind stack and was called by Audrius Navickas.
Both players held , and no suited magic happened for either player on the runout, resulting in a chopped pot.
Player
Chips
Progress
Audrius Navickas
1,000,000
700,000
Tomas Bassus
500,000
1,000,000
17:58 (UTC+2)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Vasilijus Piskunovas Eliminated in 5th Place (€10,480) Posted Friday 7th June, 2024 at 17:43(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 4/390
It appears Level 26 is the level of players hitting the rail at the final table. Vasilijus Piskunovas (pictured below) was the latest to exit in fifth place for €10,480 on a rollercoaster of a hand.
Martynas Racinskas min-raised from under the gun before Piskunovas three-bet shoved for about 500,000. Ovidijus Berenis jammed for about three times more from the button, and Racinskas quickly got out of the way.
Vasilijus Piskunovas: Ovidijus Berenis:
Piskunovas improved to Yahtzee on the flop. His full house was still good on the turn but Berenis improved to a better full house after the river completed the board.
Player
Chips
Progress
Ovidijus Berenis
2,300,000
200,000
Vasilijus Piskunovas
0
0
Martynas Kaulakys Eliminated in 6th Place (€8,050) Posted Friday 7th June, 2024 at 17:29(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 5/390
The start of Day 3 chip leader Martynas Kaulakys (pictured below) was down to slightly more than four big blinds when he three-bet his stack in facing the open by chip leader Martynas Racinskas.
Martynas Kaulakys: Martynas Racinskas:
Racinskas won the battle of the Martynas's with a pair of nines after the ran out on the board.
Kaulakys collected a tasty €8,050 payout, and the final five players secured at least a five-figure cash payout of €10,480.
Player
Chips
Progress
Martynas Racinskas
5,500,000
800,000
Martynas Kaulakys
0
0
Paulius Miakliunas Eliminated in 7th Place (€5,990) Posted Friday 7th June, 2024 at 17:25(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 6/390
Paulius Mikaliunas min-raised with just a single 5K chip back from the hijack and was called by Tomas Bassus from the button. Mikaliunas checked the flop before putting his last chip in, facing a bet by Bassus.
Paulius Mikaliunas: Tomas Bassus:
Mikaliunas could not improve on the turn or the river and was eliminated in seventh place for €5,990. The final six players now locked up at least a €8,050 payout.
Player
Chips
Progress
Tomas Bassus
1,500,000
0
Paulius Mikaliunas
0
0
Navickas Wins a Flip Posted Friday 7th June, 2024 at 17:19(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 7/390
Audrius Navickas (pictured below) three-bet jammed for 825,000 and was called by Martynas Kaulakys.
Audrius Navickas: Martynas Kaulakys:
Kaulakys's newly found chips went over to Navickas after his opponent improved to two pair on the runout.
Player
Chips
Progress
Audrius Navickas
1,700,000
900,000
Martynas Kaulakys
300,000
800,000
"Don't Write About This" Posted Friday 7th June, 2024 at 17:17(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 7/390
Martynas Kaulakys jammed for a little more than 10 big blinds from the small blind and was called by Paulius Mikaliunas.
Martynas Kaulakys: Paulius Mikaliunas:
Mikaliunas was nearly drawing dead after Kaulakys improved to a full house on the flop. Kaulakys doubled up officially after the turn and river completed the board.
"Don't write about this," Kaulakys joked. "Say it was someone else."
Player
Chips
Progress
Martynas Kaulakys
1,100,000
580,000
Paulius Mikaliunas
125,000
575,000
16:56 (UTC+2)
Start of Level 26 Blinds: 25,000/50,000 Ante: 50,000
Chip Counts at Break Posted Friday 7th June, 2024 at 16:49(UTC+2) by Jason Glatzer
Player
Chips
Progress
Martynas Racinskas
4,700,000
1,100,000
Ovidijus Berenis
2,100,000
25,000
Tomas Bassus
1,500,000
150,000
Vasilijus Piskunovas
1,200,000
25,000
Audrius Navickas
800,000
300,000
Paulius Mikaliunas
700,000
130,000
Martynas Kaulakys
520,000
30,000
Rokas Skridulis Eliminated in 8th Place (€4,520) Posted Friday 7th June, 2024 at 16:47(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 7/390
On the final hand before the break, Rokas Skridulis (pictured below) opened from late position before Martynas Racinskas three-bet jammed. Skridulis called off for around 20 big blinds and he was flipping for either a big stack or nothing at all.
Rokas Skridulis: Martynas Racinskas:
Big slick got there on the river on the runout for Racinskas to eliminate back-to-back players at the final table.
The final seven players headed on a 15-minute break after the hand.
Player
Chips
Progress
Rokas Skridulis
0
0
Karolis Sereika Eliminated in 9th Place (€3,400) Posted Friday 7th June, 2024 at 16:14(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 8/390
WSOP bracelet winner Karolis Sereika (pictured below) was the first player out at the final table after a bad beat as follows.
Sereika min-raised from under the gun before Martynas Racinskas three-bet to 200,000 from the button. Sereika four-bet shoved for about 550,000 and Racinskas snap-called.
Karolis Sereika: Martynas Racinskas:
Racinskas improved to two pair on the runout to push his king-queen ahead of Sereika's big slick.
Sereika collected €3,400 for his ninth-place performance with the final eight players locking up at least €4,520.
Player
Chips
Progress
Martynas Racinskas
3,600,000
400,000
Karolis Sereika
0
0
Quiet Blind Level Posted Friday 7th June, 2024 at 16:05(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 9/390
The early portions of Level 25 have been quiet, with no notable showdowns thus far. Everyone at the table appears to have a decent understanding of ICM, but appearances can be deceiving.
15:44 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Racinskas Takes Lead With Set of Tens Posted Friday 7th June, 2024 at 15:40(UTC+2) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 9/390
Martynas Racinskas (pictured below) is off to a hot start at the final table. He just won a massive hand against Martynas Kaulakys.
Racinskas opened for 60,000 from middle position and was called by Kaulakys from the button. There was some small action on the flop with Racinskas check-calling a bet of 55,000.
Another check came by Racinskas on the turn. Kaulakys bet 75,000. Racinskas raised to 275,000 and Kaulakys quickly called.
Racinskas came in big for a bet of 750,000 on the river. Kaulakys quickly called.
"Nice hand," said Kaulakys to Racinskas after his opponent turned over the for a set of tens to win the pot and take the overall chip lead.
Player
Chips
Progress
Martynas Racinskas
3,200,000
1,675,000
Martynas Kaulakys
550,000
1,415,000
Final Table Chip Counts Posted Friday 7th June, 2024 at 15:04(UTC+2) by Jason Glatzer
Player
Chips
Progress
Ovidijus Berenis
2,075,000
75,000
Martynas Kaulakys
1,965,000
665,000
Martynas Racinskas
1,525,000
25,000
Tomas Bassus
1,350,000
0
Vasilijus Piskunovas
1,175,000
45,000
Rokas Skridulis
1,140,000
160,000
Audrius Navickas
1,100,000
185,000
Karolis Sereika
760,000
80,000
Paulius Mikaliunas
570,000
60,000
Final Table Reached After Bartuschk and Kacerauskas Eliminated Posted Friday 7th June, 2024 at 14:54(UTC+2) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 9/390
The final table was reached in very quick fashion with two players out within the matter of minutes. Fabian Bartuschk jammed his unsuccessfully into , and was on the rail after the ran out on the board.
Shortly after, Vytautas Kacerauskas (pictured below) followed when he jammed his into the held by Martynas Kaulakys. He lost the flip to bubble the final table after getting nowhere on the runout.
Stay tuned for the final table chip counts as players head on a short break.
Player
Chips
Progress
Fabian Bartuschk
0
0
Vytautas Kacerauskas
0
0
End of Line for Subashi Posted Friday 7th June, 2024 at 14:51(UTC+2) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 11/390
Enea Subashi jammed for 205,000 from the button and was called by Tomas Basus from the big blind.
Enea Subashi: Tomas Bassus:
Subashi had two live cards but his impressive Main Event run was over in 12th place after the ran out on the board.
Player
Chips
Progress
Tomas Bassus
1,350,000
125,000
Enea Subashi
0
0
Navickas Doubles Again Posted Friday 7th June, 2024 at 14:38(UTC+2) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 12/390
Martynas Kaulakys min-raised from the hijack. Audrius Navickas jammed for 420,000 from the button. Kaulakys asked for a count before he called a short while later.
Audrius Navickas: Martynas Kaulakys:
Navickas let out a small cheer of joy after his ace-ten held on the runout.
Player
Chips
Progress
Martynas Kaulakys
1,300,000
400,000
Audrius Navickas
915,000
420,000
Navickas Sits Back Down Posted Friday 7th June, 2024 at 14:28(UTC+2) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 12/390
Audrius Navickas (pictured below) jammed the button for 7 big blinds and was called by Karolis Sereika from the button.
Audrius Navickas: Karolis Sereika:
Navickas stood up and looked ready to go after getting nowhere on the flop. The turn didn't turn the tides. However, Navickas connected with his ten on the river to retake his chair with a bigger stack.
Player
Chips
Progress
Karolis Sereika
840,000
60,000
Audrius Navickas
495,000
285,000
14:21 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Berenis Leads at Break Posted Friday 7th June, 2024 at 14:14(UTC+2) by Jason Glatzer
Ovidijus Berenis took the lead after his big hand to eliminate Rytis Sandaras with rockets. Check out the full chip counts at the break below:
Player
Chips
Progress
Ovidijus Berenis
1,735,000
235,000
Martynas Kaulakys
1,700,000
500,000
Martynas Racinskas
1,500,000
810,000
Rokas Skridulis
1,300,000
100,000
Tomas Bassus
1,225,000
125,000
Vasilijus Piskunovas
1,130,000
500,000
Karolis Sereika
900,000
100,000
Vytautas Kacerauskas
600,000
100,000
Paulius Mikaliunas
510,000
15,000
Enea Subashi
410,000
615,000
Fabian Bartuschk
300,000
290,000
Audrius Navickas
210,000
440,000
First Break Posted Friday 7th June, 2024 at 14:06(UTC+2) by Jason Glatzer
Players are on their first break of the final day. Blinds will increase to 15,000/30,000 with a 30,000 big blind ante before heading into 20,000/40,000 with a 40,000 big blind ante.
The event will likely reach a final table before the next break. Stay tuned for the full chip counts of the final dozen players at the break.
Peachy Ladies for Mikaliunas Posted Friday 7th June, 2024 at 14:04(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 12/390
Ovidijus Berenis min-raised from the hijack before he called a three-bet jam for 225,000 by Paulius Mikaliunas (pictured below) from the button.
Paulius Mikaliunas: Ovidijus Berenis:
Mikaliunas's ladies held on the board to stay alive and gain some breathing room.
Player
Chips
Progress
Ovidijus Berenis
1,500,000
300,000
Paulius Mikaliunas
525,000
300,000
Second Sandaras Brother on the Rail Posted Friday 7th June, 2024 at 14:01(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 12/390
Rytis Sandaras (pictured below) opened for 300,000 from middle position with just a couple of chips back. Ovidijus Berenis called from the cutoff before Rokas Skridulis came along for the ride from the button.
Sandaras checked the flop. Berenis jammed for more than 700,000. Skridulis went into the tank for a couple of minutes before he folded, while Sandaras called a few moments later.
Rytis Sandaras: Ovidijus Berenis:
Aces were far ahead, and Sandaras was on the rail in 13th place after the turn and river completed the board.
Player
Chips
Progress
Ovidijus Berenis
1,800,000
700,000
Rokas Skridulis
1,200,000
550,000
Rytis Sandaras
0
0
Simultaneous Doubles by Kacerauskas and Berenis Posted Friday 7th June, 2024 at 13:55(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 13/390
There were all-ins and calls on both tables at the same time. Vytautas Kacerauskas (pictured below) three-bet jammed from the big blind and was called by Karolis Sereika, who originally opened from under the gun.
Vytautas Kacerauskas: Karolis Sereika:
Kacerauskas's big slick won the flip to double his stack after the ran out on the board.
At the same time, Ovidijus Berenis (pictured below) got a bit lucky as he jammed the button for 21 big blinds and was called by Paulius Mikaliunas.
Mikaliunas was a gentleman and said "nice hand" despite the bad beat Berendis delivered to cut into Mikaliunas's stack in a huge way after the ran out on the board.
Player
Chips
Progress
Ovidijus Berenis
1,100,000
215,000
Karolis Sereika
1,000,000
0
Vytautas Kacerauskas
700,000
200,000
Paulius Mikaliunas
225,000
600,000
Maciukas Bricks His Draws Posted Friday 7th June, 2024 at 13:49(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 13/390
Rokas Skridulis opened from middle position before Marius Maciukas defended his big blind.
Maciukas checked the flop before Skridulis bet 45,000. Maciukas jammed for approximately 200,000, and Maciukas snap-called.
Marius Maciukas: Rokas Skridulis:
Maciukas had an open-ended straight draw, and his jack and ten were also live. He bricked all of these outs after the turn and river completed the board to leave a baker's dozen left in the Main Event.
Player
Chips
Progress
Rokas Skridulis
1,750,000
580,000
Marius Maciukas
0
0
Aakesson Loses Short Stack to Mikaliunas Posted Friday 7th June, 2024 at 13:25(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 14/390
Johan Aakesson (pictured below) jammed for 290,000 from early position before Paulius Mikaliunas three-bet shoved for more than 500,000 from late position. The rest of the table folded and the cards were tabled.
Johan Aakesson: Paulius Mikaliunas:
Mikaliunas was already ahead when the chips went in, and "good games" were exchanged after Mikaliunas's paired-up queen did the job to eliminate Aakesson on the board.
Player
Chips
Progress
Paulius Mikaliunas
825,000
350,000
Johan Aakesson
0
0
13:04 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Queen-Eight No Good for Kuzmicius Posted Friday 7th June, 2024 at 13:03(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 15/390
Vitalijus Kuzmicius (pictured below) jammed his short stack from under the gun with and was called by Martynas Kaulakys from late position with .
Kuzmicius was drawing dead straight off the bat after Kaulykas improved to trips with two aces on the flop.
The action was down to just 15 hopefuls with six players hitting the rail during the opening blind level of Day 3.
Player
Chips
Progress
Martynas Kaulakys
2,200,000
225,000
Vitalijus Kuzmicius
0
0
Sereika Doubles Racinskas Posted Friday 7th June, 2024 at 12:59(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 16/390
Karolis Sereika min-raised from the cutoff before Martynas Racinskas (pictured below) three-bet jammed for 320,000. Sereika tossed in a chip to call before the players tabled their cards.
Martynas Racinskas: Karolis Sereika:
Ace-queen was good enough for Racinskas to double against ace-jack on the runout.
Player
Chips
Progress
Karolis Sereika
1,000,000
200,000
Martynas Racinskas
690,000
300,000
Sandaras Runs Into Bassus's Rockets Posted Friday 7th June, 2024 at 12:40(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 16/390
Tomas Bassus opened for 45,000 from under the gun before Aistis Sandaras (pictured below) three-bet to 255,000 with just 15,000 behind from the small blind. Bassus called before putting his opponent in on the flop for the rest of his stack.
Aistis Sandaras: Tomas Bassus:
Sandaras was on the rail after the turn and river completed the board and the action was down to just two tables of players which including Aistis's brother, Rytis Sandaras.
Player
Chips
Progress
Tomas Bassus
1,100,000
400,000
Aistis Sandaras
0
0
Navickas Wins a Flip Against Mikaliunas Posted Friday 7th June, 2024 at 12:32(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 17/390
Audrius Navickas (pictured below) three-bet jammed the button for more than a dozen big blinds and was called by Paulius Mikaliunas, who opened from the button.
Audrius Navickas: Paulius Mikaliunas:
Navickas won the flip to double his stack after connecting with his queen on the runout.
Player
Chips
Progress
Audrius Navickas
650,000
245,000
Paulius Mikaliunas
475,000
325,000
Mikaliunas Delivers Bad Beat to Felt Jurgutis Posted Friday 7th June, 2024 at 12:30(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 17/390
Edikas Jurgutis three-bet most of short stack from the small blind. Paulius Mikaliunas, who earlier doubled through Enea Subashi while others were all-in at another table, put him in for the rest.
Edikas Jurgutis: Paulius Mikaliunas:
Mikaliunas delivered a bad beat to eliminate Jurgutis after his four connected on the runout to leave just 17 remaining in the field.
Player
Chips
Progress
Paulius Mikaliunas
800,000
545,000
Edikas Jurgutis
0
0
Asipauskas Runs Suited Connectors Into Sereika's Set of Ladies Posted Friday 7th June, 2024 at 12:19(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 18/390
Rokas Asipauskas (pictured below) jammed the button for six big blinds, and was called by WSOP bracelet winner Karolis Sereika.
Rokas Asipauskas: Karolis Sereika:
Asipauskas was called for a seven after the turn, but Sereika's dominating hand held after the ran out on the board to leave just 18 players remaining in the field.
Player
Chips
Progress
Karolis Sereika
1,200,000
220,000
Rokas Asipauskas
0
0
Big Slick No Good for Laurinaitis Posted Friday 7th June, 2024 at 12:16(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 19/390
Tomas Bassus opened the button before he called a three-bet jam by Vytautas Laurinaitis (pictured below) from the small blind for about 10 big blinds. Bassus snap-called, and Laurinaitis was flipping for his tournament life.
Vytautas Laurinaitis: Tomas Bassus:
"Yes," said Bassus after he eliminated Laurinaitis after the ran out on the board.
Player
Chips
Progress
Tomas Bassus
700,000
260,000
Vytautas Laurinaitis
0
0
Vinicenka First to the Rail on Final Day Posted Friday 7th June, 2024 at 12:08(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 20/390
Stanislovas Vinicenka was the first player to hit the rail on the final day in the opening moments of Level 22.
Vinicenka jammed for six big blinds from the hijack and was called by Vytautas Kacerauskas from the big blind.
Stanislovas Vinicenka: Vytautas Kacerauskas:
Kacerauskas was ahead and further improved to a set to take all of Vinicenka's chips after the ran out on the board.
Player
Chips
Progress
Vytautas Kacerauskas
500,000
165,000
Stanislovas Vinicenka
0
0
Cards in the Air Posted Friday 7th June, 2024 at 12:02(UTC+2) by Jason Glatzer
Cards are in the air to start the final day of the Main Event. Best of luck to all of the players.
Who Will Win the Jacks of June Main Event on Friday Posted Friday 7th June, 2024 at 11:04(UTC+2) by Jason Glatzer
The Olybet Vilnius Showdown Jacks of June €555. Main Event witnessed players battle for nine blind levels of one hour each on Thursday, with the action ending with just 21 hopefuls set to battle on Friday’s final day, with the action recommencing on Friday at 12 p.m. with blinds at 10,000/20,000 and a 20,000 big blind ante.
Local hero Martynas Kaulakys (pictured above) will kick off the action with a substantial chip-leading stack of 1,975,000 after ending the day picking off chips from his opponents. Two other players are chip millionaires to start Day 2, including Lithuania’s Rokas Skridulis (1,170,000) and Greece’s Enea Subashi (1,025,000).
Just three players in the field wave flags outside the home country of Lithuania, and all are in the top 10. In addition to Subashi, Germany’s Fabian Bartuschk (590,000) and Sweden’s Johan Aakesson (490,000) hope to deny the Lithuanian poker community yet another big title on their home soil.
Meanwhile, a pair of brothers are in the mix with the start of Day 2 chip leader Rytis Sandaras bagging up 555,000 and his brother Aistis Sandaras bringing in one of the shorter stacks with 320,000.
WSOP bracelet winner Karolis Semeika is hoping to add a local title to his impressive poker resume with a fourth-place stack of 980,000 while many other popular players are still in the mix, including Ovidijus Berenes (885,000), Vasilijus Piskunovas (630,000), Tomas Bassus (440,000), 2020 Fisherman Challenge Main Event champion Martynas Racinskas (390,000), Vitalijus Kuzmicius (385,000), Vytautas Kacerauskas (335,000), Paulius Mikaliunas (255,000), and Stanlislovas Vinicenka (140,000).
Our blog will recommence at 12 p.m. on Friday, and you can follow along the action until a winner is crowned. Best of luck to the final 21 players on Friday!
Final Day Seat Draw Posted Friday 7th June, 2024 at 00:20(UTC+2) by Jason Glatzer
Day 3 of Jacks of June Started Level: 22 Blinds: 10,000/20,000 Ante: 20,000
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.