Fight Card
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
5/5
strikes landed / thrown
1/1
2/2
arm strikes landed / thrown
0/0
1/1
leg strikes landed / thrown
1/1
2/2
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
12/16
strikes landed / thrown
9/17
0/3
arm strikes landed / thrown
9/17
4/5
leg strikes landed / thrown
0/0
8/8
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
6/19
strikes landed / thrown
12/18
6/19
arm strikes landed / thrown
5/10
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
7/8
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
60/105
strikes landed / thrown
26/67
6/79
arm strikes landed / thrown
3/63
9/26
leg strikes landed / thrown
1/4
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
110/124
strikes landed / thrown
4/22
45/89
arm strikes landed / thrown
0/18
1/25
leg strikes landed / thrown
0/2
0/10
ground strikes landed / thrown
0/2
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
124/158
strikes landed / thrown
52/80
28/53
arm strikes landed / thrown
1/13
5/8
leg strikes landed / thrown
6/28
12/97
ground strikes landed / thrown
0/39
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
84/124
strikes landed / thrown
46/78
13/96
arm strikes landed / thrown
4/51
2/7
leg strikes landed / thrown
12/23
20/21
ground strikes landed / thrown
3/4
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
19/60
strikes landed / thrown
86/133
6/49
arm strikes landed / thrown
7/74
1/8
leg strikes landed / thrown
8/50
0/3
ground strikes landed / thrown
0/9
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
80/161
strikes landed / thrown
54/97
31/131
arm strikes landed / thrown
13/60
8/30
leg strikes landed / thrown
7/37
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
19/39
strikes landed / thrown
115/147
2/25
arm strikes landed / thrown
19/97
2/8
leg strikes landed / thrown
4/11
0/6
ground strikes landed / thrown
0/39
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
45/70
strikes landed / thrown
53/67
0/2
arm strikes landed / thrown
0/8
0/4
leg strikes landed / thrown
0/4
13/64
ground strikes landed / thrown
16/55
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
Sat September 30
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
Top Strike Speed
- MPH
Top Kick Speed
- MPH
Fighter Tracking
0%
0%
-
Fighter Performance
Rating
-
128/196
strikes landed / thrown
33/82
5/80
arm strikes landed / thrown
3/53
13/82
leg strikes landed / thrown
9/29
31/34
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
-
dominant positions
-
NaNm NaNs
ground time
NaNm NaNs
NaNm NaNs
standing time
NaNm NaNs
0%
Inner Zone
0%
0%
Outer Zone
0%
[]
[]
0 of 0array:16 [▼ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik0rRlJoNitRN0hTSzdlTkZzalFTUWc9PSIsInZhbHVlIjoiMTV3N3JzZU9CUjhsSXlhUFZwbFVuT2R4QzdCT3RaRkhGSFphYy9OYVVnT2h6Z3ZidlU4YWtGUWhHelNweXBKUC9PUWFmZFlxVDFEa2U0RUtRZ3g1Y00vS2thOWJMWVFEZWlyYlc2K3U4bzkyWlpscTU1OEh3KzVzVGUxdlg5cWYiLCJtYWMiOiI2MGUzMjkzNjNhOWNlYWUwMTYxMjkxYzRkYTdhZjdmZWJjNDFjNjQxZmIzNWZjMGY4MWM0ZjEzZWRmY2JiOGE0IiwidGFnIjoiIn0%3D; pfl_session=eyJpdiI6Inp6ZUpyekNTNktqUkhaUXZHcFVIelE9PSIsInZhbHVlIjoiZXBVaS9td2xaT3JlVHdBUHJ0OER4cjBSdDZVY0pIZmZmbUdHOGVoeklKRHZMNEpHV2dmSkZnM0F4Vk9sd0sydCs1enVWRHZWQ2pyVHAySXd6VXc3dVAvNk1MSUN4MlM3WnNxeTFHZlhaWXBJTkJReUVVNXgxeWNhTmJTbWxGUkUiLCJtYWMiOiJmMGNkNzhlZjVmMDdlMWYzNGViZWNlMjAxY2E2ZTczMTEwMDM4MDg4ZjViMTJjMjY0NGUxNjY0ODc4NjEwMDdhIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6Ik0rRlJoNitRN0hTSzdlTkZzalFTUWc9PSIsInZhbHVlIjoiMTV3N3JzZU9CUjhsSXlhUFZwbFVuT2R4QzdCT3RaRkhGSFphYy9OYVVnT2h6Z3ZidlU4YWtGUWhHelNweXBKUC9PUWFmZ ▶" ] "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:2 [▼ "XSRF-TOKEN" => "grSsA0L43SBEGF5aoIAeEg5OXD1lYTphbEybS09Y" "pfl_session" => "W5Zg12qs2FmdEDE8mOH9CaGbmS26ICB36PW6pBMF" ]
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 => "Thu, 24 Apr 2025 21:07:40 GMT" ] ]
0 of 0array:4 [▼ "_token" => "grSsA0L43SBEGF5aoIAeEg5OXD1lYTphbEybS09Y" "PHPDEBUGBAR_STACK_DATA" => array:1 [▶ "01JSMT19WQPX4MV4BRPY7NW05K" => null ] "_previous" => array:1 [▶ "url" => "https://dev.bellator.com/europe-event/2023-pfl-europe-3" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]
1 x Application (99.35%) | 1.64s |
1 x Preparing Response (3.19%) | 52.54ms |
1 x Booting (0.65%) | 10.63ms |
1 x Routing (0.07%) | 1.07ms |
40 x View (0%) | 0μs |
# Query soft and hard limit for Debugbar are reached. Only the first 100 queries show details. Queries after the first 500 are ignored. Limits can be raised in the config (debugbar.options.db.soft/hard_limit).
Backtrace |
|
select * from `events` where `slug` = '2023-pfl-europe-3' limit 1
Bindings |
|
Backtrace |
|
select * from `seasons` where `seasons`.`id` = 8 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` = 64 and `mediables`.`mediable_type` = 'App\\Models\\Event' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `seasons` where `season_type` = 'europe'
Bindings |
|
Backtrace |
|
select * from `events` where `season_id` = 8 order by `datetime` asc
Bindings |
|
Backtrace |
|
select * from `events` where `season_id` = 13 order by `datetime` asc
Bindings |
|
Backtrace |
|
select * from `events` where `season_id` = 19 order by `datetime` asc
Bindings |
|
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select * from `events` where `events`.`id` = 64 limit 1
Bindings |
|
Backtrace |
|
select * from `seasons` where `seasons`.`id` = 8 limit 1
Bindings |
|
Backtrace |
|
SELECT
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 = 8
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 8
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 8
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 8
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-pfl-europe-3'
ORDER BY
fc.order_number ASC
Backtrace |
|
select * from `events` where `slug` = '2023-pfl-europe-3' limit 1
Bindings |
|
Backtrace |
|
select * from `seasons` where `seasons`.`id` in (8)
Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'
Bindings |
|
Backtrace |
|
select * from `events` where `events`.`id` = 64 limit 1
Bindings |
|
Backtrace |
|
select * from `seasons` where `seasons`.`id` = 8 limit 1
Bindings |
|
Backtrace |
|
SELECT
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 = 8
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 8
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 8
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 8
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-pfl-europe-3'
ORDER BY
fc.order_number ASC
Backtrace |
|
select * from `events` where `slug` = '2023-pfl-europe-3' limit 1
Bindings |
|
Backtrace |
|
select * from `seasons` where `seasons`.`id` = 8 limit 1
Bindings |
|
Backtrace |
|
select * from `fighter_stats` where `event_tag` = '2023-pfl-europe-3'
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 261 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 562 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` = 261 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 562 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 562 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 562 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 432 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 517 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` = 432 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 432 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 432 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 517 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 517 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 517 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 424 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 436 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` = 424 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 424 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 424 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 436 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 436 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 436 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 513 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 514 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` = 513 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 513 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 513 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 514 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 514 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 514 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 594 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 601 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` = 594 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 594 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 594 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 601 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 601 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 601 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 426 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 461 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` = 426 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 461 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 461 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 461 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 261 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 441 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` = 261 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 441 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 441 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 441 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 322 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 507 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` = 322 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 322 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 322 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 507 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 507 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 507 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 424 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 426 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` = 424 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 424 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 424 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 426 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 261 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 432 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` = 261 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 261 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 432 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 432 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 432 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 426 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 542 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` = 426 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 426 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 542 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 542 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 542 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 594 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 601 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` = 594 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 594 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 594 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 601 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 601 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 601 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 521 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 523 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` = 521 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 521 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 521 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = 523 and `mediables`.`mediable_type` = 'App\\Models\\Fighter' order by `order` asc
Bindings |
|
Backtrace |
|
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = 523 and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = 523 and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 419 limit 1
Bindings |
|
Backtrace |
|
select * from `fighters` where `fighters`.`id` = 516 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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where `fighters`.`id` = ? limit 1
select * from `fighters` where `fighters`.`id` = ? limit 1
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` left join `fighter_classes` as `fc` on `fc`.`id` = `fighter_records`.`fighter_class_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null and `s`.`year` in (select `year` from (select `s`.`year` from `fighter_records` left join `seasons` as `s` on `s`.`id` = `fighter_records`.`season_id` where `fighter_records`.`fighter_id` = ? and `fighter_records`.`fighter_id` is not null order by `s`.`year` desc limit 1) as `latest_year`) order by `s`.`year` desc
select * from `fighters` where CONCAT(first_name, " ", last_name) = "TBA TBA" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Cédric Doumbé" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Ali Taleb" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Khurshed Kakhorov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "John Mitchell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Alex Chizov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Lizzy Gevers" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Valentina Scatizzi" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Shanelle Dyer" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Luisa Fernanda Cifuentes" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dakota Ditcheva" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Quemuel Ottoni" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "TBA TBA" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Anthony Salamone" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Simeon Powell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Daniel Ladero" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "John Mitchell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dakota Ditcheva" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "TBA TBA" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Ali Taleb" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dakota Ditcheva" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Malin Hermansson" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Shanelle Dyer" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Luisa Fernanda Cifuentes" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dylan Tuke" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jakub Kaszuba" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Mokhtar Benkaci" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Frans Mlambo" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Ali Taleb" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Khurshed Kakhorov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Laureano Staropoli" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Baba Boundjou Nadjombe" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Yazid Chouchane" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Henrique Madureira" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dakota Ditcheva" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Cornelia Holm" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Simeon Powell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Daniel Ladero" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Anthony Salamone" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jakob Nedoh" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Abdoul Abdouraguimov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Brad Wheeler" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Cédric Doumbé" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jordan Zebo" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Shanelle Dyer" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Luisa Fernanda Cifuentes" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "John Mitchell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Geisym Derouiche" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dylan Tuke" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jakub Kaszuba" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Mokhtar Benkaci" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Frans Mlambo" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Ali Taleb" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Khurshed Kakhorov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Laureano Staropoli" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Baba Boundjou Nadjombe" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Yazid Chouchane" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Henrique Madureira" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Dakota Ditcheva" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Cornelia Holm" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Simeon Powell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Daniel Ladero" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Anthony Salamone" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jakob Nedoh" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Abdoul Abdouraguimov" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Brad Wheeler" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Cédric Doumbé" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Jordan Zebo" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "TBA TBA" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Francesco Nuzzi" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Simeon Powell" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Ali Taleb" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Mokhtar Benkaci" limit 1
select * from `fighters` where CONCAT(first_name, " ", last_name) = "Francesco Nuzzi" limit 1
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
select * from `fighters` where `id` in (?, ?)
select `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` desc
select `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` desc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
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` = ? and `mediables`.`mediable_type` = ? order by `order` asc
... 212 additional queries are executed but now shown because of Debugbar query limits. Limits can be raised in the config (debugbar.options.db.soft/hard_limit)