Changes between Version 6 and Version 7 of DatabaseBasedAnalysis/Benchmarking
- Timestamp:
- 09/02/18 14:43:45 (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis/Benchmarking
v6 v7 1 1 {{{#!sql 2 2 SELECT 3 Events.*3 Images.* 4 4 FROM RunInfo 5 LEFT JOIN Events USING (FileId)5 LEFT JOIN Images USING (FileId) 6 6 LEFT JOIN Position USING (FileId, EvtNumber) 7 7 WHERE … … 93 93 {{{#!sql 94 94 SELECT 95 Events.*,95 Images.*, 96 96 @DX := MeanX-X/1.02, 97 97 @DY := MeanY-Y/1.02, … … 111 111 @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq 112 112 FROM RunInfo 113 LEFT JOIN Events USING (FileId)113 LEFT JOIN Images USING (FileId) 114 114 LEFT JOIN Position USING (FileId, EvtNumber) 115 115 WHERE … … 203 203 {{{#!sql 204 204 SELECT 205 Events.*,205 Images.*, 206 206 Angle, 207 207 weight, … … 225 225 @ThetaSq := (@Disp*@Disp + @Dist*@Dist - 2*@Disp*@Dist*SQRT(1-@LX*@LX)) AS ThetaSq 226 226 FROM RunInfo 227 LEFT JOIN Events USING (FileId)227 LEFT JOIN Images USING (FileId) 228 228 LEFT JOIN Position USING (FileId, EvtNumber) 229 229 CROSS JOIN Wobble … … 318 318 {{{#!sql 319 319 SELECT 320 Events.*320 Images.* 321 321 FROM 322 Events322 Images 323 323 WHERE 324 324 FileId IN ($LIST) -- … … 363 363 {{{#!sql 364 364 SELECT 365 Events.*365 Images.* 366 366 FROM 367 Events367 Images 368 368 LEFT JOIN RunInfo USING (FileId) 369 369 WHERE … … 417 417 {{{#!sql 418 418 SELECT 419 Events.*,419 Images.*, 420 420 Position.X, 421 421 Position.Y 422 422 FROM 423 Events423 Images 424 424 LEFT JOIN RunInfo USING (FileId) 425 425 LEFT JOIN Position USING (FileId, EvtNumber)