FighterController.php#1140devpflmma_web3.6msSELECT
CONCAT(f.first_name, ' ', f.last_name) as name,
f.*,
fr.*,
fc.name AS category_name,
fc.shortcode AS shortcode,
IF(
IFNULL(f.nation_flag, '')<>''OR f.nation_flag<>'',
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/', f.nation_flag, '.jpg'),
CONCAT('https://pflmma-dev.s3.amazonaws.com/flags/icons/default.jpg')
) AS flag_url
FROM
fighters f
LEFTJOIN
fighter_records fr
ON
f.id = fr.fighter_id
AND
fr.season_id ='6'LEFTJOIN
fighter_classes fc
ON
fc.id = fr.fighter_class_id
WHERE
fr.season_id ='6'AND
FIND_IN_SET(fc.shortcode, 'featherweight,heavyweight,lightheavyweight,lightweight,welterweight,women_lightweight')
AND
IFNULL(fr.hide_standings, 0) <>1ORDERBYCAST(IF(IFNULL(fr.ranking, '')=''OR fr.ranking=0, 999, fr.ranking) AS UNSIGNED) ASC,
CASE fr.final_decision
WHEN'playoffs_alternate'THEN'0'WHEN'eliminated'THEN'1'END,
f.first_name ASC