select  
pt.lorun as runnumber,  
usl.create_date as l3CreateDate,  
uscdf.create_date as prodcdfVer1CreateDate,  
us.create_date as passtableUsedSetCreateDate,  
pt.create_date as passtableEntryTime 
from  
passcalibs pt,  
used_sets us,  
used_sets usl,  
used_sets uscdf, 
run_summary rc  
where  
pass_index = (select pass_index from passes where process_name = 'PROD_PHYSICS_CDF' and passname = '10' and retired is null) and  
us.process_run >= 177471 and us.process_run <= 999999 and 
usl.process_run >= 177471 and usl.process_run <= 999999 and 
uscdf.process_run >= 177471 and uscdf.process_run <= 999999 and 
us.process_name = 'PROD_PHYSICS_CDF' and  
us.process_run = pt.lorun and  
us.proc_calib_version = pt.proc_calib_version and 
usl.process_run = pt.lorun and  
uscdf.process_run = pt.lorun and 
rc.runnumber = pt.lorun and   
usl.process_name = 'L3_PHYSICS_CDF' and  
usl.proc_calib_version = 1 and  
uscdf.process_name = 'PROD_PHYSICS_CDF' and  
uscdf.proc_calib_version = 1;  
