sql 2018-06-08

select DISTINCT i.*,
    (select name from T_SYS_USER u where  u.ID =i.PERSON_IN_CHARGE )  as USER_NAME,
     (SELECT to_char(COUNT(rd.AUDIT_RESULTS))  from T_CSEPRO_REVIEW_DETAIL rd where 
      rd.REVIEW_ID =r.ID AND rd.AUDIT_RESULTS='1' 
      AND  rd.INDEX_ID IN ( SELECT t.INDEX_ID from T_CSEPRO_TASK  t WHERE  t.INDEX_ID =i.ID ) )
    AS taskFlag,
       (SELECT to_char(count(1)) from T_CSEPRO_TASK  t WHERE t.INDEX_ID =i.ID )  AS taskCount
    FROM T_CSEPRO_INDEX i 
    LEFT JOIN T_CSEPRO_REVIEW r ON r.PROJECT_ID =i.PROJECT_ID AND r.TYPE='4'
      WHERE  i.ID ='F4D875B59AE8438A9B986949F16A10FD'
    AND i.PROJECT_ID = '7C7CF04CC3E74FE28CD13025FAECE03C'
    
    SELECT * from T_CSEPRO_TASK  t WHERE  t.INDEX_ID ='F4D875B59AE8438A9B986949F16A10FD'
    
 SELECT * from T_CSEPRO_REVIEW
    
    SELECT rd.*  from T_CSEPRO_REVIEW_DETAIL rd where 
      rd.REVIEW_ID ='15cb27bbe0644254a799f583914358e9' AND rd.AUDIT_RESULTS='1' 
      AND  rd.INDEX_ID IN ('F4D875B59AE8438A9B986949F16A10FD')

T_CSEPRO_REVIEW
T_CSEPRO_TASK
T_CSEPRO_REVIEW_DETAIL