
James Perugini

|


Tournament History
James Perugini Highlighted in FPN News




Date | Tournament | Venue | Rank | Points |
---|
1 x Application (91.56%) | 454ms |
1 x Booting (8.44%) | 41.81ms |
Backtrace |
|
select * from `users` where `alias` = 'james-perugini' limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 1312 and `tournament_players`.`winnings` != 0)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 1312 and `tournament_players`.`rank` = 1 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 1312 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `fpn_tournaments` inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where (`tournament_players`.`user_id` = 1312 and `tournament_players`.`final_table` = 1 and `fpn_tournaments`.`payout_distribution_id` != 2 and `fpn_tournaments`.`status` = 1 and `fpn_tournaments`.`finalized_tournament` = 1)
Bindings |
|
Backtrace |
|
select `tournament_players`.*, `users`.`id` as `uid`, `users`.*, `fpn_tournaments`.`name` as `tournament_name`, `fpn_tournaments`.`id` as `tid`, `fpn_tournaments`.`start_date` as `tournament_start_date`, `fpn_promotions`.`id` as `sid`, `fpn_promotions`.`name` as `season_name`, `fpn_leagues`.`id`, `fpn_leagues`.`season_id`, `fpn_venues`.`name` as `venue_name`, `fpn_venues`.`address`, `fpn_venues`.`city`, `fpn_venues`.`state` from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 1312) limit 1
Bindings |
|
Backtrace |
|
select sum(`winnings`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 1312) limit 1
Bindings |
|
Backtrace |
|
select sum(`bounty`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 1312) limit 1
Bindings |
|
Backtrace |
|
select sum(`score`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 1312) limit 1
Bindings |
|
Backtrace |
|
select sum(`bounty`) as aggregate from `users` left join `tournament_players` on `users`.`id` = `tournament_players`.`user_id` left join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` and `fpn_tournaments`.`finalized_tournament` = 1 and `fpn_tournaments`.`status` = 1 left join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` left join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`season_id` left join `fpn_venues` on `fpn_venues`.`id` = `fpn_tournaments`.`venue_id` where (`users`.`id` = 1312) limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('1312',associated_user_ids)
Bindings |
|
Backtrace |
|
select * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('1312',associated_user_ids) order by `published_at` desc
Bindings |
|
Backtrace |
|
select * from `articles` where find_in_set(1312, associated_user_ids) and `status` = '1' and `video_url` != '' order by `published_at` desc
Bindings |
|
Backtrace |
|
select `default_article_image` from `configurations`
Backtrace |
|
select `fpn_promotions`.`id`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_promotions`.`icons_badges_tooltip`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_tournaments`.`alias` as `tournament_alias`, `fpn_tournaments`.`start_date` from `fpn_tournaments` left join `fpn_promotions` on FIND_IN_SET(fpn_promotions.id, fpn_tournaments.qualifier_promotion_ids) > 0 inner join `tournament_players` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` where `fpn_tournaments`.`qualifier_types` = 1 and `fpn_tournaments`.`finalized_tournament` = 1 and `tournament_players`.`rank` = 1 and `tournament_players`.`user_id` = 1312 and `fpn_tournaments`.`event_id` not in (502) group by `fpn_tournaments`.`id` order by `fpn_promotions`.`id` desc
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`id`, `fpn_promotions`.`name`, `fpn_promotions`.`icons_badges`, `fpn_promotions`.`alias`, `fpn_promotions`.`icons_badges_tooltip` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_promotions`.`id` order by `default` desc, `id` desc
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 26 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 1076 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('21', '22') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 25 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 805 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 805 and date(`start_date`) >= '2025-01-01 00:00:00' and date(`end_date`) <= '2025-03-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 805 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (57262, 57263, 57264, 57265, 57266, 57267, 57268, 57269, 57270, 57271, 57272, 57273, 57274) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 805 and date(`start_date`) >= '2024-10-01 00:00:00' and date(`end_date`) <= '2024-12-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 805 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (57249, 57250, 57251, 57252, 57253, 57254, 57255, 57256, 57257, 57258, 57259, 57260, 57261) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 24 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 509 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 509 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 509 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34136, 34137, 34138, 34139, 34140, 34141, 34142, 34143, 34144, 34145, 34146, 34147, 34148, 49575) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 509 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 509 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (34123, 34124, 34125, 34126, 34127, 34128, 34129, 34130, 34131, 34132, 34133, 34134, 34135) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 712 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 712 and date(`start_date`) >= '2024-07-01 00:00:00' and date(`end_date`) <= '2024-09-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 712 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (45467, 45468, 45469, 45470, 45471, 45472, 45473, 45474, 45475, 45476, 45477, 45478, 45479, 48660, 49690, 59333) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 712 and date(`start_date`) >= '2024-04-01 00:00:00' and date(`end_date`) <= '2024-06-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 712 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (40930, 40931, 40932, 40933, 45458, 45459, 45460, 45461, 45462, 45463, 45464, 45465, 45466, 46377, 47532) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 23 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 329 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 329 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 329 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (27784, 27785, 27786, 27787, 27788, 27789, 27790, 27791, 27792, 27793, 27794, 27795, 27796) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 329 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 329 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (27201, 27773, 27774, 27775, 27776, 27777, 27778, 27779, 27780, 27781, 27782, 27783, 28304) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 258 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 258 and date(`start_date`) >= '2024-01-01 00:00:00' and date(`end_date`) <= '2024-03-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 258 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (27933, 27934, 27935, 27936, 27937, 27938, 27939, 27940, 27941, 27942, 27943, 27944, 27945) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 258 and date(`start_date`) >= '2023-10-01 00:00:00' and date(`end_date`) <= '2023-12-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 258 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (20414, 27921, 27922, 27923, 27924, 27925, 27926, 27927, 27928, 27929, 27930, 27931, 27932, 28221) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 16 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 12 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 12 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 12 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (6375, 6376, 6377, 6378, 17895, 17896, 17897, 17898, 17899, 17900, 17901, 17902, 17903) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 12 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 12 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (6362, 6363, 6364, 6365, 6366, 6367, 6368, 6369, 6370, 6371, 6372, 6373, 6374) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 12 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 12 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (126, 127, 128, 129, 130, 131, 132, 133, 3253, 3339, 6356, 6357, 6358, 6359, 6360, 6361) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 159 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 159 and date(`start_date`) >= '2023-07-01 00:00:00' and date(`end_date`) <= '2023-09-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 159 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (5044, 5045, 5046, 5047, 17886, 17887, 17888, 17889, 19647, 19648, 19649, 19650, 19651, 19652) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 159 and date(`start_date`) >= '2023-04-01 00:00:00' and date(`end_date`) <= '2023-06-30 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 159 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5043) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 159 and date(`start_date`) >= '2023-01-01 00:00:00' and date(`end_date`) <= '2023-03-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 159 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (5018, 5019, 5020, 5021, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_leagues`.`id`, `fpn_leagues`.`name`, `fpn_leagues`.`alias` from `fpn_leagues` inner join `fpn_tournaments` on `fpn_tournaments`.`event_id` = `fpn_leagues`.`id` inner join `tournament_players` on `tournament_players`.`tournament_id` = `fpn_tournaments`.`id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` where `fpn_leagues`.`promotion_id` = 15 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'james-perugini' and `fpn_leagues`.`id` not in (502, 957) group by `fpn_leagues`.`id`
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 139 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('7') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 139 and date(`start_date`) >= '2022-10-01 00:00:00' and date(`end_date`) <= '2022-12-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 139 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (4402, 4403, 4404, 4405, 4406, 4407, 4408, 4409, 4410, 4411, 4412, 4413, 4414) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
select `fpn_promotions`.`season_id` from `fpn_promotions` inner join `fpn_leagues` on `fpn_leagues`.`promotion_id` = `fpn_promotions`.`id` where `fpn_leagues`.`id` = 5 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('7') and `end_date` < '2025-05-05 08:16:47' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 5 and date(`start_date`) >= '2022-10-01 00:00:00' and date(`end_date`) <= '2022-12-31 00:00:00'
Bindings |
|
Backtrace |
|
select `tournament_players`.`id`, `tournament_players`.`id`, `tournament_players`.`tournament_id`, `tournament_players`.`rank`, `users`.`alias`, `users`.`avatar`, `fpn_tournaments`.`name` as `tournament_name`, `fpn_leagues`.`id` as `league_id`, `fpn_leagues`.`promotion_id`, sum(tournament_players.score) as score, SUM(CASE WHEN tournament_players.rank = '1' THEN 1 ELSE 0 END) AS wins, `users`.`first_name` as `previousSeasonChampFname`, `users`.`last_name` as `previousSeasonChampLname`, `fpn_promotions`.`name` as `promotion_name`, `fpn_promotions`.`alias` as `promotion_alias`, `fpn_promotions`.`icons_badges`, `fpn_leagues`.`name` as `league_name`, `fpn_leagues`.`alias` as `league_alias`, `fpn_venues`.`alias` as `venue_alias`, `fpn_regions`.`name` as `region_name`, `fpn_regions`.`alias` as `region_alias` from `tournament_players` inner join `fpn_tournaments` on `fpn_tournaments`.`id` = `tournament_players`.`tournament_id` inner join `users` on `users`.`id` = `tournament_players`.`user_id` inner join `fpn_leagues` on `fpn_leagues`.`id` = `fpn_tournaments`.`event_id` inner join `fpn_venues` on `fpn_venues`.`id` = `fpn_leagues`.`venue_id` inner join `fpn_regions` on `fpn_regions`.`id` = `fpn_venues`.`region_id` inner join `fpn_promotions` on `fpn_promotions`.`id` = `fpn_leagues`.`promotion_id` where `fpn_leagues`.`id` = 5 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (120) and `fpn_tournaments`.`finalized_tournament` = 1 group by `tournament_players`.`user_id` order by `score` desc limit 1
Bindings |
|
Backtrace |
|
Params | |
---|---|
key |
|
tags |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
delete |
|
Params | |
---|---|
key |
|
tags |
|
value |
|
seconds |
|
delete |
|
1 x missed HslN5wyGtG2c0bgDmE2qfZLKEwSbxCIaIfh9Q6eH (0%) | 0μs |
9 x hit c_config (0%) | 0μs |
1 x written HslN5wyGtG2c0bgDmE2qfZLKEwSbxCIaIfh9Q6eH (0%) | 0μs |
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "staging.freepokernetwork.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 05 May 2025 13:16:47 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im9TdnljRldSYUpPU0FwUFFyd2Z2VFE9PSIsInZhbHVlIjoiNkQwejArNWk4ZDl1SEN4NUJYeVBuWE5HTGlMclJ1azA4QVhITXY1VjNETmxTYTYrZHQ2R01uamZ2aThURU43LzZDMXh1QXo3K0pLYTZuNE5hRVl5RU84eTBPRHd4VFhORUhIQURDd0tlVDBhUXNOalZTS3dlRDAzOUdMdG9WRm8iLCJtYWMiOiJhOTYwM2RjYWM1ZGJjNGIyYzg5YmIxN2Q5M2EwYjhjNTgzMTcxZjU0MTRhNzg1MjJkNWNjYTk5NjkwYWE4MmViIiwidGFnIjoiIn0%3D; expires=Tue, 05 May 2026 13:16:47 GMT; Max-Age=31536000; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im9TdnljRldSYUpPU0FwUFFyd2Z2VFE9PSIsInZhbHVlIjoiNkQwejArNWk4ZDl1SEN4NUJYeVBuWE5HTGlMclJ1azA4QVhITXY1VjNETmxTYTYrZHQ2R01uamZ2aThURU43LzZDMXh1Q ▶" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IjVCbTJEeEtpY0xsVTFnQVdsU2o3V2c9PSIsInZhbHVlIjoidnVFUERLRDZBc2dJRDJ1N1BwMTFNN290V0o1djFXRFl4ZlFLMmZKSnZCREdUbmY2VktyQzRPcGg3aXVzbnBrcldVSmVhZkgxRm5Lblp3YitLckV5QmtBallySytrS0ZZMmdJd3dZUUd4SHZodi9oZlJ3Y0ZDL2JVYVJkaEdWS0oiLCJtYWMiOiIwZWU2MWJmNmE0MzY5NzAyZGE0YWZjNDhkMGU3NzlmZTU3NzI3ZWUyOGE3YjJiNjliNTc2NzJjZWJiM2EwYWYwIiwidGFnIjoiIn0%3D; expires=Tue, 05 May 2026 13:16:47 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀freepokernetwork_upgrade_session=eyJpdiI6IjVCbTJEeEtpY0xsVTFnQVdsU2o3V2c9PSIsInZhbHVlIjoidnVFUERLRDZBc2dJRDJ1N1BwMTFNN290V0o1djFXRFl4ZlFLMmZKSnZCREdUbmY2VktyQzR ▶" 2 => "RSVP_status=eyJpdiI6IkxWd2xaRTRpazZ2KzdLaUhBQWpPL1E9PSIsInZhbHVlIjoiQXQxVkhyRlpMLzRLZDJvdGlwQVBrQnFvV0M2ZWdDUjY3Y0tvL1NpSlNHQjdvbDBBRHh3aEtGenJycUJrTUM0QSIsIm1hYyI6IjdiMWU4MzkyZTc4ZWRkZGM1M2E4YTRjNzAxYzcwNTJkOTA3NmE0ZTYzNjg5NDRmNzgzYjczNjdjYzU2ZTgzMDMiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 06 May 2020 13:16:47 GMT; Max-Age=0; path=/; secure; httponly; samesite=lax ◀RSVP_status=eyJpdiI6IkxWd2xaRTRpazZ2KzdLaUhBQWpPL1E9PSIsInZhbHVlIjoiQXQxVkhyRlpMLzRLZDJvdGlwQVBrQnFvV0M2ZWdDUjY3Y0tvL1NpSlNHQjdvbDBBRHh3aEtGenJycUJrTUM0QSIsIm1h ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im9TdnljRldSYUpPU0FwUFFyd2Z2VFE9PSIsInZhbHVlIjoiNkQwejArNWk4ZDl1SEN4NUJYeVBuWE5HTGlMclJ1azA4QVhITXY1VjNETmxTYTYrZHQ2R01uamZ2aThURU43LzZDMXh1QXo3K0pLYTZuNE5hRVl5RU84eTBPRHd4VFhORUhIQURDd0tlVDBhUXNOalZTS3dlRDAzOUdMdG9WRm8iLCJtYWMiOiJhOTYwM2RjYWM1ZGJjNGIyYzg5YmIxN2Q5M2EwYjhjNTgzMTcxZjU0MTRhNzg1MjJkNWNjYTk5NjkwYWE4MmViIiwidGFnIjoiIn0%3D; expires=Tue, 05-May-2026 13:16:47 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im9TdnljRldSYUpPU0FwUFFyd2Z2VFE9PSIsInZhbHVlIjoiNkQwejArNWk4ZDl1SEN4NUJYeVBuWE5HTGlMclJ1azA4QVhITXY1VjNETmxTYTYrZHQ2R01uamZ2aThURU43LzZDMXh1Q ▶" 1 => "freepokernetwork_upgrade_session=eyJpdiI6IjVCbTJEeEtpY0xsVTFnQVdsU2o3V2c9PSIsInZhbHVlIjoidnVFUERLRDZBc2dJRDJ1N1BwMTFNN290V0o1djFXRFl4ZlFLMmZKSnZCREdUbmY2VktyQzRPcGg3aXVzbnBrcldVSmVhZkgxRm5Lblp3YitLckV5QmtBallySytrS0ZZMmdJd3dZUUd4SHZodi9oZlJ3Y0ZDL2JVYVJkaEdWS0oiLCJtYWMiOiIwZWU2MWJmNmE0MzY5NzAyZGE0YWZjNDhkMGU3NzlmZTU3NzI3ZWUyOGE3YjJiNjliNTc2NzJjZWJiM2EwYWYwIiwidGFnIjoiIn0%3D; expires=Tue, 05-May-2026 13:16:47 GMT; path=/; httponly ◀freepokernetwork_upgrade_session=eyJpdiI6IjVCbTJEeEtpY0xsVTFnQVdsU2o3V2c9PSIsInZhbHVlIjoidnVFUERLRDZBc2dJRDJ1N1BwMTFNN290V0o1djFXRFl4ZlFLMmZKSnZCREdUbmY2VktyQzR ▶" 2 => "RSVP_status=eyJpdiI6IkxWd2xaRTRpazZ2KzdLaUhBQWpPL1E9PSIsInZhbHVlIjoiQXQxVkhyRlpMLzRLZDJvdGlwQVBrQnFvV0M2ZWdDUjY3Y0tvL1NpSlNHQjdvbDBBRHh3aEtGenJycUJrTUM0QSIsIm1hYyI6IjdiMWU4MzkyZTc4ZWRkZGM1M2E4YTRjNzAxYzcwNTJkOTA3NmE0ZTYzNjg5NDRmNzgzYjczNjdjYzU2ZTgzMDMiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 06-May-2020 13:16:47 GMT; path=/; secure; httponly ◀RSVP_status=eyJpdiI6IkxWd2xaRTRpazZ2KzdLaUhBQWpPL1E9PSIsInZhbHVlIjoiQXQxVkhyRlpMLzRLZDJvdGlwQVBrQnFvV0M2ZWdDUjY3Y0tvL1NpSlNHQjdvbDBBRHh3aEtGenJycUJrTUM0QSIsIm1h ▶" ] ]
0 of 0array:3 [▼ "_token" => "rY4pslMEKGuKidzd2vKOZ1Rr00CEO8j8PoiDjnfG" "_previous" => array:1 [▶ "url" => "https://staging.freepokernetwork.com/player/james-perugini" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]