[]
[]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "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" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "dev.bellator.com" ] ]
[]
0 of 0array:3 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 08 Apr 2025 19:16:21 GMT" ] ]
0 of 0array:1 [▼ "_token" => "svknflF42nVpuJQjVMMTngEnzaITrqaHBp9E2mbe" ]
1 x Application (89.97%) | 125ms |
1 x Preparing Response (35.81%) | 49.67ms |
1 x Booting (10.03%) | 13.91ms |
1 x Routing (1.01%) | 1.41ms |
14 x View (0%) | 0μs |
Backtrace |
|
select * from `seasons` where `season_type` = 'bcs'
Bindings |
|
Backtrace |
|
select * from `seasons` where `year` = '2024' and `season_type` = 'bcs' limit 1
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'amateur_flyweight' limit 1
Bindings |
|
Backtrace |
|
select "AMATEUR FLYWEIGHT" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 78 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'bantamweight' limit 1
Bindings |
|
Backtrace |
|
select "Bantamweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 29 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'catchweight' limit 1
Bindings |
|
Backtrace |
|
select "Catchweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 38 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'featherweight' limit 1
Bindings |
|
Backtrace |
|
select "Featherweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 30 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'heavyweight' limit 1
Bindings |
|
Backtrace |
|
select "Heavyweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 27 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'lightheavyweight' limit 1
Bindings |
|
Backtrace |
|
select "Light Heavyweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 36 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'lightweight' limit 1
Bindings |
|
Backtrace |
|
select "Lightweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 28 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'middleweight' limit 1
Bindings |
|
Backtrace |
|
select "Middleweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 35 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'welterweight' limit 1
Bindings |
|
Backtrace |
|
select "Welterweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 34 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select * from `fighter_classes` where `shortcode` = 'women_featherweight' limit 1
Bindings |
|
Backtrace |
|
select "Women\'s Featherweight" AS fighter_class_name, `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/", f.nation_flag, ".jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg")
) AS flag_url,
IF(
IFNULL(f.nation_flag, "")<>"" OR f.nation_flag<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/", f.nation_flag, "_BACKDROP.jpg"),
CONCAT("https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg")
) AS flag_backdrop_url,
IF(
IFNULL(m.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m.directory, "/", m.filename, ".", m.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-", f.gender, ".png")
) AS headshot_url,
IF(
IFNULL(m2.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m2.directory, "/", m2.filename, ".", m2.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-", f.gender, ".png")
) AS bodyshot_url from `fighters` as `f` inner join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 14 left join `mediables` as `med` on `med`.`mediable_id` = `f`.`id` and `med`.`tag` = 'headshot' and `med`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m` on `m`.`id` = `med`.`media_id` left join `mediables` as `med2` on `med2`.`mediable_id` = `f`.`id` and `med2`.`tag` = 'bodyshot' and `med2`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m2` on `m2`.`id` = `med2`.`media_id` where `fr`.`fighter_class_id` = 70 and IFNULL(fr.hide_roster, 0) <> 1 order by `f`.`first_name` asc, `f`.`last_name` asc
Bindings |
|
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '26718' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '24074' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '24072' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '24075' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '27787' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '23575' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '23576' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '27603' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '27604' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '27605' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '27606' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '26409' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '26408' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '26407' limit 1
Bindings |
|
Backtrace |
|
select * from `media` where `media`.`id` = '26540' limit 1
Bindings |
|
Backtrace |
|