Changeset 17315
- Timestamp:
- 11/06/13 12:54:35 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/Mars/fact/analysis/lightcurve.C
r17104 r17315 48 48 TString query; 49 49 query=Form("SELECT Min(fNight), Max(fNight) FROM %s ", table.Data()); 50 query+=" LEFT JOIN RunInfo USING(fNight, fRunI d) ";50 query+=" LEFT JOIN RunInfo USING(fNight, fRunID) "; 51 51 query+=Form(" WHERE fSourceKey=%d", sourcekey); 52 52 if (nightmin) … … 60 60 datacheck+=" AND fNight>20120420 AND NOT fNight IN (20120406,20120410,20120503) AND";//data with different bias voltage 61 61 datacheck+=" NOT fNight BETWEEN 20121206 AND 20130110"; // broken bias channel 62 //datacheck+=" AND NOT (fNight=20120608 AND fRunI d=65) "; // something went wrong with tracking?62 //datacheck+=" AND NOT (fNight=20120608 AND fRunID=65) "; // something went wrong with tracking? 63 63 // 24.6. new coefficients 64 64 TString zdparam=" pow(0.753833 * cos(Radians(fZenithDistanceMean)), 7.647435) * exp(-5.753686*pow(Radians(fZenithDistanceMean),2.089609))"; … … 84 84 85 85 query =" SELECT fNight FROM "+table; 86 query+=" LEFT JOIN RunInfo USING(fNight, fRunI d) ";86 query+=" LEFT JOIN RunInfo USING(fNight, fRunID) "; 87 87 query+=Form(" WHERE fSourceKey=%d", sourcekey); 88 88 query+=Form(" AND fNight BETWEEN %s AND %s ", nightstart.Data(), nightstop.Data()); … … 167 167 query+=" fZenithDistanceMax, fZenithDistanceMin, "; 168 168 query+=" fCurrentsMedMeanBeg, fThresholdMinSet FROM "+table; 169 query+=" LEFT JOIN RunInfo USING(fNight, fRunI d) ";169 query+=" LEFT JOIN RunInfo USING(fNight, fRunID) "; 170 170 query+=Form(" WHERE fSourceKey=%d", sourcekey); 171 171 query+=Form(" AND fNight= %s ", (*row3)[0]); … … 176 176 query+=datacheck; 177 177 178 query+=" ORDER BY fRunI d";178 query+=" ORDER BY fRunID "; 179 179 180 180 cout << "Q: " << query << endl;
Note:
See TracChangeset
for help on using the changeset viewer.