Test
- 4d
- 17h
- 26m
- 30s
Fight Card
Fri May 10
Abdullah Al-Qahtani
vs
Yazeed Hasanain
1-0-0
9-2-0
0
5'9"
145 LBS
74"
40"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
3-2-0
0
5'10
155 LBS
-
-
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Ali Taleb
vs
Nawras Abzakh
1-0-0
12-1-0
0
5'7"
135 LBS
69"
38"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
11-6-0, NC
0
5'10
155 LBS
68"
39"
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Xavier Alaoui
vs
Rachid Haz
0-1-0
14-1-0
0
5'6
155 LBS
-
-
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
1-0-0
15-4-0
0
5'7"
135 LBS
40"
70.5"
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Islam Reda
vs
Adam Meskini
1-0-0
11-1-0
0
5'7
155 LBS
-
-
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
9-3-0
0
5'9
155 LBS
-
-
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Tariq Ismail
vs
Jalal Al Daaja
0-1-0
8-2-0
0
5'8
135 LBS
67"
40"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
1-0-0
12-8-0
0
5'9
135 LBS
-
-
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Elias Boudegzdame
vs
Hassan Mandour
1-0-0
19-9-0
0
5'10
135 LBS
69"
39"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
9-6-0
0
5'7
135 LBS
68"
39"
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Hattan Alsaif
vs
Nada Faheem
1-0-0
3-0-0
0
5'1
105 LBS
60"
36"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
1-1-0
0
5'0
105 LBS
51"
34"
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Marouane Bellagouit
vs
Mido Mohamed
1-0-0
5-2-0
0
5'9"
145 LBS
68"
40"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
6-1-1
0
5'10
155 LBS
68"
39"
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Ahmed Tarek
vs
Abdelrahman Alhyasat
0-1-0
4-1-0
0
5'10
155 LBS
-
-
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
1-0-0
5-0-0
0
5'10
155 LBS
-
-
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Fri May 10
Malik Basahel
vs
Harsh Pandya
1-0-0
21-2-1
0
5'5"
125 LBS
67"
38"
-
2024 PFL Record
Career Record
Points
Height
Weight
Arm Reach
Leg Reach
Odds
0-1-0
3-2-0
0
5'10
125 LBS
-
-
-
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
Top Strike Speed
0 MPH
Top Kick Speed
0 MPH
Fighter Tracking
0%
0%
0/0
Fighter Performance
Rating
0/0
0/0
strikes landed / thrown
0/0
0/0
arm strikes landed / thrown
0/0
0/0
leg strikes landed / thrown
0/0
0/0
ground strikes landed / thrown
0/0
0/0
takedowns / attempts
0/0
0
submission attempts
0
0
knockdowns
0
0
dominant positions
0
0m 0s
ground time
0m 0s
0m 0s
standing time
0m 0s
0%
Inner Zone
0%
0%
Outer Zone
0%
Tickets
[]
[]
0 of 0array:15 [▼ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "dev.pflmma.com" ] ]
[]
0 of 0array:3 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 04 Apr 2025 22:33:24 GMT" ] ]
0 of 0array:1 [▼ "_token" => "MdeYVQGIZblyFmCfovmFC0GWl3XB0EGG2D9GjQSJ" ]
| 1 x Application (98.61%) | 1.03s |
| 1 x Preparing Response (5.24%) | 54.87ms |
| 1 x Booting (1.39%) | 14.52ms |
| 1 x Routing (0.12%) | 1.23ms |
| 31 x View (0%) | 0μs |
# Query soft limit for Debugbar is reached after 100 queries, additional 106 queries only show the query. Limits can be raised in the config (debugbar.options.db.soft_limit)| Backtrace |
|
select * from `events` where `slug` = '2024-mena-1' limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 15 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` = 90 and `mediables`.`mediable_type` = 'App\\Models\\Event' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `seasons` where `season_type` = 'mena'| Bindings |
|
| Backtrace |
|
select * from `events` where `season_id` = 15 order by `datetime` asc| Bindings |
|
| Backtrace |
|
select * from `events` where `season_id` = 20 order by `datetime` asc| Bindings |
|
| Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'| Bindings |
|
| Backtrace |
|
select * from `events` where `events`.`id` = 90 limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 15 limit 1| Bindings |
|
| Backtrace |
|
SELECT
e.datetime AS event_datetime,
2024 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
IF(
IFNULL(m2.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 15
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 15
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2024-mena-1'
ORDER BY
fc.order_number ASC| Backtrace |
|
select * from `events` where `slug` = '2024-mena-1' limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` in (15)| Backtrace |
|
select `val`, `name` from `settings` where `group` = 'default'| Bindings |
|
| Backtrace |
|
select * from `events` where `events`.`id` = 90 limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 15 limit 1| Bindings |
|
| Backtrace |
|
SELECT
e.datetime AS event_datetime,
2024 AS season_year,
s.season_type AS season_type,
e.slug AS event_slug,
fc.order_number,
fc.id AS fight_card_id,
fc.broadcaster,
fc.winner_id,
fc.match_details,
fc.show_keys_to_victory,
fc.show_match_details,
fc.keys_to_victory AS fighter_keys_to_victory,
fc.vs_keys_to_victory AS vs_fighter_keys_to_victory,
fc.override_status,
fc.pickem_status,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.fighter_points, fr1.points) AS fighter_points,
IF(fc.fighter_points>0 OR fc.vs_fighter_points>0 OR fc.fighter_record<>'' OR fc.vs_fighter_record<>'', fc.vs_fighter_points, fr2.points) AS vs_fighter_points,
fr1.points AS fighter_total_points,
fr2.points AS vs_fighter_total_points,
f1.gender AS fighter_gender,
f2.gender AS vs_fighter_gender,
f1.arm_reach AS fighter_arm_reach,
f2.arm_reach AS vs_fighter_arm_reach,
f1.leg_reach AS fighter_leg_reach,
f2.leg_reach AS vs_fighter_leg_reach,
f1.height AS fighter_height,
f2.height AS vs_fighter_height,
f1.weight AS fighter_weight,
f2.weight AS vs_fighter_weight,
fc.win_by,
fc.round_time,
CONCAT(f1.first_name, ' ', f1.last_name) AS fighter_name,
CONCAT(f2.first_name, ' ', f2.last_name) AS vs_fighter_name,
f1.first_name AS fighter_first_name,
f1.last_name AS fighter_last_name,
f2.first_name AS vs_fighter_first_name,
f2.last_name AS vs_fighter_last_name,
f1.id AS fighter_id,
f2.id AS vs_fighter_id,
f1.career_record AS fighter_career_record,
f2.career_record AS vs_fighter_career_record,
fr1.season_record AS fighter_season_record,
fr2.season_record AS vs_fighter_season_record,
f1.nation_flag AS fighter_nation_flag,
f2.nation_flag AS vs_fighter_nation_flag,
f1.challenger_highlights AS challenger_highlights,
f2.challenger_highlights AS vs_challenger_highlights,
fr1.ranking AS fighter_ranking,
fr2.ranking AS vs_fighter_ranking,
fc2.name AS weightclass,
fc2.shortcode AS weightclass_shortcode,
IF(fc.fighter_record<>'', fc.fighter_record, fr1.season_record) AS fighter_fight_card_record,
IF(fc.vs_fighter_record<>'', fc.vs_fighter_record, fr2.season_record) AS vs_fighter_fight_card_record,
b.name AS broadcast_name,
b.url AS broadcast_url,
fc.match_type,
IF(
IFNULL(m1.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m1.directory, '/', m1.filename, '.', m1.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f1.gender, '.png')
) AS fighter_thumbnail,
IF(
IFNULL(m2.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m2.directory, '/', m2.filename, '.', m2.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f1.gender, '.png')
) AS fighter_profile_image,
IF(
IFNULL(m3.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m3.directory, '/', m3.filename, '.', m3.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/headshots/default-', f2.gender, '.png')
) AS vs_fighter_thumbnail,
IF(
IFNULL(m4.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m4.directory, '/', m4.filename, '.', m4.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fighters/bodyshots/default-', f2.gender, '.png')
) AS vs_fighter_profile_image,
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m5.directory, '/', m5.filename, '.', m5.extension) AS broadcast_logo,
IF(
IFNULL(m6.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m6.directory, '/', m6.filename, '.', m6.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f1.gender, '-left.png')
) AS fighter_bodyshot_side,
IF(
IFNULL(m7.filename, '')<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/', m7.directory, '/', m7.filename, '.', m7.extension),
CONCAT('https://pflmma-dev.s3.amazonaws.com/fight_cards/bodyshot_sides/default-', f2.gender, '-right.png')
) AS vs_fighter_bodyshot_side,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f1.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS fighter_flag,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f2.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS vs_fighter_flag,
IF(
IFNULL(f1.nation_flag, '')<>'' OR f1.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f1.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS fighter_flag_backdrop,
IF(
IFNULL(f2.nation_flag, '')<>'' OR f2.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/', f2.nation_flag, '_BACKDROP.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/backdrops/default.jpg')
) AS vs_fighter_flag_backdrop
FROM
fight_cards fc
LEFT JOIN
fighters f1
ON
f1.id = fc.fighter_id
LEFT JOIN
fighters f2
ON
f2.id = fc.vs_fighter_id
INNER JOIN
fighter_classes fc2
ON
fc2.id = fc.fighter_class_id
INNER JOIN
events e
ON
e.id = fc.event_id
LEFT JOIN
seasons s
ON
e.season_id = s.id
LEFT JOIN
broadcasters b
ON
b.shortcode = fc.broadcaster
LEFT JOIN
fighter_records fr1
ON
fr1.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.fighter_id
LIMIT 1
)
AND
fr1.season_id = 15
LEFT JOIN
fighter_records fr2
ON
fr2.fighter_id = (
SELECT
MIN(id)
FROM
fighter_records
WHERE
season_id = 15
AND
fighter_id = fc.vs_fighter_id
LIMIT 1
)
AND
fr2.season_id = 15
LEFT JOIN
mediables med1
ON
med1.mediable_id=f1.id
AND
med1.tag='headshot'
AND
med1.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m1
ON
m1.id=med1.media_id
LEFT JOIN
mediables med2
ON
med2.mediable_id=f1.id
AND
med2.tag='bodyshot'
AND
med2.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m2
ON
m2.id=med2.media_id
LEFT JOIN
mediables med3
ON
med3.mediable_id=f2.id
AND
med3.tag='headshot'
AND
med3.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m3
ON
m3.id=med3.media_id
LEFT JOIN
mediables med4
ON
med4.mediable_id=f2.id
AND
med4.tag='bodyshot'
AND
med4.mediable_type='App\\Models\\Fighter'
LEFT JOIN
media m4
ON
m4.id=med4.media_id
LEFT JOIN
mediables med5
ON
med5.mediable_id=b.id
AND
med5.tag='logo'
AND
med5.mediable_type='App\\Models\\Broadcaster'
LEFT JOIN
media m5
ON
m5.id=med5.media_id
LEFT JOIN
mediables med6
ON
med6.mediable_id=fc.id
AND
med6.tag='fighter_bodyshot_side_left'
AND
med6.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m6
ON
m6.id=med6.media_id
LEFT JOIN
mediables med7
ON
med7.mediable_id=fc.id
AND
med7.tag='fighter_bodyshot_side_right'
AND
med7.mediable_type='App\\Models\\FightCard'
LEFT JOIN
media m7
ON
m7.id=med7.media_id
WHERE
e.slug = '2024-mena-1'
ORDER BY
fc.order_number ASC| Backtrace |
|
select * from `events` where `slug` = '2024-mena-1' limit 1| Bindings |
|
| Backtrace |
|
select * from `seasons` where `seasons`.`id` = 15 limit 1| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (568, 757)| Bindings |
|
| Backtrace |
|
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` = 568 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 757 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 2043 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1996 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1982 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1979 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1911 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1775 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1762 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1761 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1676 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1666 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1653 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1591 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1566 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1539 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (568, 757)| Bindings |
|
| Backtrace |
|
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` = 568 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 757 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 1317 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1307 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1306 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1257 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1252 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1251 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1239 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1236 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1165 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1160 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1157 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1110 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1108 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1106 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (432, 758)| Bindings |
|
| Backtrace |
|
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` = 432 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 758 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 2044 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1993 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1982 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1980 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1944 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1911 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1774 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1676 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1579 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1561 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1500 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1423 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1367 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1363 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1320 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1319 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (432, 758)| Bindings |
|
| Backtrace |
|
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` = 432 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 758 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 1112 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1111 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1028 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1026 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 1023 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 963 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| 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` = 959 and `mediables`.`mediable_type` = 'App\\Models\\Video' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (759, 575)| Bindings |
|
| Backtrace |
|
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` = 575 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 759 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 1982 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1980 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1942 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1773 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (759, 575)| Bindings |
|
| Backtrace |
|
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` = 575 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 759 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (761, 762)| Bindings |
|
| Backtrace |
|
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` = 761 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 762 and `article_tags`.`article_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = 1980 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1943 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| 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` = 1939 and `mediables`.`mediable_type` = 'App\\Models\\Article' order by `order` asc| Bindings |
|
| Backtrace |
|
select * from `fighters` where `id` in (761, 762)| Bindings |
|
| Backtrace |
|
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` = 761 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` desc| Bindings |
|
| Backtrace |
|
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` = 762 and `video_tags`.`video_tag_type` = 'App\\Models\\Fighter' order by `created_at` 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` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * 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` descselect `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * from `events` where `slug` = ? limit 1select * from `events` where `events`.`id` = ? limit 1select `articles`.*, `article_tags`.`article_tag_id` as `pivot_article_tag_id`, `article_tags`.`article_id` as `pivot_article_id`, `article_tags`.`article_tag_type` as `pivot_article_tag_type` from `articles` inner join `article_tags` on `articles`.`id` = `article_tags`.`article_id` where `article_tags`.`article_tag_id` = ? and `article_tags`.`article_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * from `events` where `events`.`id` = ? limit 1select `videos`.*, `video_tags`.`video_tag_id` as `pivot_video_tag_id`, `video_tags`.`video_id` as `pivot_video_id`, `video_tags`.`video_tag_type` as `pivot_video_tag_type` from `videos` inner join `video_tags` on `videos`.`id` = `video_tags`.`video_id` where `video_tags`.`video_tag_id` = ? and `video_tags`.`video_tag_type` = ? order by `created_at` descselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect `media`.*, `mediables`.`mediable_id` as `pivot_mediable_id`, `mediables`.`media_id` as `pivot_media_id`, `mediables`.`mediable_type` as `pivot_mediable_type`, `mediables`.`tag` as `pivot_tag`, `mediables`.`order` as `pivot_order` from `media` inner join `mediables` on `media`.`id` = `mediables`.`media_id` where `mediables`.`mediable_id` = ? and `mediables`.`mediable_type` = ? order by `order` ascselect * from `seasons` where `seasons`.`id` = ? limit 1select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select `val`, `name` from `settings` where `group` = ?select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1select * from `media` where `media`.`id` = ? limit 1