ID_, ORIGINAL_ID_, NAME_, TYPE_, APPERTAIN_SYSTEM_, APPERTAIN_SUNWAY_, BRIEF_INTRODUCTION_, CURRENT_STATE_, AUDIT_STATUS_, CASE_, IS_BRING_INTO_, 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_ SELECT * FROM( SELECT *, ROW_NUMBER()OVER(PARTITION BY ORIGINAL_ID_ ORDER BY CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ONE_THING 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_ONE_THING 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_=1 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_ONE_THING 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_ = 1 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_ONE_THING 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 c.IS_DELE_='0' AND a.IS_DELE_='0'AND (o.AUDIT_STATUS_ in (3,4,6)) AND c.STATUS_=4) as o ${ew.customSqlSegment} SELECT o.* FROM( SELECT o.*, ROW_NUMBER()OVER(PARTITION BY o.ORIGINAL_ID_ ORDER BY o.CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ONE_THING 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 a.IS_DELE_='0' and c.STATUS_>2 and c.IS_DELE_='0') as o ${ew.customSqlSegment} SELECT * FROM( SELECT *, ROW_NUMBER()OVER(PARTITION BY ORIGINAL_ID_ ORDER BY CREATE_TIME_ DESC) NUM FROM BIZ_DIGITAL_ONE_THING WHERE IS_DELE_='0')o ${ew.customSqlSegment} SELECT o.*,c.status_ FROM BIZ_DIGITAL_CONSTRUCTION c INNER JOIN BIZ_DIGITAL_ADVANCE_CONSTRUCTION a ON c.ID_=a.DIGITAL_ID_ INNER JOIN BIZ_DIGITAL_ONE_THING o ON a.PUSH_ID_=o.ID_ AND o.NAME_ LIKE concat('%',#{name},'%') AND c.UNIT_NAME_ like concat('%',#{unitName},'%') AND o.appertain_System_=#{appertainSystem} AND o.appertain_Sunway_=#{appertainSunway} AND o.IS_DELE_=#{isDele} AND c.status_=#{status} AND o.audit_Status_=#{auditStatus} ORDER BY o.ORIGINAL_ID_,c.UNIT_NAME_