Changes between Version 236 and Version 237 of DatabaseBasedAnalysis/Spectrum

Timestamp:

12/09/19 18:24:33 (5 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Spectrum

@@ -163 +163 @@
 == Get Monte Carlo File List ==
 
+{{{#!Spoiler
+{{{#!sql
+CREATE TEMPORARY TABLE MonteCarloFiles
+(
+   FileId INT UNSIGNED NOT NULL,
+   PRIMARY KEY (FileId) USING HASH
+) ENGINE=Memory
+AS
+(
+   SELECT
+      FileId
+   FROM
+      ObservationTime
+   LEFT JOIN
+      BinningTheta ON `.theta`=bin
+   LEFT JOIN
+      factmc.RunInfoMC
+   ON
+      (ThetaMin>=lo AND ThetaMin<hi) OR (ThetaMax>lo AND ThetaMax<=hi)
+   WHERE
+      PartId=1 AND
+      FileId%%2=0
+   ORDER BY
+      FileId
+)
+}}}
+}}}
+
+
 == Get Zenith Angle Histogram ==