select count(*) 
from CREDIT_CMT_APPLY ,A_B_C 			 			 		 		
where 1=2 		
OR 			 				 					operator =  ?  			   
 and 					CREDIT_CMT_APPLY.GMT_CREATE >=  ?  			    
 and 					CREDIT_CMT_APPLY.GMT_CREATE <=  ?  			     			 			 		    
 and 		    	    CREDIT_CMT_APPLY.ID = A_B_C.cmt_apply_id 			    
 and  					Type = 'denounce' 			    
 and  					(SHEET_STATUS = 'assigned_unresolved') 		
 
---------------------------
SELECT count(*)
FROM CREDIT_CMT_APPLY, A_B_C
WHERE 1 = 2
	OR operator = ?
	AND CREDIT_CMT_APPLY.GMT_CREATE >= ?
	AND CREDIT_CMT_APPLY.GMT_CREATE <= ?
	AND CREDIT_CMT_APPLY.ID = A_B_C.cmt_apply_id
	AND Type = 'denounce'
	AND SHEET_STATUS = 'assigned_unresolved'


