${IF(AND(len(LOCATION)==0 ,len(EQPGROUP)==0 ,len(EQPID)==0),"SELECT EQPID, STATE, STIME, ETIME, DETAIL, TXNDATE, MOTHEREQP, ROUND(24*(TO_DATE(ETIME,'YYYYMMDD HH24MISS')-TO_DATE(STIME,'YYYYMMDD HH24MISS')),2) PERIOD FROM TMP_TB_TOOL_STATE WHERE 1=1 AND TXNDATE >= '${fromDate}' AND TXNDATE < '${toDate}' ORDER BY EQPID DESC, STIME",IF(AND(len(LOCATION)==0 ,len(EQPGROUP)==0 ,len(EQPID)>0),"SELECT EQPID, STATE, STIME, ETIME, DETAIL, TXNDATE, MOTHEREQP, ROUND(24*(TO_DATE(ETIME,'YYYYMMDD HH24MISS')-TO_DATE(STIME,'YYYYMMDD HH24MISS')),2) PERIOD FROM TMP_TB_TOOL_STATE WHERE 1=1 and eqpid in ('${EQPID}') AND TXNDATE >= '${fromDate}' AND TXNDATE < '${toDate}' ORDER BY EQPID DESC, STIME",IF(AND(len(LOCATION)==0 ,len(EQPGROUP)>0 ,len(EQPID)==0),"SELECT SYSDATE FROM DUAL",IF(AND(len(LOCATION)>0 ,len(EQPGROUP)==0 ,len(EQPID)==0),"SELECT SYSDATE FROM DUAL",IF(AND(len(LOCATION)==0 ,len(EQPGROUP)>0 ,len(EQPID)>0),"SELECT SYSDATE FROM DUAL",IF(AND(len(LOCATION)>0 ,len(EQPGROUP)==0 ,len(EQPID)>0),"SELECT SYSDATE FROM DUAL",IF(AND(len(LOCATION)>0 ,len(EQPGROUP)>0 ,len(EQPID)==0),"SELECT SYSDATE FROM DUAL",IF(AND(len(LOCATION)>0 ,len(EQPGROUP)>0 ,len(EQPID)>0),"SELECT SYSDATE FROM DUAL",""))))))))}