File indexing completed on 2024-04-06 12:26:34
0001 select fillnum,sequence,hltkey,startime,stoptime from cmsrunsummary where runnum=:runnum
0002 select cmslsnum,instlumi,numorbit,startorbit,beamstatus,beamenery from lumisummary where runnum=:runnum and lumiversion=:lumiversion
0003 select sum(instlumi) from lumisummary where runnum=:runnum and lumiversion=:lumiversion
0004 select cmslsnum,trgcount,deadtime,bitname,prescale from trg where runnum=:runnum and bitnum=0;
0005 select cmslsnum,trgcount,deadtime,bitnum,prescale from trg where runnum=:runnum and bitname=:bitname;
0006 select cmslsnum,trgcount,deadtime,bitnum,prescale from trg where runnum=:runnum
0007 select cmslsnum,inputcount,acceptcount,prescale from hlt where runnum=:runnum and pathname=:hltpath
0008 select cmslsnum,inputcount,acceptcount,prescale,hltpath from hlt where runnum=:runnum
0009 select s.cmslsnum,d.bxlumivalue,d.bxlumierror,d.bxlumiquality from LUMIDETAIL d,LUMISUMMARY s where s.runnum=:runnumber and d.algoname=:algoname and s.lumisummary_id=d.lumisummary_id order by s.startorbit
0010 select s.cmslsnum,d.bxlumivalue,d.bxlumierror,d.bxlumiquality,d.algoname from LUMIDETAIL d,LUMISUMMARY s where s.runnum=:runnumber and s.lumisummary_id=d.lumisummary_id order by s.startorbit,d.algoname
0011 select trghltmap.hltpathname,trghltmap.l1seed from cmsrunsummary,trghltmap where cmsrunsummary.runnum=:runnum and trghltmap.hltkey=cmsrunsummary.hltkey
