Warning, /RecoLuminosity/LumiProducer/doc/frontierQuery.txt is written in an unsupported language. File is not indexed.
0001
0002 - SELECT TABLE_NAME, COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE OWNER='CMS_LUMI_DEV_OFFLINE' ORDER BY TABLE_NAME, COLUMN_ID (1592/26.2%)
0003 [query above is per coral connection]
0004 ======
0005 [query below is per lumi section]
0006 SELECT "CMSLSNUM", "LUMISUMMARY_ID", "INSTLUMI", "INSTLUMIERROR", "LUMISECTIONQUALITY", "STARTORBIT", "NUMORBIT" FROM "CMS_LUMI_DEV_OFFLINE"."LUMISUMMARY" "LUMISUMMARY" WHERE "RUNNUM" =124020 AND "LUMIVERSION"='0001' AND "CMSLSNUM" =10 ORDER BY "CMSLSNUM" (301/59.1%)
0007 SELECT "BXLUMIVALUE", "BXLUMIERROR", "BXLUMIQUALITY", "ALGONAME" FROM "CMS_LUMI_DEV_OFFLINE"."LUMIDETAIL" "LUMIDETAIL" WHERE "LUMISUMMARY_ID" =365 (107097/29.0%)
0008 SELECT "COUNT", "DEADTIME", "PRESCALE", "BITNAME" FROM "CMS_LUMI_DEV_OFFLINE"."TRG" "TRG" WHERE "RUNNUM" =124020 AND "CMSLSNUM" =10 ORDER BY "CMSLSNUM", "BITNUM" (8156/16.7%)
0009 SELECT "PATHNAME", "INPUTCOUNT", "ACCEPTCOUNT", "PRESCALE" FROM "CMS_LUMI_DEV_OFFLINE"."HLT" "HLT" WHERE "RUNNUM" =124020 AND "CMSLSNUM" =10 ORDER BY "CMSLSNUM" (5496/29.7%)
