Page History
...
Code Block | ||
---|---|---|
| ||
SELECT o.ObjID,x.ra,x.dec, o.gMeanPSFMag, o.gMeanPSFMagErr, o.rMeanPSFMag, o.rMeanPSFMagErr, o.iMeanPSFMag, o.iMeanPSFMagErr, o.iMeanKronMag, o.zMeanPSFMag, o.zMeanPSFMagErr, o.gMeanPSFmagNpt,o.rMeanPSFmagNpt,o.iMeanPSFmagNpt,o.zMeanPSFmagNpt, o.gFlags, o.gQfPerfect, o.rFlags, o.rQfPerfect, o.iFlags, o.iQfPerfect, o.zFlags, o.zQfPerfect intoINTO mydb.HighFidelityStars FROM dbo.fGetNearbyObjEq(334, 0.0, 0.2*60) as x JOIN MeanObject o on o.ObjID=x.ObjId where o.gMeanPSFmagNpt>=1 and o.rMeanPSFmagNpt>=1 and o.iMeanPSFmagNpt>=1 and o.zMeanPSFmagNpt>=1 and o.gQfPerfect>=0.85 and o.rQfPerfect>=0.85 and o.iQfPerfect>=0.85 and o.zQfPerfect>=0.85 and o.iMeanPSFMag - o.iMeanKronMag < 0.058 |
Results
1186 1097 objects, here are the first 10:
...