 SELECT A_B_C.*, EE_2.NAME AS TRUNK_NAME     		  
 FROM AA_2,A_B_C, EE_2      		  
 WHERE AA_2.is_deleted='n' and      		  	
 	AA_2.TRUNK_ID=EE_2.ID 
 	AND      		  	AA_2.ID=A_B_C.CLOT_ID 
 	AND     		  	A_B_C.GMT_MODIFIED >=?     		  
ORDER BY EE_2.NAME,AA_2.id  NULLS LAST     	     


  

---------------------------
SELECT A_B_C.*, EE_2.NAME AS TRUNK_NAME
FROM AA_2, A_B_C, EE_2
WHERE AA_2.is_deleted = 'n'
	AND AA_2.TRUNK_ID = EE_2.ID
	AND AA_2.ID = A_B_C.CLOT_ID
	AND A_B_C.GMT_MODIFIED >= ?
ORDER BY EE_2.NAME, AA_2.id NULLS LAST