0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/132/311/chips'
ORDER BY `views` DESC

0.0043 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/132/311/chips', 1, '2024-07-27')

0.0003 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '132'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '132'

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

0.0263 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.0769 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0088 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '311'
AND `published` = 1

0.0761 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` = '312'
AND `published` = 1

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

0.0071 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.0565 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.0059 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.0051 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` = '311'
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` = '13776'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0674 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.0115 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.0113 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.0056 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2526

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

Jacks of June €150K GTD €555 Main Event Live Reporting - Day 3

Jacks of June - Live Reporting €150K GTD €555 Main Event €1,100 High Roller

---

Current Level 28 Current Day 3

---

Blinds 40,000/80,000 Ante 80,000

Entries 390 Remaining 1

---

Prize Pool (EUR) €187,200 First Prize (EUR) €34,950

Chip Leaders Day 3

1

Ovidijus Berenis

11,700,000

Day 1A Day 1B Day 1C Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Chip Counts - Day 1C

Place	Player		Chips	Progress
1	Audrius Navickas		142,000	112,000
2	Stanislovas Vinicenka		125,000	95,000
3	Mehmet Uskes		121,000	91,000
4	Rolandas Aglinskas		118,500	88,500
5	Serhii Leonov		109,500	79,500
6	Johan Aakesson		96,000	66,000
7	Vytautas Kacerauskas		89,000	59,000
8	Karolis Sereika		84,000	54,000
9	Stepas Tindziulis		64,000	34,000
10	Justina Andriukeviciute		63,000	33,000
11	Ignotas Tamasauskas		51,000	21,000
12	Grigorijus Vasilavicius		47,000	17,000
13	Vitalijus Briazkala		36,000	6,000
14	Aurimas Venskus		36,000	6,000
15	Sedat Kestel		30,000	0
16	Svajunas Seduikis		30,000	0
17	Linas Radionovas		26,500	3,500
18	Tadas Gencerauskas		23,000	7,000