Changes between Version 7 and Version 8 of DatabaseBasedAnalysis
- Timestamp:
- 08/03/18 17:27:19 (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseBasedAnalysis
v7 v8 131 131 }}} 132 132 133 Now we need to get a list of these runs with 134 {{{ 135 SELECT 136 FileId 137 FROM 138 RunInfo 139 WHERE 140 fSourceKey=5 141 AND 142 fRunTypeKey=1 143 AND 144 FileId BETWEEN 131101000 AND 131107000 145 AND 146 fR750Ref/fR750Cor>0.9 147 AND 148 fZenithDistanceMax<35 149 }}} 150 151 This can later be '''JOIN'''ed with the following queries. 152 133 153 134 154 == Data retrieval ==