业务逻辑sql,一对多，取多中的一条信息（特定条件）-526互联

        SELECT
        a.id projectId,
        a.`code`,
        a.`name`,
        a.ext_string_value_26 priority,
        a.ext_string_value_9 bearerDepartment,
        a.create_time createTime,
        a.ext_string_value_6 functionary,
        a.`ext_string_value_35`,
        e.kind,
        e.version,
        e.flow_id
        FROM
        (SELECT b.* FROM ( SELECT max( version ) AS version, technique_id FROM xx_project_technique_release_five WHERE del_flag = '0' AND efficient = '1' GROUP BY technique_id ) a
        LEFT JOIN tm_project_technique_release_five b ON b.version = a.version
        AND a.technique_id = b.technique_id
        AND b.del_flag = '0'
        AND b.efficient = '1'
        ) e
        LEFT JOIN `xxx-project`.proj_elproject a ON e.technique_id = a.ext_string_value_35
        LEFT JOIN xx_project_technique_release b ON e.flow_id = b.flow_id
        LEFT JOIN `xxx-project`.proj_elprojectmember c ON c.object_id = a.id
        LEFT JOIN `xxx-system`.sys_eluser d ON c.user_id = d.id
        WHERE 1 = 1
        and a.del_flag = '0'
        AND c.role_key = 'PM'
        AND c.is_key_member = '0'

//左链接动态获取一对多中  取多中距离当前时间最近的一条数据
LEFT JOIN tm_project_technique_release b ON end_time = ( SELECT MAX( end_time ) FROM tm_project_technique_release WHERE b.project_id = a.id )

逻辑

条件