주메뉴 바로가기 검색 바로가기 본문 바로가기

오마이컴퍼니

회원 메뉴

공지

오마이컴퍼니의 다양한 소식을 알려드립니다.

test table
등록일
2019-08-27
등록자
오마이컴퍼니

SQL:::       SELECT     COUNT(PROJECT_SEQ) AS OPEN_PROJECT_COUNT    FROM TB_OMC_PROJECT_MASTER    WHERE OPEN_ID = '207079'    AND REG_STATE IN ('STATUS_0003', 'STATUS_0005', 'STATUS_0006', 'STATUS_0007')    AND DEL_FLAG = 'N'    AND INVEST_END_DATE > NOW()
SQL:::       SELECT     COUNT(INVEST_SEQ) AS OPEN_PROJECT_COUNT    FROM TB_OMC_INVEST_PROJECT    WHERE MEMBER_SEQ = '207079'    AND DEL_FLAG = 'N'    AND FUNDING_END_DATE > NOW()    AND REG_STATE IN ('STATUS_0003', 'STATUS_0005', 'STATUS_0006', 'STATUS_0007')     
SQL:::       SELECT     COUNT(*) AS INVESTOR_COUNT    FROM TB_OMC_PROJECT_INVESTOR TI    INNER JOIN TB_OMC_PROJECT_MASTER TM    ON TI.PROJECT_SEQ = TM.PROJECT_SEQ    WHERE TM.REG_STATE IN ('STATUS_0006', 'STATUS_0007')    AND TM.INVEST_END_DATE > NOW()    AND TM.DEL_FLAG = 'N'    AND TI.MEMBER_SEQ = '207079'    AND TI.INCOMING_CHK = '0'
SQL:::       SELECT     COUNT(*) AS INVESTOR_COUNT    FROM TB_OMC_INVEST_SUBSCRIBE TS    INNER JOIN TB_OMC_INVEST_PROJECT TP ON TS.INVEST_SEQ = TP.INVEST_SEQ AND TP.REG_STATE IN ('STATUS_0006', 'STATUS_0007') AND TP.DEL_FLAG = 'N' AND TP.FUNDING_END_DATE > NOW()    INNER JOIN TB_OMC_INVEST_INVESTOR TI ON TS.INVESTOR_SEQ = TI.INVESTOR_SEQ AND TI.DEL_FLAG = 'N'    WHERE TS.DEL_FLAG = 'N'    AND TS.CANCEL_DATE IS NULL    AND TI.MEMBER_SEQ = '207079'
SQL:::       SELECT     COUNT(*) AS SUCCESS_PROJECT_COUNT    FROM TB_OMC_PROJECT_INVESTOR TI    WHERE TI.INCOMING_CHK = 0    AND TI.MEMBER_SEQ = '207079'    AND TI.PROJECT_SEQ IN (     SELECT      TM.PROJECT_SEQ     FROM TB_OMC_PROJECT_MASTER TM     WHERE TM.REG_STATE = 'STATUS_0006'     AND DATE_ADD(TM.INVEST_END_DATE, INTERVAL 11 DAY) > NOW()     AND TM.SUCCESS_FLAG = 'Y'     AND TM.DEL_FLAG = 'N'     AND TM.OPEN_FLAG = 'Y'    )
SQL:::       SELECT     COUNT(*) AS SUCCESS_PROJECT_COUNT    FROM TB_OMC_INVEST_SUBSCRIBE TS    INNER JOIN TB_OMC_INVEST_INVESTOR TI ON TS.INVESTOR_SEQ = TI.INVESTOR_SEQ AND TI.DEL_FLAG = 'N'    WHERE TS.DEL_FLAG = 'N'    AND TS.CANCEL_DATE IS NULL    AND TI.MEMBER_SEQ = '207079'    AND TS.INVEST_SEQ IN (     SELECT      TP.INVEST_SEQ     FROM TB_OMC_INVEST_PROJECT TP     WHERE TP.REG_STATE = 'STATUS_0006'     AND DATE_ADD(TP.PUBLISH_DATE, INTERVAL 6 DAY) > NOW()     AND TP.SUCCESS_FLAG = 'Y'     AND TP.DEL_FLAG = 'N'     AND TP.OPEN_FLAG = 'Y'    )

 

 

열1 열2 열3 열4 열5 열6 열7 열8 열9 열10 열11 열12 열13
abcdetgeghijk                        
b                        
c                        
d                        
e                        
f                        
g                        
h                        
i                        
j                        
k                        
l                        
m                        
n                        
o                        

 

댓글달기

댓글