INSERT INTO analysis VALUES('CMS_2021_I1963239','CMS_2_76_DJET');
INSERT INTO analysis VALUES('ATLAS_2016_I1478355','ATLAS_7_JETS');
INSERT INTO analysis VALUES('ATLAS_2014_I1325553','ATLAS_7_JETS');
INSERT INTO analysis VALUES('ATLAS_2014_I1268975','ATLAS_7_JETS');
INSERT INTO analysis VALUES('ATLAS_2014_I1326641','ATLAS_7_JETS');
INSERT INTO analysis VALUES('ATLAS_2014_I1307243','ATLAS_7_JETS');
INSERT INTO analysis VALUES('CMS_2014_I1298810','CMS_7_JETS');
INSERT INTO analysis VALUES('CMS_2013_I1273574','CMS_7_JETS');
INSERT INTO analysis VALUES('CMS_2013_I1208923','CMS_7_JETS');
INSERT INTO analysis VALUES('CMS_2012_I1089835','CMS_7_JETS');
INSERT INTO analysis VALUES('ATLAS_2012_I1093738','ATLAS_7_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1244522','ATLAS_7_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1263495','ATLAS_7_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2012_I1199269','ATLAS_7_GAMMA');
INSERT INTO analysis VALUES('CMS_2014_I1266056','CMS_7_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1234228','ATLAS_7_HMDY');
INSERT INTO analysis VALUES('ATLAS_2013_I1230812','ATLAS_7_LLJET');
INSERT INTO analysis VALUES('ATLAS_2014_I1306294:LMODE=EL','ATLAS_7_LLJET'); -- this really needs a "both" mode.
INSERT INTO analysis VALUES('CMS_2015_I1310737','CMS_7_LLJET');
INSERT INTO analysis VALUES('LHCB_2014_I1262703','LHCB_7_LLJET');
INSERT INTO analysis VALUES('ATLAS_2016_I1502620:LMODE=Z','ATLAS_7_LLJET');
INSERT INTO analysis VALUES('LHCB_2012_I1208102','LHCB_7_LLJET');
INSERT INTO analysis VALUES('ATLAS_2015_I1345452','ATLAS_7_LMETJET');
INSERT INTO analysis VALUES('ATLAS_2014_I1288706','ATLAS_7_LMDY');
INSERT INTO analysis VALUES('CMS_2013_I1224539:JMODE=W','CMS_7_LMETJET');
INSERT INTO analysis VALUES('CMS_2013_I1224539:JMODE=Z','CMS_7_LLJET');
INSERT INTO analysis VALUES('ATLAS_2016_I1502620:LMODE=W','ATLAS_7_LMETJET');
INSERT INTO analysis VALUES('ATLAS_2014_I1319490','ATLAS_7_LMETJET');
INSERT INTO analysis VALUES('CMS_2014_I1303894','CMS_7_LMETJET');
INSERT INTO analysis VALUES('ATLAS_2014_I1282447','ATLAS_7_LMETJET');
INSERT INTO analysis VALUES('ATLAS_2013_I1219109','ATLAS_7_LMETJET'); --W plus b jets
INSERT INTO analysis VALUES('CMS_2013_I1256943','CMS_7_LLJET');
INSERT INTO analysis VALUES('ATLAS_2013_I1190187','ATLAS_7_L1L2MET'); -- jet veto is correctly applied in fiducial cuts.
INSERT INTO analysis VALUES('ATLAS_2013_I1217863:LMODE=ZEL','ATLAS_7_LL_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1217863:LMODE=ZMU','ATLAS_7_LL_GAMMA');
INSERT INTO analysis VALUES('CMS_2015_I1346843','CMS_7_LL_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1217863:LMODE=WEL','ATLAS_7_LMET_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2013_I1217863:LMODE=WMU','ATLAS_7_LMET_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2012_I1203852:LMODE=LL','ATLAS_7_4L');
INSERT INTO analysis VALUES('ATLAS_2012_I1203852:LMODE=LNU','ATLAS_7_LLMET');
INSERT INTO analysis VALUES('ATLAS_2015_I1394679','ATLAS_8_JETS');
INSERT INTO analysis VALUES('ATLAS_2017_I1598613:BMODE=3MU','ATLAS_8_JETS');
INSERT INTO analysis VALUES('ATLAS_2017_I1604271','ATLAS_8_JETS');
INSERT INTO analysis VALUES('CMS_2016_I1487277','CMS_8_JETS');
INSERT INTO analysis VALUES('CMS_2017_I1598460','CMS_8_JETS'); -- triple differential dijets
-- normalised, no total xsec yet INSERT INTO analysis VALUES('CMS_2016_I1421646',19700,'CMS_8_JETS');
INSERT INTO analysis VALUES('ATLAS_2016_I1457605','ATLAS_8_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2017_I1632756','ATLAS_8_GAMMA'); -- +hf
INSERT INTO analysis VALUES('ATLAS_2017_I1591327','ATLAS_8_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2014_I1306615','ATLAS_8_GAMMA'); -- higgs to photons
INSERT INTO analysis VALUES('ATLAS_2017_I1644367','ATLAS_8_GAMMA'); -- 3gamma (fb)
INSERT INTO analysis VALUES('ATLAS_2016_I1467454:LMODE=EL','ATLAS_8_HMDY');
INSERT INTO analysis VALUES('ATLAS_2016_I1467454:LMODE=MU','ATLAS_8_HMDY');
INSERT INTO analysis VALUES('ATLAS_2014_I1279489','ATLAS_8_LLJET'); -- electroweak Z+jets
INSERT INTO analysis VALUES('ATLAS_2015_I1408516:LMODE=EL','ATLAS_8_LLJET'); -- Z production -- lose some sensitivity by combining these two.
INSERT INTO analysis VALUES('ATLAS_2015_I1408516:LMODE=MU','ATLAS_8_LLJET'); -- Z production
INSERT INTO analysis VALUES('ATLAS_2019_I1744201','ATLAS_8_LLJET'); -- Z+jets
INSERT INTO analysis VALUES('CMS_2016_I1471281:VMODE=Z','CMS_8_LLJET'); -- Z pT
INSERT INTO analysis VALUES('CMS_2016_I1471281:VMODE=W','CMS_8_LMETJET'); -- W pT
INSERT INTO analysis VALUES('ATLAS_2017_I1589844','ATLAS_8_LLJET');
INSERT INTO analysis VALUES('CMS_2017_I1499471','CMS_8_LLJET');
INSERT INTO analysis VALUES('CMS_2016_I1491953','CMS_8_LMETJET');
INSERT INTO analysis VALUES('ATLAS_2015_I1404878','ATLAS_8_LMETJET');
INSERT INTO analysis VALUES('LHCB_2016_I1454404:MODE=WJET','LHCB_8_LJET');
INSERT INTO analysis VALUES('LHCB_2016_I1454404:MODE=ZJET','LHCB_8_LLJET');
INSERT INTO analysis VALUES('CMS_2016_I1454211','CMS_8_LMETJET'); -- NB partonic phase space?
INSERT INTO analysis VALUES('ATLAS_2015_I1397637','ATLAS_8_LMETJET'); -- ttbar
INSERT INTO analysis VALUES('ATLAS_2017_I1517194','ATLAS_8_LMETJET'); -- electroweak W+jets
INSERT INTO analysis VALUES('ATLAS_2018_I1635273:LMODE=EL','ATLAS_8_LMETJET'); -- W+jets. NB some plots in pb -- this really needs a "both" mode.
INSERT INTO analysis VALUES('ATLAS_2018_I1635273:LMODE=MU','ATLAS_8_LMETJET'); -- W+jets. NB some plots in pb -- this really needs a "both" mode.
INSERT INTO analysis VALUES('CMS_2017_I1518399','CMS_8_LMETJET');  -- TTBAR
INSERT INTO analysis VALUES('ATLAS_2016_I1426515','ATLAS_8_L1L2MET'); -- nb jet veto is implemented in fiducial cuts.
INSERT INTO analysis VALUES('CMS_2017_I1467451','CMS_8_L1L2MET'); -- nb b-jet veto is NOT implemented in fiducial cuts; and large data driven bg subtraction.
INSERT INTO analysis VALUES('ATLAS_2015_I1394865','ATLAS_8_4L');
INSERT INTO analysis VALUES('ATLAS_2014_I1310835','ATLAS_8_4L');
INSERT INTO analysis VALUES('ATLAS_2016_I1494075:LMODE=4L','ATLAS_8_4L');
INSERT INTO analysis VALUES('ATLAS_2016_I1494075:LMODE=2L2NU','ATLAS_8_LLMET');
INSERT INTO analysis VALUES('ATLAS_2016_I1448301:LMODE=LL','ATLAS_8_LL_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2016_I1448301:LMODE=NU','ATLAS_8_GAMMA_MET');
INSERT INTO analysis VALUES('ATLAS_2016_I1492320:LMODE=3L','ATLAS_8_3L');
INSERT INTO analysis VALUES('ATLAS_2016_I1492320:LMODE=2L2J','ATLAS_8_L1L2MET'); -- nb b-jet veto IS implemented in fiducial cuts
INSERT INTO analysis VALUES('ATLAS_2016_I1444991','ATLAS_8_L1L2MET'); -- nb jet veto IS implemented in fiducial cuts; but large data-driven top subtraction
INSERT INTO analysis VALUES('CMS_2016_I1487288','CMS_8_3L');
INSERT INTO analysis VALUES('ATLAS_2018_I1634970','ATLAS_13_JETS');
INSERT INTO analysis VALUES('ATLAS_2019_I1724098','ATLAS_13_JETS'); -- jet substructure.
INSERT INTO analysis VALUES('ATLAS_2017_I1637587','ATLAS_13_JETS'); -- soft drop jet mass
INSERT INTO analysis VALUES('ATLAS_2020_I1808726','ATLAS_13_JETS');  -- multijet event shapes
INSERT INTO analysis VALUES('CMS_2019_I1753720','CMS_13_TTHAD'); -- all-jet top events with b-jets.
INSERT INTO analysis VALUES('CMS_2021_I1932460','CMS_13_JETS');
INSERT INTO analysis VALUES('CMS_2021_I1847230:MODE=QCD13TeV','CMS_13_JETS'); -- 13TeV mode three jets
INSERT INTO analysis VALUES('CMS_2021_I1847230:MODE=QCD8TeV','CMS_8_JETS'); -- 8TeV mode three jets
INSERT INTO analysis VALUES('CMS_2016_I1459051','CMS_13_JETS');
INSERT INTO analysis VALUES('CMS_2018_I1682495','CMS_13_JETS'); -- jet mass
INSERT INTO analysis VALUES('ATLAS_2019_I1725190','ATLAS_13_HMDY'); -- lumi is set in routine, to give event counts
INSERT INTO analysis VALUES('CMS_2018_I1711625','CMS_13_HMDY');    -- plots in pb
INSERT INTO analysis VALUES('ATLAS_2017_I1627873','ATLAS_13_LLJET');
INSERT INTO analysis VALUES('ATLAS_2022_I2077570','ATLAS_13_LLJET'); -- Z+jets
INSERT INTO analysis VALUES('ATLAS_2017_I1514251:LMODE=EMU','ATLAS_13_LLJET'); -- Z+jets (we potentially lose some sensitivity here in some cases by only looking at the combined ones).
INSERT INTO analysis VALUES('ATLAS_2020_I1788444','ATLAS_13_LLJET'); -- Z+bb
INSERT INTO analysis VALUES('ATLAS_2020_I1803608','ATLAS_13_LLJET'); -- Electroweak Z+jets
INSERT INTO analysis VALUES('ATLAS_2019_I1768911','ATLAS_13_LLJET'); -- plots in pb
INSERT INTO analysis VALUES('CMS_2022_I2079374','CMS_13_LLJET'); -- CMS inclusive dilepton (Z pole and above, so kept in LL rather than HMDY
INSERT INTO analysis VALUES('CMS_2018_I1667854:LMODE=EMU','CMS_13_LLJET'); -- Z+jets
INSERT INTO analysis VALUES('CMS_2019_I1753680:LMODE=EMU','CMS_13_LLJET'); -- Z production
INSERT INTO analysis VALUES('CMS_2020_I1814328','CMS_13_L1L2MET'); -- WW -> 2l with one or zero jet. Includes SF leptons but excludes the Z pole.
INSERT INTO analysis VALUES('CMS_2021_I1866118','CMS_13_LLJET'); -- DY Z production -> mm 
INSERT INTO analysis VALUES('CMS_2021_I1847230:MODE=ZJet','CMS_8_LLJET');-- Z (dimuons) + jets in ZJet mode need to be careful when using these histos! Normalisation factors are uncertain. 
INSERT INTO analysis VALUES('ATLAS_2019_I1738841','ATLAS_13_SSLLMET'); -- Electroweak same sign WW -> 2l at least 2 jets
INSERT INTO analysis VALUES('CMS_2017_I1610623','CMS_13_LMETJET'); -- W+jets
INSERT INTO analysis VALUES('CMS_2016_I1491950','CMS_13_LMETJET'); --ttbar
INSERT INTO analysis VALUES('CMS_2018_I1662081','CMS_13_LMETJET'); --ttbar
INSERT INTO analysis VALUES('CMS_2018_I1663958','CMS_13_LMETJET'); -- ttbar+jets (pb)
INSERT INTO analysis VALUES('CMS_2019_I1705068','CMS_13_LMETJET'); -- W+charm
INSERT INTO analysis VALUES('CMS_2019_I1744604','CMS_13_LMETJET'); -- single top
INSERT INTO analysis VALUES ('CMS_2021_I1901295','CMS_13_LMETJET'); -- semileptonic ttbar (pb)
INSERT INTO analysis VALUES('ATLAS_2017_I1614149','ATLAS_13_LMETJET'); --ttbar
INSERT INTO analysis VALUES('ATLAS_2019_I1750330:TYPE=BOTH','ATLAS_13_LMETJET'); --ttbar
INSERT INTO analysis VALUES('ATLAS_2023_I2628732','ATLAS_13_LMETJET'); --W+D
INSERT INTO analysis VALUES('ATLAS_2022_I2037744','ATLAS_13_LMETJET'); --semileptonic ttbar
INSERT INTO analysis VALUES('ATLAS_2018_I1698006:LVETO=ON','ATLAS_13_GAMMA_MET');
INSERT INTO analysis VALUES('LHCB_2018_I1662483','LHCB_13_L1L2B'); --ttbar
INSERT INTO analysis VALUES('ATLAS_2017_I1625109','ATLAS_13_4L');  -- ZZ
INSERT INTO analysis VALUES('ATLAS_2019_I1720442','ATLAS_13_4L');  -- inclusive
INSERT INTO analysis VALUES('ATLAS_2021_I1849535','ATLAS_13_4L');  -- inclusive
INSERT INTO analysis VALUES('ATLAS_2023_I2690799','ATLAS_13_4L');  -- 4L + 2 jets
INSERT INTO analysis VALUES('ATLAS_2019_I1718132:LMODE=ELMU','ATLAS_13_L1L2METJET');
INSERT INTO analysis VALUES('ATLAS_2022_I2103950','ATLAS_13_L1L2MET');
INSERT INTO analysis VALUES('ATLAS_2019_I1718132:LMODE=ELEL','ATLAS_13_LLJET');
INSERT INTO analysis VALUES('ATLAS_2019_I1718132:LMODE=MUMU','ATLAS_13_LLJET');
INSERT INTO analysis VALUES('ATLAS_2024_I2771257','ATLAS_13_LLJET');
INSERT INTO analysis VALUES('ATLAS_2018_I1656578','ATLAS_13_LMETJET'); --Top + jets
INSERT INTO analysis VALUES('ATLAS_2018_I1705857','ATLAS_13_LMETJET'); --Top + b jets (normalised)
INSERT INTO analysis VALUES('ATLAS_2017_I1609448','ATLAS_13_METJET'); -- HAVE THEORY
INSERT INTO analysis VALUES('ATLAS_2024_I2765017:TYPE=BSM','ATLAS_13_METJET');  -- HAVE THEORY. Full Run-2 measurement.
INSERT INTO analysis VALUES('ATLAS_2016_I1458270','ATLAS_13_METJET'); -- HAVE THEORY. 0l+MET+nJets search. Lumi is set to 3.2 in the routine
--INSERT INTO analysis VALUES('ATLAS_STDM_2021_10','ATLAS_13_TAU');  -- full run 2
INSERT INTO analysis VALUES('ATLAS_2018_I1646686','ATLAS_13_TTHAD'); -- Hadronic top pairs (pb)
INSERT INTO analysis VALUES('ATLAS_2020_I1801434','ATLAS_13_TTHAD'); -- Hadronic top pairs (pb)
INSERT INTO analysis VALUES('CMS_2019_I1764472','CMS_13_TTHAD'); -- Hadronic top pairs (fb)
INSERT INTO analysis VALUES('ATLAS_2022_I2077575','ATLAS_13_TTHAD'); -- Hadronic top pairs (fb) boosted
INSERT INTO analysis VALUES('ATLAS_2018_I1707015:LMODE=SINGLE','ATLAS_13_LMET_GAMMA'); -- semileptonic
INSERT INTO analysis VALUES('ATLAS_2018_I1707015:LMODE=DILEPTON','ATLAS_13_L1L2MET_GAMMA'); -- leptonic
INSERT INTO analysis VALUES('ATLAS_2024_I2768921:LMODE=SINGLE','ATLAS_13_LMET_GAMMA'); -- semileptonic
INSERT INTO analysis VALUES('ATLAS_2024_I2768921:LMODE=DILEPTON','ATLAS_13_L1L2MET_GAMMA'); -- leptonic
INSERT INTO analysis VALUES('ATLAS_2021_I1887997','ATLAS_13_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2017_I1645627','ATLAS_13_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2019_I1772071','ATLAS_13_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2022_I2023464','ATLAS_13_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2019_I1764342','ATLAS_13_LL_GAMMA'); -- Z+gamma
INSERT INTO analysis VALUES('ATLAS_2022_I2593322','ATLAS_13_LL_GAMMA'); -- Z+diphoton
INSERT INTO analysis VALUES('ATLAS_2022_I2614196','ATLAS_13_LL_GAMMA'); -- Z+gamma (sometimes in association with jets) 
INSERT INTO analysis VALUES('ATLAS_2019_I1734263','ATLAS_13_L1L2MET'); -- no jets
INSERT INTO analysis VALUES('ATLAS_2021_I1852328','ATLAS_13_L1L2METJET'); -- inclusive of possible jets
INSERT INTO analysis VALUES('CMS_2023_I2709669','CMS_13_L1L2MET_GAMMA');
INSERT INTO analysis VALUES('ATLAS_2019_I1759875','ATLAS_13_L1L2METJET');
INSERT INTO analysis VALUES('ATLAS_2016_I1469071','ATLAS_13_3L');
INSERT INTO analysis VALUES('ATLAS_2016_I1419652','ATLAS_13_JETS'); -- 
INSERT INTO analysis VALUES('ATLAS_2016_I1467230','ATLAS_13_JETS'); --  with low pT tracks
INSERT INTO analysis VALUES('ATLAS_2019_I1740909','ATLAS_13_JETS'); --  jet fragmentation using charged particles
INSERT INTO analysis VALUES('ATLAS_2020_I1790256','ATLAS_13_JETS'); --  Lund jet plane with charged particles
INSERT INTO analysis VALUES('CMS_2020_I1794169','CMS_13_3LJET'); 
INSERT INTO analysis VALUES('CMS_2022_I2080534','CMS_13_L1L2MET');
-- normalised, no total xsec yet INSERT INTO analysis VALUES('CMS_2016_I1421646',19700,'CMS_8_JETS');
