Page History
...
Code Block | ||
---|---|---|
| ||
SELECT o.objID, ot.raStack, ot.decStack, ot.raMean, ot.decMean, ot.ng, o.gMeanPSFMag,o.gMeanPSFMagErr,o.gMeanKronMag,o.gMeanKronMagErr, ot.nr, o.rMeanPSFMag,o.rMeanPSFMagErr,o.rMeanKronMag,o.rMeanKronMagErr, ot.ni, o.iMeanPSFMag,o.iMeanPSFMagErr,o.iMeanKronMag,o.iMeanKronMagErr, ot.nz, o.zMeanPSFMag,o.zMeanPSFMagErr,o.zMeanKronMag,o.zMeanKronMagErr, ot.ny, o.yMeanPSFMag,o.yMeanPSFMagErr,o.yMeanKronMag,o.yMeanKronMagErr, o.gQfPerfect,o.rQfPerfect,o.iQfPerfect,o.zQfPerfect,o.yQfPerfect, ot.qualityFlag,ot.objInfoFlag, sp.gpetRadius,sp.rpetRadius,sp.ipetRadius,sp.zpetRadius,sp.ypetRadius, sp.gpetR50,sp.rpetR50,sp.ipetR50,sp.zpetR50,sp.ypetR50, soa.gpsfLikelihood, soa.gKronRad, soa.rKronRad, soa.iKronRad INTO mydb.[K2C14C14] FROM MeanObject AS o JOIN fgetNearbyObjEq(160.68333, 6.85167 , 8.5*60) cone ON cone.objid = o.objID JOIN ObjectThin AS ot ON ot.objID = o.objID LEFT JOIN StackPetrosian AS sp ON sp.objID = o.objID LEFT JOIN StackObjectAttributes AS soa ON soa.objID = o.objID WHERE ot.ni >= 3 AND ot.ng >= 3 AND ot.nr >= 3 AND (o.rMeanKronMag > 0 AND o.rMeanKronMag <= 19.5 ) AND (o.gQfPerfect >= 0.95) AND (o.rQfPerfect >= 0.95) AND (o.iQfPerfect >= 0.95) AND (o.zQfPerfect >= 0.95) AND (o.rmeanpsfmag - o.rmeankronmag > 0.505) |
Results
First 10 Rows on MyDB Table K2C14
...