ID_, ORIGINAL_ID_, NAME_, APPERTAIN_SYSTEM_, APPERTAIN_SUNWAY_, APPLICATION_INTRODUCTION_, CURRENT_STATE_, AUDIT_STATUS_, CLASSIFIED_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_TIME_, LAST_TIME_, CASE_, IS_BRING_INTO_ SELECT * FROM( SELECT *, ROW_NUMBER()OVER(PARTITION BY ORIGINAL_ID_ ORDER BY CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ON_LINE_APPLICATION WHERE IS_DELE_='0') WHERE NUM=1 AND CREATE_ORG_ID_=#{unitId} SELECT o.* FROM BIZ_DIGITAL_CONSTRUCTION c JOIN BIZ_DIGITAL_ADVANCE_CONSTRUCTION a ON c.ID_=a.DIGITAL_ID_ JOIN BIZ_DIGITAL_ON_LINE_APPLICATION o ON a.PUSH_ID_=o.ID_ WHERE a.IS_DELE_='0' AND c.IS_DELE_='0' and o.IS_DELE_='0' and a.CATEGORY_TYPE_=3 AND c.ID_=#{id} SELECT o.*,case when o.cid !=#{id} then 0 else 1 end as isNow FROM (SELECT o.*,c.ID_ as cid,ROW_NUMBER()OVER(PARTITION BY o.ORIGINAL_ID_ ORDER BY o.CREATE_TIME_ DESC)NUM FROM BIZ_DIGITAL_ON_LINE_APPLICATION o INNER JOIN BIZ_DIGITAL_ADVANCE_CONSTRUCTION a ON o.ID_=a.PUSH_ID_ INNER JOIN BIZ_DIGITAL_CONSTRUCTION c ON a.DIGITAL_ID_=c.ID_ WHERE o.is_dele_ = '0' and a.is_dele_='0' and c.is_dele_='0' and a.CATEGORY_TYPE_ = 3 and c.status_ in (3,4))o WHERE o.num=1 and o.create_org_id_=#{unitId} ORDER BY case when o.cid !=#{id} then 0 else 1 end desc, o.CREATE_TIME_ ASC SELECT * FROM( SELECT o.*, ROW_NUMBER()OVER(PARTITION BY o.ORIGINAL_ID_ ORDER BY o.CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ON_LINE_APPLICATION o INNER JOIN BIZ_DIGITAL_ADVANCE_CONSTRUCTION a ON o.ID_=a.PUSH_ID_ INNER JOIN BIZ_DIGITAL_CONSTRUCTION c ON a.DIGITAL_ID_=c.ID_ WHERE o.IS_DELE_='0' AND a.IS_DELE_='0' AND c.IS_DELE_='0' AND o.AUDIT_STATUS_=2 AND c.STATUS_=4) as o ${ew.customSqlSegment} SELECT * FROM( SELECT *, ROW_NUMBER()OVER(PARTITION BY ORIGINAL_ID_ ORDER BY CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ON_LINE_APPLICATION WHERE IS_DELE_='0')o ${ew.customSqlSegment}