Test
Career Record: 5-1-0
2025 World Tournament: 0-0-0
2025 World Tournament: 0-0-0
2024 Champions Series: 0-0-0
2023 Challenger Series: 0-0-0
Max Punch Speed
-
Strikes
-
Arm Strikes
-
Leg Strikes
-
Ground Strikes
-
Takedowns
-
Inner zone
-
Outer zone
-
Max Punch Speed
-
Strikes
98 / 119
Arm Strikes
6 / 20
Leg Strikes
1 / 2
Ground Strikes
17 / 97
Takedowns
0 / 0
Inner zone
-
Outer zone
-
Max Punch Speed
-
Strikes
77 / 85
Arm Strikes
1 / 1
Leg Strikes
4 / 4
Ground Strikes
72 / 80
Takedowns
2 / 3
Inner zone
-
Outer zone
-
Winner
Trabelsi vs Bably
PFL 2024 Heavyweight
Fri November 29
Winner
Sutherland vs Bably
PFL 2022 Heavyweight
Sat August 20
[]
[]
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.pflmma.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 => "Fri, 11 Apr 2025 17:25:18 GMT" ] ]
0 of 0array:1 [▼ "_token" => "NGKTYlFcUphy9As38pKqTYkWjaJLChxvDjMfZ5V0" ]
| 1 x Application (96.18%) | 358ms |
| 1 x Preparing Response (10.9%) | 40.58ms |
| 1 x Booting (3.82%) | 14.22ms |
| 1 x Routing (0.35%) | 1.29ms |
| 15 x View (0%) | 0μs |
# Query soft limit for Debugbar is reached after 100 queries, additional 68 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)| Backtrace |
|
select * from `fighters` where LOWER(REPLACE(REPLACE(first_name, " ", ""), "'", "")) = "abraham" and LOWER(REPLACE(REPLACE(last_name, " ", ""), "'", "")) = "bably" limit 1| Backtrace |
|
select * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 429 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 18 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 429 and `s`.`year` <> '2020' order by `s`.`year` desc| Bindings |
|
| Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 429 and `s`.`year` = 2025 order by `s`.`year` desc| Bindings |
|
| Backtrace |
|
select * from `fighter_records` as `fr` left join `seasons` as `s` on `s`.`id` = `fr`.`season_id` where `fr`.`fighter_id` = 429 and `s`.`year` <> '2020' order by `s`.`year` desc limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 18 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 429 and `s`.`year` <> '2020' order by `s`.`year` desc| Bindings |
|
| Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 429 and `s`.`year` = 2025 order by `s`.`year` desc| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighter_records` where `fighter_id` = 429 and `season_id` = 17 limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.StrikesLanded),0), ' / ', TRUNCATE(SUM(fs.StrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.ArmStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.ArmStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.LegStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.LegStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.GroundStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.GroundStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.Takedowns),0), ' / ', TRUNCATE(SUM(fs.TakedownAttempts),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeInnerZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeOuterZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '17'
WHERE
1=1
AND fs.season_year = '2025' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2025 limit 1| Bindings |
|
| Backtrace |
|
SELECT
f.id,
CONCAT(f.first_name,' ',f.last_name) AS Name,
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
`fighter_stats` fs
INNER JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id=17
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2025'
GROUP BY
f.id, f.first_name, f.last_name
ORDER BY CONVERT(MAX(fs.MaxPunchSpeed), DECIMAL) DESC
LIMIT 5| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 416 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 416 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 171 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 171 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 621 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 621 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 716 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 716 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 922 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 922 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighter_records` where `fighter_id` = 429 and `season_id` = 10 limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.StrikesLanded),0), ' / ', TRUNCATE(SUM(fs.StrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.ArmStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.ArmStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.LegStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.LegStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.GroundStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.GroundStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.Takedowns),0), ' / ', TRUNCATE(SUM(fs.TakedownAttempts),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeInnerZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeOuterZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '10'
WHERE
1=1
AND fs.season_year = '2024' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2024 limit 1| Bindings |
|
| Backtrace |
|
SELECT
f.id,
CONCAT(f.first_name,' ',f.last_name) AS Name,
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
`fighter_stats` fs
INNER JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id=10
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2024'
GROUP BY
f.id, f.first_name, f.last_name
ORDER BY CONVERT(MAX(fs.MaxPunchSpeed), DECIMAL) DESC
LIMIT 5| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 844 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 844 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 842 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 842 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 690 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 690 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 698 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 698 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 691 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 691 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighter_records` where `fighter_id` = 429 and `season_id` = 7 limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.StrikesLanded),0), ' / ', TRUNCATE(SUM(fs.StrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.ArmStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.ArmStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.LegStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.LegStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.GroundStrikesLanded),0), ' / ', TRUNCATE(SUM(fs.GroundStrikesThrown),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
CONCAT(TRUNCATE(SUM(fs.Takedowns),0), ' / ', TRUNCATE(SUM(fs.TakedownAttempts),0)) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeInnerZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
TRUNCATE(SUM(fs.ElapsedTimeOuterZone),0) AS Value
FROM
fighter_stats fs
LEFT JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id = '7'
WHERE
1=1
AND fs.season_year = '2023' AND f.id='429'| Backtrace |
|
select * from `seasons` where `year` = 2023 limit 1| Bindings |
|
| Backtrace |
|
SELECT
f.id,
CONCAT(f.first_name,' ',f.last_name) AS Name,
TRUNCATE(MAX(fs.MaxPunchSpeed),2) AS Value
FROM
`fighter_stats` fs
INNER JOIN
fighters f
ON
f.id = fs.fighter_id
LEFT JOIN
fighter_records fr
ON
fr.fighter_id = fs.fighter_id
AND fr.season_id=7
LEFT JOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
1=1
AND fs.season_year = '2023'
GROUP BY
f.id, f.first_name, f.last_name
ORDER BY CONVERT(MAX(fs.MaxPunchSpeed), DECIMAL) DESC
LIMIT 5| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 384 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 384 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 454 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 454 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 234 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 234 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 405 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 405 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = 75 limit 1| Bindings |
|
| Backtrace |
|
select `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = 75 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc| Bindings |
|
| Backtrace |
|
select `f`.*, `fr`.`points`, `fr`.`season_record`, `fr`.`ranking`, `fr`.`final_decision`, `fc`.`name` as `fighter_class_name`,
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,
IF(
IFNULL(m3.filename, "")<>"",
CONCAT("https://pflmma-dev.s3.amazonaws.com/", m3.directory, "/", m3.filename, ".", m3.extension),
CONCAT("https://pflmma-dev.s3.amazonaws.com/fighters/banners/default-banner-", f.gender, ".jpg")
) AS banner_url from `fighters` as `f` left join `fighter_records` as `fr` on `fr`.`fighter_id` = `f`.`id` and `fr`.`season_id` = 18 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` left join `mediables` as `med3` on `med3`.`mediable_id` = `f`.`id` and `med3`.`tag` = 'banner' and `med3`.`mediable_type` = 'App\\Models\\Fighter' left join `media` as `m3` on `m3`.`id` = `med3`.`media_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fr`.`fighter_class_id` where `f`.`id` = 429 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighters` where `fighters`.`id` = ? limit 1(select * from `fight_cards` where `fight_cards`.`fighter_id` = ? and `fight_cards`.`fighter_id` is not null) union (select * from `fight_cards` where `fight_cards`.`vs_fighter_id` = ? and `fight_cards`.`vs_fighter_id` is not null) order by `created_at` descselect `val`, `name` from `settings` where `group` = ?select * from `events` where `events`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1SELECT
e.datetime AS event_datetime,
2025 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
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-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 18
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 18
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 18
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 18
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2025-wt-4'
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
ORDER BY
fc.order_number ASCselect `val`, `name` from `settings` where `group` = ?select * from `events` where `events`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1SELECT
e.datetime AS event_datetime,
2024 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
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-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 15
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 15
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2024-mena-4'
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
ORDER BY
fc.order_number ASCselect `val`, `name` from `settings` where `group` = ?select * from `events` where `events`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1SELECT
e.datetime AS event_datetime,
2024 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
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-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 14
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 14
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 14
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 14
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2024-bcs-1'
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
ORDER BY
fc.order_number ASCselect `val`, `name` from `settings` where `group` = ?select * from `events` where `events`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1SELECT
e.datetime AS event_datetime,
2023 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
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-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 7
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 7
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 7
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 7
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2023-challenger-series-week-3'
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
ORDER BY
fc.order_number ASCselect `val`, `name` from `settings` where `group` = ?select * from `events` where `events`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1SELECT
e.datetime AS event_datetime,
2022 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
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-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 6
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 6
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 6
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 6
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2022-pfl-9'
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
ORDER BY
fc.order_number ASCselect * from `fighters` where `fighters`.`id` = ? limit 1select `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * from `fighters` where `fighters`.`id` = ? limit 1select `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * from `seasons` where `season_type` = ? order by `year` desc limit 1SELECT
e.*
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 16
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 16
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 16
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 16
WHERE
e.season_id=16
AND (fc.fighter_id=429 OR fc.vs_fighter_id=429)
AND
e.datetime>='2025-04-11 13:25:18'
AND
e.event_status = 'scheduled'
ORDER BY
fc.order_number ASCselect * from `seasons` where `seasons`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1select * from `seasons` where `seasons`.`id` = ? limit 1select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1