
Doug Morin

|


Tournament History
Doug Morin Highlighted in FPN News

Date | Tournament | Venue | Rank | Points |
---|
1 x Application (86.53%) | 539ms |
1 x Booting (13.47%) | 83.93ms |
Backtrace |
|
select * from `users` where `alias` = 'doug-moran' limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `tournament_players` where (`tournament_players`.`user_id` = 653 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` = 653 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` = 653 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` = 653 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` = 653) 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` = 653) 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` = 653) 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` = 653) 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` = 653) limit 1
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `articles` where `status` = '1' and `category_id` is not null and find_in_set('653',associated_user_ids)
Bindings |
|
Backtrace |
|
select * from `articles` where `status` = '1' and `category_id` is not null and find_in_set('653',associated_user_ids) order by `published_at` desc
Bindings |
|
Backtrace |
|
select * from `articles` where find_in_set(653, 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` = 653 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` = 'doug-moran' 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` = 25 and `fpn_tournaments`.`status` = 1 and `users`.`alias` = 'doug-moran' 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` = 862 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-02 23:01:03' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 862 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` = 862 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (51897, 51898, 51899, 51900, 51901, 51902, 51903, 51904, 51905, 51906, 51907, 51908, 51909) 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` = 862 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` = 862 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (51884, 51885, 51886, 51887, 51888, 51889, 51890, 51891, 51892, 51893, 51894, 51895, 51896) 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` = 804 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('19', '20') and `end_date` < '2025-05-02 23:01:03' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 804 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` = 804 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (49999, 50000, 50001, 50002, 50003, 50004, 50005, 50006, 50007, 50008, 50009, 50010, 50011) 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` = 804 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` = 804 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (49986, 49987, 49988, 49989, 49990, 49991, 49992, 49993, 49994, 49995, 49996, 49997, 49998) 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` = 'doug-moran' 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` = 678 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 23:01:03' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 678 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` = 678 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (43836, 43837, 43838, 43839, 43840, 43841, 43842, 43843, 43844, 43845, 43846, 57228, 57229) 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` = 678 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` = 678 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (43034, 43824, 43825, 43826, 43827, 43828, 43829, 43830, 43831, 43832, 43833, 43834, 43835) 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` = 546 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 546 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` = 546 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (35236, 35237, 35238, 35239, 35240, 35241, 35242, 35243, 35244, 35245, 35246, 35247, 35248) 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` = 546 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` = 546 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (35223, 35224, 35225, 35226, 35227, 35228, 35229, 35230, 35231, 35232, 35233, 35234, 35235) 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` = 645 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('17', '18') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 645 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` = 645 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (42994, 42995, 42996, 42997, 42998, 42999, 43000, 43001, 43002, 43003, 43004, 43005, 43006) 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` = 645 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` = 645 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (39069, 42982, 42983, 42984, 42985, 42986, 42987, 42988, 42989, 42990, 42991, 42992, 42993) 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` = 'doug-moran' 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` = 297 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 297 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` = 297 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (21594, 21595, 21596, 21597, 21598, 21599, 21600, 21601, 21602, 21603, 21604, 21605, 21606) 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` = 297 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` = 297 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (21581, 21582, 21583, 21584, 21585, 21586, 21587, 21588, 21589, 21590, 21591, 21592, 21593) 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` = 406 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('15', '16') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 406 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` = 406 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25884, 25885, 25886, 25887, 25888, 25889, 25890, 25891, 25892, 25893, 25894, 25895, 25896) 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` = 406 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` = 406 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (25871, 25872, 25873, 25874, 25875, 25876, 25877, 25878, 25879, 25880, 25881, 25882, 25883) 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` = 'doug-moran' 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` = 78 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 78 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` = 78 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1990, 1991, 1992, 1993, 18472, 18473, 18474, 18475, 18476, 18477, 18478, 18479, 18480) 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` = 78 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` = 78 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989) 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` = 78 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` = 78 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976) 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` = 69 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 69 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` = 69 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1707, 1708, 1709, 1710, 18535, 18536, 18537, 18538, 18539, 18540, 18541, 18542, 18543) 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` = 69 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` = 69 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1706) 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` = 69 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` = 69 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (1681, 1682, 1683, 1684, 1685, 1686, 1687, 1688, 1689, 1690, 1691, 1692, 1693) 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` = 4 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 4 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` = 4 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (11140, 11141, 11142, 11143, 18571, 18572, 18573, 18574, 18575, 18576, 18577, 18578, 20273) 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` = 4 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` = 4 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (7316, 7317, 7318, 11130, 11131, 11132, 11133, 11134, 11135, 11136, 11137, 11138, 11139) 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` = 4 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` = 4 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (40, 41, 42, 43, 44, 45, 46, 6292, 6293, 7312, 7313, 7314, 7315) 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` = 114 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('10', '12', '13') and `end_date` < '2025-05-02 23:01:04' and `status` = 1 order by `start_date` desc
Bindings |
|
Backtrace |
|
select `id` from `fpn_tournaments` where `event_id` = 114 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` = 114 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (11117, 11118, 11119, 11120, 18333, 18334, 18335, 18336, 18337, 18338, 18339, 18340, 18341) 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` = 114 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` = 114 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (5923, 5924, 5925, 11107, 11108, 11109, 11110, 11111, 11112, 11113, 11114, 11115, 11116) 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` = 114 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` = 114 and `fpn_tournaments`.`status` = 1 and `tournament_players`.`tournament_id` in (3340, 3341, 3342, 3343, 3344, 3345, 3346, 3347, 5918, 5919, 5920, 5921, 5922) 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` = 'doug-moran' 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` = 5 limit 1
Bindings |
|
Backtrace |
|
select * from `fpn_season` where `id` in ('7') and `end_date` < '2025-05-02 23:01:04' 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 ajYV7zMlWcksMWpVrIdbJjEuvNRzVTYMdSWygah8 (0%) | 0μs |
9 x hit c_config (0%) | 0μs |
1 x written ajYV7zMlWcksMWpVrIdbJjEuvNRzVTYMdSWygah8 (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 => "Sat, 03 May 2025 04:01:04 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InlOMTZYR3IwdjRiRUtJM3ROOEozSEE9PSIsInZhbHVlIjoiYlVTZElXQzd6VDJmdzhqSXR4OURTdGV1M2k0QytYMW1UMzNpVDJBNERKcXFPeG9Ib0lTSzd2K3pmZEFKdTlPNS95V2dBR1R6LzJrNG5JejliMklDQWlKK1JVdUphbVdSSGREWEg1QzRWYTFXV1hUVVlwYXV1VkF3SWI4U3ZCamciLCJtYWMiOiIyYTY2N2U0MzY4N2U3MGQwNTYyZWNkM2RhNGIzNThmMDJmZDYzOGM2ZDc1ZjFmNGU0YzZjY2IyZGUxYWYxNmQ3IiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 04:01:04 GMT; Max-Age=31536000; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InlOMTZYR3IwdjRiRUtJM3ROOEozSEE9PSIsInZhbHVlIjoiYlVTZElXQzd6VDJmdzhqSXR4OURTdGV1M2k0QytYMW1UMzNpVDJBNERKcXFPeG9Ib0lTSzd2K3pmZEFKdTlPNS95V2dBR ▶" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ilc0YlRwQW9tUkdJSUNQUkhIN1Ird1E9PSIsInZhbHVlIjoiOHFIVlNtd0UrdWM2enF2ek92VnJTVWx6U2JFNGhuTTdLT2lxZzFXTTlZdHNBQmdQM3owR1A1VnJaVGNvL2pPK1psZkliOUtLWVdDU3hIc0l6dHA2K2dvOHQ1cWxNTGJtMUxzcUFDbUh5ZStJKzJCdkFPY09VSmVYYy8rbWFFR1AiLCJtYWMiOiIzY2QyNGMwNWYxMTliYzVlOGNlNjYzMTlmY2MyOThhNmJiOTk0NWUxNmM5YWUwNjQ0ZGY4MmRkYjc5ZGJlYjFmIiwidGFnIjoiIn0%3D; expires=Sun, 03 May 2026 04:01:04 GMT; Max-Age=31536000; path=/; httponly; samesite=lax ◀freepokernetwork_upgrade_session=eyJpdiI6Ilc0YlRwQW9tUkdJSUNQUkhIN1Ird1E9PSIsInZhbHVlIjoiOHFIVlNtd0UrdWM2enF2ek92VnJTVWx6U2JFNGhuTTdLT2lxZzFXTTlZdHNBQmdQM3owR1A ▶" 2 => "RSVP_status=eyJpdiI6IldMMnJzTHJxMnAzOHJvNnlFVi8wbVE9PSIsInZhbHVlIjoiM3g5emdEYVg4NHh5UitTMnlTcGswYlloQ0lKSVNLc0IzbzdIZm5NVkFCVGhLbG1SQmN2ODZZRnVGRHpOd3ZEbSIsIm1hYyI6IjRlYmJiOWY5MDFmYjZhMzY4ZDY2MGI1Njc0MTE0N2VmYWQ0MDg2MDA4YzIwZDllMGM0ZTJlMWJlYzQ2YTJmMGEiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04 May 2020 04:01:03 GMT; Max-Age=0; path=/; secure; httponly; samesite=lax ◀RSVP_status=eyJpdiI6IldMMnJzTHJxMnAzOHJvNnlFVi8wbVE9PSIsInZhbHVlIjoiM3g5emdEYVg4NHh5UitTMnlTcGswYlloQ0lKSVNLc0IzbzdIZm5NVkFCVGhLbG1SQmN2ODZZRnVGRHpOd3ZEbSIsIm1h ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InlOMTZYR3IwdjRiRUtJM3ROOEozSEE9PSIsInZhbHVlIjoiYlVTZElXQzd6VDJmdzhqSXR4OURTdGV1M2k0QytYMW1UMzNpVDJBNERKcXFPeG9Ib0lTSzd2K3pmZEFKdTlPNS95V2dBR1R6LzJrNG5JejliMklDQWlKK1JVdUphbVdSSGREWEg1QzRWYTFXV1hUVVlwYXV1VkF3SWI4U3ZCamciLCJtYWMiOiIyYTY2N2U0MzY4N2U3MGQwNTYyZWNkM2RhNGIzNThmMDJmZDYzOGM2ZDc1ZjFmNGU0YzZjY2IyZGUxYWYxNmQ3IiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 04:01:04 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InlOMTZYR3IwdjRiRUtJM3ROOEozSEE9PSIsInZhbHVlIjoiYlVTZElXQzd6VDJmdzhqSXR4OURTdGV1M2k0QytYMW1UMzNpVDJBNERKcXFPeG9Ib0lTSzd2K3pmZEFKdTlPNS95V2dBR ▶" 1 => "freepokernetwork_upgrade_session=eyJpdiI6Ilc0YlRwQW9tUkdJSUNQUkhIN1Ird1E9PSIsInZhbHVlIjoiOHFIVlNtd0UrdWM2enF2ek92VnJTVWx6U2JFNGhuTTdLT2lxZzFXTTlZdHNBQmdQM3owR1A1VnJaVGNvL2pPK1psZkliOUtLWVdDU3hIc0l6dHA2K2dvOHQ1cWxNTGJtMUxzcUFDbUh5ZStJKzJCdkFPY09VSmVYYy8rbWFFR1AiLCJtYWMiOiIzY2QyNGMwNWYxMTliYzVlOGNlNjYzMTlmY2MyOThhNmJiOTk0NWUxNmM5YWUwNjQ0ZGY4MmRkYjc5ZGJlYjFmIiwidGFnIjoiIn0%3D; expires=Sun, 03-May-2026 04:01:04 GMT; path=/; httponly ◀freepokernetwork_upgrade_session=eyJpdiI6Ilc0YlRwQW9tUkdJSUNQUkhIN1Ird1E9PSIsInZhbHVlIjoiOHFIVlNtd0UrdWM2enF2ek92VnJTVWx6U2JFNGhuTTdLT2lxZzFXTTlZdHNBQmdQM3owR1A ▶" 2 => "RSVP_status=eyJpdiI6IldMMnJzTHJxMnAzOHJvNnlFVi8wbVE9PSIsInZhbHVlIjoiM3g5emdEYVg4NHh5UitTMnlTcGswYlloQ0lKSVNLc0IzbzdIZm5NVkFCVGhLbG1SQmN2ODZZRnVGRHpOd3ZEbSIsIm1hYyI6IjRlYmJiOWY5MDFmYjZhMzY4ZDY2MGI1Njc0MTE0N2VmYWQ0MDg2MDA4YzIwZDllMGM0ZTJlMWJlYzQ2YTJmMGEiLCJ0YWciOiIifQ%3D%3D; expires=Mon, 04-May-2020 04:01:03 GMT; path=/; secure; httponly ◀RSVP_status=eyJpdiI6IldMMnJzTHJxMnAzOHJvNnlFVi8wbVE9PSIsInZhbHVlIjoiM3g5emdEYVg4NHh5UitTMnlTcGswYlloQ0lKSVNLc0IzbzdIZm5NVkFCVGhLbG1SQmN2ODZZRnVGRHpOd3ZEbSIsIm1h ▶" ] ]
0 of 0array:3 [▼ "_token" => "eZDpV3VnSD1HNZO5pM9UFNWdE9TPnofz5mPANDua" "_previous" => array:1 [▶ "url" => "https://staging.freepokernetwork.com/player/doug-moran" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]