select  dc.prod_id,dc.domcal_id,dc.date,dc.temperature,hv.slope,hv.intercept  from DOMCalibration 
dc,DOMCal_HvGain hv where dc.date='2006-05-19'  and dc.domcal_id=hv.domcal_id and dc.prod_id= any (select 
d.prod_id  from Product m,AssemblyProduct ap,Assembly a,Product d where  m.prod_id=ap.prod_id and 
ap.assem_id=a.assem_id and  a.prod_id=d.prod_id and (m.hardware_serial='fb388b597810' or  
m.hardware_serial='bd8cafb6957e') group by d.prod_id order by  a.datetime desc); 
