0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-dev`

0.0185 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-27'
AND `url` = 'https://dev.maineventtravel.com/live-reporting/bom-main-event/1C/payouts'
ORDER BY `views` DESC

0.0315 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-04-27'
AND `url` = 'https://dev.maineventtravel.com/live-reporting/bom-main-event/1C/payouts'

0.0003 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.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` = 'dev.maineventtravel.com'

0.0003 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` = 'dev.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` = 'dev.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.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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0025 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` = 'bom-main-event'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'

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

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '4'
AND `published` = 1

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '5'
AND `published` = 1

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '7'
AND `published` = 1

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '9'
AND `published` = 1

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '10'
AND `published` = 1

0.0009 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '11'
AND `published` = 1

0.0008 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '12'
AND `published` = 1

0.0001 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '1'
AND `name` = '1C'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1231
  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found
English
Battle of Malta 2019 Main Event Live Reporting - Day 4
Current Level 37 Current Day 4
Blinds 400,000/800,000 Ante 800000
Entries 4,657 Remaining 1
Prize Pool (EUR) €2,258,645 First Prize (EUR) €306,205
Day 1A Day 1B Day 1C Day 1D Day 1E Day 2 Day 3 Day 4
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Payouts
Place Player Prize (EUR)
1 Serghei Lisii €247,167
2 Steven van Zadelhoff €217,167
3 Josef Gulas €102,050
4 Colum Higgins €74,540
5 Leo Dominic Worthington-Leese €56,470
6 Rune Moerk €42,910
7 Bruno Massimo €33,880
8 Shaun De Cesare €27,100
9 Flavio Laudani €24,620
10 Valerii Firstenko €22,360
11 Vincenzo Pinna €22,360
12 Ahn Byungwook €20,100
13 Antonio Alba €20,100
14 Brenseth Terje Humio €17,840
15 Larsson Lars Greger €17,840
16 Gabriele Re €15,580
17 Gabriele Re €15,580
18 Faraj Abraham Benitez €13,330
19 Renato Messina €13,330
20 Oskar Szwed €13,330
21 Fabio Frusca €11,070
22 Gal Halevi €11,070
23 Johan Goslings €11,070
24 Melech Prozan €8,810
25 Giovanni Russo €8,810
26 Grella Enrico €8,810
27 Cedric Schwaederle €7,230
28 Anastasakis Dimitrios €7,230
29 Massimo Scioschia €7,230
30 Marc Schembri €7,230
31 Bona Marcello €7,230
32 Dwayne Sluis €7,230
33 Ongorur Mehmet Sirin €7,230
34 Boris Chertin €7,230
35 Charalampos Lappas €7,230
36 Yair Hagai Ben €5,650
37 Tiziano Di Romualdo €5,650
38 Braco Pasquale €5,650
39 Marek Poldroos €5,650
40 Hassan Sey €5,650
41 Yohann Soldan €5,650
42 Gasparr FRsco €5,650
43 Niwa Ichiyo €5,650
44 Rafael Zuzic €5,650
45 Mammides Efthymios €4,070
46 Montagna Salvatore €4,070
47 Dehlia de Jong €4,070
48 Niko Pakalen €4,070
49 Alexandra Niculae €4,070
50 TAMM VIRGO €4,070
51 Vytenis Salickas €4,070
52 Csaba Kovacs €4,070
53 Lohunko Sebastian Tomasz €4,070
54 Alonso Mike Georges €3,160
55 Karl Fredrik Ellingsson €3,160
56 Paul Andre Guichard €3,160
57 Arvydas Merfeldas €3,160
58 Petros Theodosiou €3,160
59 Mohammed Sohel €3,160
60 Ludovic Geilich €3,160
61 Marco Paolo Scalia €3,160
62 Giuseppe Grimaldi €3,160
63 Cristea Valentin-Marius €2,710
64 David Hudson €2,710
65 Leo Jean Jaques Adrien Lombardozzi €2,710
66 Ugo Giuseppe Gasparini €2,710
67 Mirco Arico €2,710
68 Mirco Ferrini €2,710
69 Andrew Middleton €2,710
70 Miroslav Prasil €2,710
71 Nitsan Perets €2,710
72 Ovidiu-Dorin Barna €2,710
73 Pedro Ivars Domenech €2,710
74 Nebojsa Bulatovic €2,710
75 Aidan Paul Hynes €2,710
76 ULTVEDT CHRISTOFFER €2,710
77 Louis Karam €2,710
78 Andre Scerri €2,710
79 Paolo Infantino €2,710
80 Carlos Martinez Casero €2,710
81 Maksims Azarjancs €2,480
82 VICTOR FEU GONZALEZ €2,480
83 Giorgio Colombo €2,480
84 Sander Klomp €2,480
85 Evgenii Margolin €2,480
86 John Cahill €2,480
87 Mats Gustav Villern Karlsson €2,480
88 Neoklis Konstantinou €2,480
89 TREVOR HOWARD €2,480
90 Mario Ripepi €2,480
91 Andrea Mussumarra €2,480
92 Mr Walter Lustenberger €2,480
93 Daniele Degennaro €2,480
94 Kirmo Karri Kolehmainen €2,480
95 Marc Jan Mijnheer €2,480
96 Ondrej Jakubcik €2,480
97 Catalin Geangos €2,480
98 MART RINKEN €2,480
99 Terence Lee Etim €2,260
100 Ricardo Manuel Freire Mateus €2,260
101 Mr Karim Aouam €2,260
102 Giuseppe Salvatore Di Bella €2,260
103 Gianluca Fichera €2,260
104 Daragh Davey €2,260
105 Luca Bufarini €2,260
106 Alain Pascal Riss €2,260
107 Dario Guarnuto €2,260
108 Jacob Dideriksen-Nielsen €2,260
109 Hans Kaspar Schmid €2,260
110 Maurizio Cola €2,260
111 Marius Negucioiu €2,260
112 Borislav Tonev Shishkov €2,260
113 Andrea Piazza €2,260
114 Daria Antonova €2,260
115 SEBASTIAN WHAL €2,260
116 Agostino Nasso €2,260
117 Jeffrey Bar-Esh €2,260
118 David Kolaric €2,260
119 Salvatore Amitrano €2,260
120 Ignazio D'angelo €2,260
121 Kieran Patrick Coone €2,260
122 Jelmer Schuurmans €2,260
123 David Lund €2,260
124 Ignazio Ulma €2,260
125 Giovanni Calderone €2,260
126 Michael Albert Schwartz €2,150
127 Oscar Chica Quintero €2,150
128 Yotam Bar-Yosef €2,150
129 Alan John Linker €2,150
130 Domenico Gala €2,150
131 Niklas Magnus Aahlund €2,150
132 Mr Angel Georgiev Dimitrov €2,150
133 Yordy R Bakker €2,150
134 Jonas Gunnar Broden €2,150
135 Juris Hlibovs €2,150
136 Alberto Santoro €2,150
137 Alberto Cigliano €2,150
138 Chatzi Elvis-Nikolaos €2,150
139 Krzysztof Andrzej Preggowski €2,150
140 Tom Deschuytter €2,150
141 Thomas John Reilly €2,150
142 Andreas Klatt €2,150
143 BASTOW FRANK €2,150
144 PAUL SPILLANE €2,150
145 Mr Pedro Santos Borba €2,150
146 Henrik Christer Johansson €2,150
147 Orazio Arena €2,150
148 Trevor John Bulless €2,150
149 Endrit Geci €2,150
150 Michele Tocci €2,150
151 Grigoris Kyriazi €2,150
152 Neville Grech €2,150
153 Dario Amato €2,030
154 Kuhnel Gordon €2,030
155 Jorgji Kotorri €2,030
156 SALVATORE MOTTA €2,030
157 Sirus Norozi €2,030
158 Alessandro Barone €2,030
159 ADAM WOJCIESZAK €2,030
160 Amit Cohen €2,030
161 Emiliano Papotto €2,030
162 Benyamin Glot €2,030
163 Sotiriou Nikos €2,030
164 Jari Juhani Lahtinen €2,030
165 Tanel Velli-Vaellik €2,030
166 Patrick Ignatius Clarke €2,030
167 Mugurel Fracas €2,030
168 Lorentzo Boci €2,030
169 Georgios Kapalas €2,030
170 Maya Geller €2,030
171 Gabriele Zappala €2,030
172 Esben Myrup €2,030
173 Geb. Mushold Nell €2,030
174 Sirile Puustusmaa €2,030
175 Rares-Grigorut Muresan €2,030
176 Omar Mansour Bouferra €2,030
177 Sofia Madsen €2,030
178 Carmelo Osman €2,030
179 Simon Anthony Forster €2,030
180 Vasileios Panagiotou €1,920
181 Cristian-Mugurel Tamas €1,920
182 Tonio Marek Roeder €1,920
183 Matthew Ross Adams €1,920
184 Odd Inge Hurlen €1,920
185 Fabrizio Privitera €1,920
186 Nunzio Isgro €1,920
187 Fabio Albamonte €1,920
188 Zoltan Blaskovics €1,920
189 Cristiano Ruiu €1,920
190 Vikrum Mehta €1,920
191 Pavlos Xanthopoulos €1,920
192 Peter Warfvinge €1,920
193 Marco Bartolini €1,920
194 Massimo Caratelli €1,920
195 Antonello Ferraiuolo €1,920
196 Rastislav Paleta €1,920
197 Neil Peter George Barron €1,920
198 Zoltan Barabas €1,920
199 Alexandre Albert Henry €1,920
200 Edward James Overall €1,920
201 Sven Aage Lysebo €1,920
202 Tsvetelina Pavlova €1,920
203 David Ismail Peer €1,920
204 Mario Di Natale €1,920
205 Lucas Ake Johannes Stenius €1,920
206 Giovanni Catalfamo €1,920
207 Paolo Litrico €1,920
208 Giuseppe Pantaro €1,920
209 Gediminas Cizauskas €1,920
210 Ronny Gresmo €1,920
211 Philip Edward Wing €1,920
212 Alex Iannello €1,920
213 Piotr Przybylski €1,920
214 Maurizio Romano €1,920
215 Mario Giannoni €1,920
216 Cristiano Longo €1,810
217 Yaakov Ben Shlomo €1,810
218 Chris Ayojide Da-Silva Oduntan €1,810
219 Fabio Rubino €1,810
220 Flaviano Cammisuli €1,810
221 Mark Adams €1,810
222 Idan IL Raz €1,810
223 Sebastian Tusal Nieto-Sandoval €1,810
224 Mr Adam Philip Lowe €1,810
225 Petr Tiurin €1,810
226 Serdar Demircan €1,810
227 Chorianopoulos Ioannis €1,810
228 Ronnie Ballantyne €1,810
229 Tanel Evert €1,810
230 FRsco Ruffo €1,810
231 Madis Ormisson €1,810
232 Andres Fernandez Vinxxas €1,810
233 Micheal Runza €1,810
234 Alari Raid €1,810
235 Alexandr Lebedev €1,810
236 Feliciano Montalbetti €1,810
237 Jason Roberts €1,810
238 Tindaro Candido €1,810
239 Janne Marko Johannes Siljamaki €1,810
240 Vladimir Bednar €1,810
241 Ponomarev Nikolay €1,810
242 Domenico Pino €1,810
243 Johan Pontus Kers €1,810
244 Mr Cuneyt Laurent Sengun €1,810
245 Sofia Lovgern €1,810
246 Gavril Daniel Hutuleac €1,810
247 Gaetano Ricciardi €1,810
248 Davide Bellomonte €1,810
249 Michele Fratini €1,810
250 Reuven Erez Zohar €1,810
251 Craig Young €1,810
252 Tim Maximilian Beyer €1,720
253 Anthony Derek Gardner €1,720
254 Daniel Lakerveld €1,720
255 Daniel Edward Myers €1,720
256 Giuseppe Verderico €1,720
257 Stephen Spiteri €1,720
258 Liutauras Armanavicius €1,720
259 Marco Di Persio €1,720
260 Elias Assaf €1,720
261 Patel Priti €1,720
262 Alessandro Pichierri €1,720
263 Soffer Efi €1,720
264 Mr Giuseppe Drogo €1,720
265 Jonathan Therme €1,720
266 Dario Marinelli €1,720
267 Vladas Burneikis €1,720
268 Massimiliano Rosi €1,720
269 Shane Dempsey €1,720
270 Laurentiu Avram €1,720
271 Lucio Bernardo €1,720
272 Domenico Tortomasi €1,720
273 Clint Sammut €1,720
274 Lars John Torvald Magnusson €1,720
275 Mario Antonio Fontana €1,720
276 Jaakko Rantanen €1,720
277 Yosi Dolev €1,720
278 Georgy Sukhiy €1,720
279 Mr Lars-Aake Olsson €1,720
280 Keimo Suominen €1,720
281 Romain Patrick Sebastien Nardin €1,720
282 Massimo Antonino Scaletta €1,720
283 Luca Moschitta €1,720
284 Mantas Petrauskas €1,720
285 Mateusz Moolhuizen €1,720
286 Agostino Ascone €1,720
287 Robert Bidlas €1,720
288 Jandaud Pierre-Olivier €1,630
289 Ermanno Ruffini €1,630
290 James Ian Crawley-Boevey €1,630
291 Waclaw Tomasz Dudek €1,630
292 Flavia Gomes Guedes €1,630
293 Alfredo Palmentieri €1,630
294 Ran Shapira €1,630
295 Giovanni Martino €1,630
296 Michele Montone €1,630
297 Roberto Musu €1,630
298 Lino Loddo €1,630
299 Raymond Forsland €1,630
300 Kurt Gustav Mattias Eriksson €1,630
301 Ronnie Nestor €1,630
302 Juraj Siladi €1,630
303 Marko Keskel €1,630
304 Serena Maso €1,630
305 Robert Edwin Jones €1,630
306 Daiva Byrne €1,630
307 Dimitrios Choulis €1,630
308 Umberto Ruggeri €1,630
309 David Dotan Balestra €1,630
310 Paul Gary Maskame €1,630
311 Matheo Awde €1,630
312 Mr Massimo Di Leo €1,630
313 Palermo Cristofero €1,630
314 Joseph Baker €1,630
315 Aregger Philipp €1,630
316 Dennis Beekhuizen €1,630
317 Levinues Coone Brendan €1,630
318 Paul Henry Romain €1,630
319 Asbjorn Elvevold €1,630
320 Carmen-Mariana Zainescu €1,630
321 Stefano Mazzaferro €1,630
322 Simone Pascucci €1,630
323 Jan Cerny €1,630
324 Emanuela Buffone €1,540
325 Oleg Balazs Hatamov €1,540
326 Alin Copos €1,540
327 Borislav Ivanov Yosifov €1,540
328 Margus Koppel €1,540
329 Martin Ivanov Georgiev €1,540
330 Andrea Emanuele €1,540
331 Hristo Bogdanov Bogdanov €1,540
332 Gediminas Bartkus €1,540
333 Andrew Christopher Hills €1,540
334 Nyman Niklas Gustav €1,540
335 Daniel Maurice Samson €1,540
336 Raymond Evensen €1,540
337 Harmjan Poel €1,540
338 Krasen Pendov €1,540
339 Izhak Babo €1,540
340 Rimantas Petras Boguzas €1,540
341 Niko Korhonen €1,540
342 Kjartan Kronstad €1,540
343 Krzysztof Jacyk €1,540
344 Jose Gilberto Blanco Ramirez €1,540
345 Gregory Telman €1,540
346 Manuel Coppola €1,540
347 Giovanni Logarzo €1,540
348 Nikita Aristarkhov €1,540
349 Massimo Segatto €1,540
350 Martino Cito €1,540
351 Maceij Piton €1,540
352 Idan Osteraicher €1,540
353 Shraga Vrubel €1,540
354 Martin Kilchenmann €1,540
355 Mika Matias Hautakangas €1,540
356 Stene-Johansen Ola €1,540
357 Claudio Leonardo Pagano €1,540
358 Ralfs Bikerniels €1,540
359 Mattson Emil Gunnar €1,540
360 Fabio Casavecchia €1,540
361 Quentin Joseph Laucher €1,540
362 David Bravin €1,540
363 Domenico Versace €1,540
364 Giuseppe Sicari €1,540
365 Teunis Arendse €1,540
366 Tomi Autio €1,540
367 Luca Del Beato €1,540
368 Bartosz Mielczarek €1,540
369 Andrea Proietti €1,470
370 Francisco Javier Dominiguez Miguel €1,470
371 Avraham Sisso €1,470
372 Indre Stanaityte €1,470
373 Kapatsoris Stylianos €1,470
374 James Robert Mcgee €1,470
375 Placido Russo €1,470
376 Domenico Cascasi €1,470
377 Trond Andre Bergland €1,470
378 Federico Piroddi €1,470
379 Kevin Houghton €1,470
380 Mirko Cammisuli €1,470
381 Valeri Vilhemov €1,470
382 Ivan Popov €1,470
383 Gazis Savvas €1,470
384 Kjell Soderberg €1,470
385 Patryk Bablok €1,470
386 Brandon Elliott €1,470
387 Damir Savio €1,470
388 Sharon Moalem €1,470
389 Steven Lee Fitzpatrick €1,470
390 Lorenzo Martin €1,470
391 Antonino Leotta €1,470
392 Rolf Woods €1,470
393 Filippo D'Aparo €1,470
394 Fabio Foschi €1,470
395 Maceo Victor Fryda €1,470
396 Alessandro Siena €1,470
397 Karl Johan Karlsson €1,470
398 Unai Martinez Vincente €1,470
399 Toivo Ojasoo €1,470
400 David Lappin €1,470
401 Aleksey Budaev €1,470
402 Nicola Benedetto €1,470
403 Robert James €1,470
404 Roger Nilsen €1,470
405 Lars Jonas Larrson €1,470
406 Luigi Percossi €1,470
407 Fabio Proietti Refrigeri €1,470
408 Claudio Lombardi €1,470
409 Carmine Capuozzo €1,470
410 Lars Niklas Gjersvold €1,470
411 Alberto Flores Trujillo €1,470
412 Giulio Mascolo €1,470
413 Marco Manca €1,470
414 Jose Antonio Sanchez Guerrero €1,400
415 Bart Joanna Maes €1,400
416 Raffaele Gison €1,400
417 Alfio Chillemi €1,400
418 Knut Alexander Mo €1,400
419 Mr Hichem Ayachi €1,400
420 Antoine Degiorgio €1,400
421 Nassim Bennacer €1,400
422 Sharon Sade €1,400
423 Thomas Franck Simsen €1,400
424 Dillan Patel €1,400
425 Gunnar Arne Stangeby €1,400
426 Marius-Constantin Hutupasu €1,400
427 Eychenne Thomas Pierre Jean Bruno €1,400
428 Paulo Ricardo Alves Araujo €1,400
429 Vincenzo Cotturri €1,400
430 Florin Nico Guimond €1,400
431 Gianpaolo Puglia €1,400
432 Mark Attard €1,400
433 Sipavicius Mindaugas €1,400
434 Dylan Petrecca €1,400
435 Egon Kaljulaid €1,400
436 Ahmet Coban €1,400
437 Patrick Pahr Solberg €1,400
438 Namir Reda Dfaili €1,400
439 Stefan Vernacki €1,400
440 Fernando Amorelli €1,400
441 Radoslaw Matyjaszczyk €1,400
442 Martynas Miliauskas €1,400
443 Alessandro De Michele €1,400
444 Salvatore Ardizzone €1,400
445 Even Roste Kristiansen €1,400
446 Tomas Molcan €1,400
447 Tomi Kochev €1,400
448 Gianmarco Pagliaro €1,400
449 Frank Ferdinand Robotka €1,400
450 Egon Holdhus €1,400
451 Konstantinos Souliotis €1,400
452 Mr Viktor Waal €1,400
453 Roman Gombosi €1,400
454 Emanuele Ruggiero €1,400
455 Avital Katz €1,400
456 Sulaiman Musa Sesay €1,400
457 Martin Niels Paap €1,400
458 Joel Oiva Ilmari Holmberg €1,400
459 Carl Russell Thompson €1,330
460 Luca Beretta €1,330
461 Deividas Kvaselis €1,330
462 Armando Schembri €1,330
463 James Michael Clarke €1,330
464 Mauro Luciano Guastamacchia €1,330
465 Ian Simpson €1,330
466 Petter Bjorklund Kristiansen €1,330
467 Paolo Santagati €1,330
468 Fotios Ntamais €1,330
469 Antonio Baldo €1,330
470 Pierre Azzopardi €1,330
471 Simon Mark Burns €1,330
472 Giuseppe Siligato €1,330
473 Seiya Kasahara €1,330
474 Agshin Ahmadli €1,330
475 Alfonso Palmisano €1,330
476 Jon Kyte €1,330
477 Gladys Binbin Long €1,330
478 Jayesh Thakker €1,330
479 Alexander Burton €1,330
480 Keith Brennan €1,330
481 Ibrahim Caner Yurtsever €1,330
482 Julio Diaz €1,330
483 Liron Karmona €1,330
484 Sonia Tara Padovani €1,330
485 Stacey Daniel €1,330
486 Jon Ander Martinez De Antonana Garaialde €1,330
487 Stian Knutsen €1,330
488 Francoias Laurent €1,330
489 Johannes De Laat Bas Wilhelmus Cornelis €1,330
490 Danilo Cangianiello €1,330
491 Marco Chiacchio €1,330
492 Mahmood Ur Rasheed €1,330
493 Fraser MacIntyre €1,330
494 Adam Elyas Lulat €1,330
495 William John Delaney €1,330
496 James Paul Golder €1,330
497 Giuseppe Cefalu` €1,330
498 Justinas Fiseris €1,330
499 Mdanat Yazan €1,330
500 Quentin Jean Gerard Lecomte €1,330
501 Alexander Weinreich €1,330
502 Ulysse Arnaud Maurice Harry €1,330
503 Bo Johan Linder €1,330
504 Harry Haan €1,260
505 Daniele Giardina €1,260
506 Mantas Urbonas €1,260
507 Umberto Vitagliano €1,260
508 Davide Gaetano Suriano €1,260
509 Karl Snow €1,260
510 Annette Ocarroll €1,260
511 Domenico Marra €1,260
512 Alberto Guiso €1,260
513 Alon Hershberg €1,260
514 Brandon Michael Sheils €1,260
515 Alfio Savasta €1,260
516 Robert Cabral Lim €1,260
517 Nicholas Newport €1,260
518 Miss Emanuel Roccaro €1,260
519 Michele Di Mise €1,260
520 Marco D'Amico €1,260
521 Mateusz Sebastian Wozniak €1,260
522 Daurgirdas Rimgaila €1,260
523 Lim-Wai Cheung €1,260
524 Daniele Sacchi €1,260
525 Andreas Pavli €1,260
526 Peter Jaksland €1,260
527 Staes Bram €1,260
528 Stefan Petrov €1,260
529 Villu Metsur €1,260
530 Line Boeller €1,260
531 Salvatore Giovanni Calvagno €1,260
532 Jimmy Boubou Kebe €1,260
533 Alex Jennings €1,260
534 Florian Dubrawski €1,260
535 Dainotti Vincenzo €1,260
536 Mikko Pennanen €1,260
537 Porcino Pasquale €1,260
538 Domenico Avagliano €1,260
539 Massimo Degiorgi €1,260
540 Kyriakos Mitsopoulos €1,260
541 Ivo Marinov €1,260
542 Filip Zak €1,260
543 Ross William Greig €1,260
544 Kenneth Johansen €1,260
545 Bo Daniel Alexander Lantz €1,260
546 Elio Caferro €1,260
547 Salvatore Santonocito €1,260
548 Vittorio Concetto Leanza €1,260
549 Alar Hoim €1,220
550 Marcel Theo Leuker €1,220
551 Ioannis Avgousti €1,220
552 Angelo Coletta €1,220
553 FRsco Leoncini €1,220
554 Daniel Clifford €1,220
555 Alessandra Rapone €1,220
556 Giovanni Nunzio Riccardo Amato €1,220
557 Eylon IL €1,220
558 Saba Chadi €1,220
559 Efraim Ratzon Efrati €1,220
560 Konstantin Nikolaev Zerdev €1,220
561 Freddy Mosk €1,220
562 Nicolas Bruno Courbin €1,220
563 Khaled Hizem €1,220
564 Oleg Lakota €1,220
565 Filip Theodor Anders Andren €1,220
566 Giuseppe Montella €1,220
567 Maciej Toma €1,220
568 Tayfun Dogan €1,220
569 Edgaras Bucinskas €1,220
570 Michael John O'Mahoney €1,220
571 Konstantin Faerber €1,220
572 Marcin Igor Puczylowski €1,220
573 Alain Bucher €1,220
574 Virginijus Lapenas €1,220
575 Daniel Paul Golder €1,220
576 Piero Di Gregorio €1,220
577 Antonio Jesus Torres Villadiego €1,220
578 Anders Ryli €1,220
579 Marco D`Antonino €1,220
580 Carmelo Villafranca €1,220
581 Jukka Jeremia Vainio €1,220
582 Makov Ofer Herzel €1,220
583 Riccardo Di Stasi €1,220
584 Robert Sherwood €1,220
585 Cosimo De Gennaro €1,220
586 Alf Adam Mortinsson €1,220
587 David Hareuveni €1,220
588 Pinar Mansouri €1,220
589 Nicola Notamasi €1,220
590 Nikolaos Lampropoulos €1,220
591 Kyriakos Papadopoulos €1,220
592 Polys Christou €1,220
593 Julie Moe Klein €1,220
594 Angelo Pappalardo €1,170
595 Antonio Guerrero €1,170
596 FRsco Aru €1,170
597 Nicklas Andre Hallnor €1,170
598 Jens Erik Thorsten Ostergaard €1,170
599 Alessandro Secci €1,170
600 Viacheslav Kovalev €1,170
601 Gerardo Ferrara €1,170
602 Andrei Mjagkov €1,170
603 Anne Meri €1,170
604 Sjors Harmens €1,170
605 Jose Miquel Delgado €1,170
606 Samantha Algeri €1,170
607 Kalle Esa Viljami Salmela €1,170
608 Ronan John Sweeney €1,170
609 Pasquale Vinci €1,170
610 Matthew Pace €1,170
611 Cristiano Claudi €1,170
612 Herkul Madis €1,170
613 Janar Lipasaar €1,170
614 Luciano Castellano €1,170
615 Paolo Cappellini €1,170
616 Alastair Harris David €1,170
617 Riccardo Saitta €1,170
618 Andrea Cheri €1,170
619 Roberto Zuffo €1,170
620 Matteo Rossetti €1,170
621 Angelo Patane' €1,170
622 Karl Simon Nyden €1,170
623 Antonio Jesus Rodriguez Ruiz €1,170
624 Mancinelli Edoardo €1,170
625 Fabio Prinari €1,170
626 Mario Juste Sanchez €1,170
627 Rain Moelderkivi €1,170
628 Edgars Armans €1,170
629 Anne Busch €1,170
630 Mick Mccloskey €1,170
631 Haakan Leif Mikael Oebrink €1,170
632 Daniele Grasso €1,170
633 Matthew Dominique Jean Michel €1,170
634 Mark Anthony Vella €1,170
635 Valentino Pedron €1,170
636 Antonio Merone €1,170
637 Patrick Newell Buchanan €1,170
638 Luca Bartoli €1,170
639 Andreas Paleologos €1,170
640 Michail Kavouras €1,170
641 Alfonso Amendola €1,170
642 Robert James Burdett €1,170
643 Valery Yantsevich €1,170
644 Luigi Knoppers €1,170
645 Morici Morici €1,170
646 Mark Gardner €1,170
647 Ionut-Cosmin Dragomir €1,170
648 Ana Laura Marquez Esteban €1,100
649 Daniel Feirer €1,100
650 Giuseppe Luca Bernieri €1,100
651 Johan Palokangas €1,100
652 Tom Driss Laghzaoui €1,100
653 Tarmo Tammel €1,100
654 Daniel Andre Hoyesveen €1,100
655 Alexander Stuart Clark €1,100
656 Vitaly Monakhov €1,100
657 Lionel De Beer €1,100
658 Ferdinand Janssen €1,100
659 Martin Korman €1,100
660 Erik Linus Viklund €1,100
661 Zion Shamay €1,100
662 Axat Mawji €1,100
663 Alex Kristiyan Kulev €1,100
664 Roman Galperin €1,100
665 Gal Fridman €1,100
666 Dara O`Kearney €1,100
667 Menashe Levy €1,100
668 Luca Caravaglio €1,100
669 Alessandro Nocerino €1,100
670 Luke Ronald Yerby €1,100
671 Andrea Ragone €1,100
672 Mr Morten Klein €1,100
673 Jan Einar Johansen €1,100
674 Vanda Leoni €1,100
675 Paulo Jorge €1,100
676 Ola Petter Bremer €1,100
677 Antonio Marzuola €1,100
678 Fragkiskos Vidalis €1,100
679 John Henrik Loefvander €1,100
680 Salvatore Agliozzo €1,100
681 Latifa Guennas €1,100
682 Vladimir Minarik €1,100
683 Erez Magdasi €1,100
684 Raimondo Marcello €1,100
685 Tomasz Piotr Brzezinski €1,100
686 Vincas Tamasauskas €1,100
687 Uri Soffrin €1,100
688 Ilyan Yordanov €1,100

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.