求助个多表查询的mysql语句

如图所示

纯手写，望采纳

SELECT
    MC.id,
    MC.NAME,
    MC.parition,
    MC.MSD,
    MC.YED,
    MC.CED,
    Mai_REC.REC_MC_id,
  Mai_REC.REC_anduser_id,   
    Mai_REC.REC_EndTime,
    anduser.name
FROM
    MC
    INNER JOIN (
    SELECT
        a.* 
    FROM
        Mai_Rec a
        INNER JOIN ( SELECT REC_MC_id, max( REC_End_Time ) AS REC_End_Time FROM Mai_Rec GROUP BY REC_MC_id ) b ON a.REC_MC_id = b.REC_MC_id 
    AND a.REC_End_Time = b.REC_End_Time 
    ) Mai_REC ON MC.MC_id = Mai_REC.REC_MC_id
    inner join anduser on Mai_REC.REC_anduser_id = anduser.id;

关键是查询出表二的数据，分组内排序时间字段（采用自关联），然后再三张表关联。