Query for New FYER dropdown

SELECT fg.`ID` new_id, fg.`FyerSaveName` saveName, org.`Status` stat, fg.`FyerYear` fyear FROM fyer_group fg
INNER JOIN organization org ON org.id = fg.`FyerOrg_id`
INNER JOIN (SELECT Max(`FyerYear`)max_yr, `ID`, `FyerOrg_id` org_id FROM fyer_group WHERE `FyerOrg_id` = 56) yrMax ON yrMax.org_id = fg.`FyerOrg_id` AND yrMax.max_yr = fg.`FyerYear` 
WHERE fg.`FyerOrg_id` = 56 AND fg.`FyerFinal` = 'Final'