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.[K2C14] FROM MeanObject AS o JOIN fgetNearbyObjEq(160.68333, 6.85167 , 8.5) 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.5) |
...
First 10 Rows on MyDB Table K2C14
objID | raStack | decStack | raMean | decMean | ng | gMeanPSFMag | gMeanPSFMagErr | gMeanKronMag | gMeanKronMagErr | nr | rMeanPSFMag | rMeanPSFMagErr | rMeanKronMag | rMeanKronMagErr | ni | iMeanPSFMag | iMeanPSFMagErr | iMeanKronMag | iMeanKronMagErr | nz | zMeanPSFMag | zMeanPSFMagErr | zMeanKronMag | zMeanKronMagErr | ny | yMeanPSFMag | yMeanPSFMagErr | yMeanKronMag | yMeanKronMagErr | gQfPerfect | rQfPerfect | iQfPerfect | zQfPerfect | yQfPerfect | qualityFlag | objInfoFlag | gpetRadius | rpetRadius | ipetRadius | zpetRadius | ypetRadius | gpetR50 | rpetR50 | ipetR50 | zpetR50 | ypetR50 | 123311549281210477gpsfLikelihood | gKronRad | rKronRad | iKronRad | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109081656511207587 | 165.65123799 | 154.92812611 | 12.75831367 | 154.92811431 | 12.75832518 | 10 | 20.0835 | 0.02440190602251 | 19165.3016512316 | 0.02816190600456 | 167 | 1921.04156437 | 0.039718367865 | 1820.2090493 | 0.009343058567 | 12 | 2018.63266574 | 0.023309184406 | 1719.70533962 | 0.011849072033 | 1221 | 1820.01355946 | 0.029643078082 | 1719.42831998 | 0.009914026173 | 1411 | 1820.10775699 | 0.042534076552 | 1719.32811158 | 0.023553033139 | 2 | 20.24 | 0.999812008608 | 19.1051 | 0.99953202796 | 0.999408999734 | 0.999818999427 | 0.999398999521 | 61 | 512024576 | 7.65464 | 6.89781 | 5.74412 | 0.999396 | 0.997468 | 53 | 444915712 | 10.42675.57977 | 4.2107461004 | 214.7813312252 | 6.3617821549 | 25.05482260252 | 4.051408935 | 1.67238 |
123311556359837190 | 155.63595456 | 12.76391817 | 155.63594254 | 12.76393065 | 17 | 20.6317 | 0.029612 | 20.1322 | 0.030872 | 22 | 19.5872 | 0.035236 | 19.009 | 0.015546 | 24 | 19.2038 | 0.022632 | 18.5463 | 0.013514 | 13 | 18.7241 | 0.029605 | 18.2488 | 0.016407 | 15 | 18.7148 | 0.025143 | 18.1658 | 0.036589 | 0.999841 | 0.999667 | 0.999723 | 0.999696 | 0.999486 | 61 | 512024576 | 4.11764 | 3.19234 | 3.37176 | 3.55703 | 3.55401 | 1.64643 | 1.28659 | 1.30457 | 1.41352 | 1.64367 | ||||||||
123311563608493897 | 156.36080172 | 12.76123503 | 156.36081918 | 12.76123267 | 12 | 19.6828 | 0.053324 | 17.5969 | 0.013996 | 10 | 19.6995 | 0.214609 | 17.2401 | 0.014849 | 14 | 19.6599 | 0.088526 | 17.1426 | 0.013593 | 6 | 19.2574 | 0.077356 | 17.3268 | 0.023463 | 5 | 19.4923 | 0.214712 | 17.9344 | 0.035796 | 0.999578 | 0.999805 | 0.999771 | 0.999548 | 0.998263 | 53 | 444915712 | 10.8759 | 11.199 | 11.1484 | 10.5347 | 9.50867 | 4.43794 | 4.40708 | 4.52688 | 4.21262 | 3.28768 | ||||||||
123311564766811688 | 156.47673248 | 12.75933957 | 156.47676479 | 12.75933774 | 10 | 20.6036 | 0.038835 | 20.2254 | 0.028823 | 12 | 19.6161 | 0.029449 | 19.0641 | 0.026325 | 19 | 19.2917 | 0.021417 | 18.7812 | 0.016662 | 9 | 18.9118 | 0.021025 | 18.5409 | 0.035919 | 12 | 18.8295 | 0.024847 | 18.3664 | 0.05601 | 0.99962 | 0.999673 | 0.999685 | 0.999586 | 0.99939 | 53 | 444915712 | 4.00564 | 3.49143 | 4.64069 | 4.7902 | -9.08956 | 1.3887 | 1.11921 | 1.25359 | 1.44259 | -9.07378 | ||||||||
123311565993385602 | 156.59931289 | 12.76262096 | 156.59931872 | 12.76262302 | 10 | 19.3503 | 0.026542 | 18.4721 | 0.022539 | 14 | 18.8037 | 0.032864 | 18.0029 | 0.020426 | 15 | 18.5567 | 0.012024 | 17.6336 | 0.012315 | 11 | 18.3297 | 0.061319 | 17.387 | 0.016721 | 17 | 18.2486 | 0.053074 | 17.2516 | 0.087225 | 0.999834 | 0.999308 | 0.999417 | 0.999812 | 0.999327 | 61 | 512024576 | 3.11429 | 2.81284 | 2.97854 | 3.117 | 8.68295 | 1.00833 | 0.980632 | 1.07104 | 0.984775 | 2.965 | ||||||||
123311564444738006 | 156.44447917 | 12.76459414 | 156.44450277 | 12.76459045 | 9 | 19.9533 | 0.026005 | 19.4565 | 0.018023 | 14 | 18.9669 | 0.017971 | 18.2664 | 0.011821 | 14 | 18.555 | 0.01805 | 17.7932 | 0.00674 | 7 | 18.1525 | 0.048449 | 17.5099 | 0.01958 | 16 | 18.0324 | 0.054899 | 17.3798 | 0.021401 | 0.999658 | 0.999581 | 0.999657 | 0.999516 | 0.999339 | 61 | 512024576 | 4.85821 | 4.28138 | 4.09561 | 3.92565 | 4.57184 | 1.85211 | 1.5708 | 1.53056 | 1.5795 | 1.66867 | ||||||||
123311566009794928 | 156.60102574 | 12.76200927 | 156.60102304 | 12.76201848 | 10 | 19.036 | 0.059096 | 18.0817 | 0.02248 | 14 | 17.9479 | 0.044041 | 17.1254 | 0.015734 | 14 | 17.6411 | 0.023534 | 16.7142 | 0.006589 | 9 | 17.2256 | 0.057247 | 16.4349 | 0.005736 | 16 | 17.0858 | 0.055096 | 16.1444 | 0.03247 | 0.999666 | 0.999091 | 0.999663 | 0.999464 | 0.998955 | 61 | 512024576 | 5.99277 | 5.45115 | 4.69198 | 5.3783 | 2.76549 | 2.43662 | 2.2388 | 1.8653 | 2.15231 | 1.06782 | ||||||||
123311566048421351 | 156.60484481 | 12.75900132 | 156.60484546 | 12.7590098 | 8 | 19.2369 | 0.034491 | 18.727 | 0.024239 | 12 | 18.3925 | 0.01095 | 17.7554 | 0.010232 | 16 | 18.0391 | 0.028661 | 17.3429 | 0.005609 | 11 | 17.6664 | 0.024755 | 17.0823 | 0.010994 | 18 | 17.5588 | 0.034835 | 17.0271 | 0.011815 | 0.999664 | 0.999544 | 0.999602 | 0.999623 | 0.999433 | 61 | 512024576 | 4.16681 | 3.54043 | 3.21858 | 3.69755 | 26.1036 | 1.56839 | 1.36376 | 1.27506 | 1.37458 | -999 | ||||||||
123311569207978960 | 156.92076482 | 12.76540801 | 156.92076056 | 12.76544365 | 9 | 20.8824 | 0.063935 | 20.1254 | 0.038368 | 12 | 20.1992 | 0.028047 | 19.3953 | 0.02682 | 14 | 19.963 | 0.017104 | 19.1169 | 0.022385 | 11 | 19.3916 | 0.093169 | 18.8423 | 0.047232 | 14 | 19.3703 | 0.050302 | 18.6263 | 0.060436 | 0.999512 | 0.999706 | 0.999858 | 0.999353 | 0.999578 | 53 | 444915712 | 5.58858 | 4.86715 | 4.59496 | 5.16338 | 4.85984 | 2.10445 | 2.04828 | 1.82724 | 2.16979 | 2.12018 | 123311577928974093 | 157.79288195 | 12.76131325 | 157.79286038 | 12.76133682 | 10 | 19.8432 | 0.026994 | 19.4151 | 0.037358 | 14 | 19.0266 | 0.010783 | 18.5078 | 0.00961 | 20 | 18.6403 | 0.014359 | 18.1007 | 0.008081 | 15 | 18.302 | 0.028949 | 17.9015 | 0.016442 | 14 | 18.3422 | 0.025802 | 17.8278 | 0.00872 | 0.999293 | 0.999235 | 0.999065 | 0.999243 | 0.999374 | 61 | 512024576 | 13.2731 | 3.46466 | 3.09503 | 3.8395 | 2.8104 | 6.11566 | 1.3939 | 1.23334 | 1.3563 | 1.08618
71427 | 5.20723 | 2.50306 | 2.97936 | 0 | 5.31611 | 4.99134 | 6.30024 | |||||||||||||||||||||||||||||||||||||||||||||||
109081657271754110 | 165.72716855 | 0.90305714 | 165.7271564 | 0.90304372 | 14 | 20.1335 | 0.055225 | 19.3779 | 0.027096 | 18 | 19.1085 | 0.050282 | 17.9462 | 0.02275 | 41 | 18.3619 | 0.034442 | 17.4018 | 0.006397 | 14 | 18.4043 | 0.026483 | 17.1619 | 0.01081 | 15 | 18.0893 | 0.02773 | 17.1387 | 0.021028 | 0.999818 | 0.999666 | 0.999756 | 0.999283 | 0.999213 | 61 | 512024576 | 17.3958 | 7.08274 | 6.85966 | 6.21411 | 6.62478 | 5.23086 | 2.76816 | 2.69369 | 2.50231 | 2.43742 | 0 | 6.14782 | 7.20799 | 8.64767 | ||||
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.12776 | 4.20798 | 3.30079 | 3.07922 | 3.51289 | 1.66921 | 1.62555 | 1.30019 | 1.18262 | 1.26171 | 1.10623E-28 | 4.50234 | 4.89816 | 4.61272 | ||||
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.12776 | 4.20798 | 3.30079 | 3.07922 | 3.51289 | 1.66921 | 1.62555 | 1.30019 | 1.18262 | 1.26171 | 8.32451E-38 | 4.50676 | 4.95531 | 4.66793 | ||||
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.45158 | 4.51567 | 3.29945 | 3.26378 | 3.35685 | 1.71603 | 1.69979 | 1.29004 | 1.21474 | 1.32069 | 1.10623E-28 | 4.50234 | 4.89816 | 4.61272 | ||||
109081660112548426 | 166.01125419 | 0.90667221 | 166.01122991 | 0.90667274 | 10 | 19.6737 | 0.018756 | 19.1382 | 0.055795 | 14 | 19.0117 | 0.029885 | 18.4536 | 0.046332 | 37 | 18.4367 | 0.025989 | 17.9402 | 0.011479 | 12 | 18.473 | 0.009927 | 17.7809 | 0.020074 | 15 | 18.1992 | 0.017736 | 17.5847 | 0.025577 | 0.999727 | 0.999591 | 0.999751 | 0.998976 | 0.99934 | 61 | 512024576 | 4.45158 | 4.51567 | 3.29945 | 3.26378 | 3.35685 | 1.71603 | 1.69979 | 1.29004 | 1.21474 | 1.32069 | 8.32451E-38 | 4.50676 | 4.95531 | 4.66793 | ||||
109081663334564862 | 166.33350343 | 0.90367258 | 166.33352384 | 0.90364983 | 11 | 20.1058 | 0.076975 | 18.7424 | 0.018033 | 18 | 19.8483 | 0.046171 | 18.2347 | 0.028703 | 26 | 19.4088 | 0.047933 | 17.9761 | 0.012573 | 12 | 19.844 | 0.050792 | 18.1878 | 0.05053 | 10 | 19.4914 | 0.073344 | 18.128 | 0.060383 | 0.999617 | 0.9996 | 0.999637 | 0.999439 | 0.998929 | 53 | 444915712 | 6.44318 | 6.34578 | 47.401 | 6.3831 | 5.81085 | 2.48334 | 2.50278 | -999 | 2.16752 | 1.94129 | 0 | 6.67284 | 6.62435 | 7.05478 | ||||
109091546911366908 | 154.69111052 | 0.91371481 | 154.69111613 | 0.91372215 | 12 | 21.5211 | 0.061925 | 20.6393 | 0.038723 | 12 | 19.8712 | 0.033214 | 19.1334 | 0.03706 | 18 | 19.3671 | 0.027138 | 18.6387 | 0.020194 | 12 | 19.164 | 0.032954 | 18.3498 | 0.021566 | 18 | 18.7781 | 0.029051 | 18.1354 | 0.061777 | 0.999671 | 0.999562 | 0.999327 | 0.999042 | 0.99935 | 61 | 512024576 | 5.93478 | 6.47688 | 4.99303 | 4.20024 | 4.27373 | 2.77074 | 2.31205 | 1.87484 | 1.62662 | 1.45794 | 0 | 4.03214 | 5.36095 | 5.44253 | ||||
109091553299077983 | 155.32985996 | 0.91460413 | 155.32988886 | 0.91458204 | 13 | 21.0622 | 0.034554 | 20.384 | 0.025749 | 12 | 19.7496 | 0.029529 | 19.1491 | 0.018316 | 18 | 19.3754 | 0.014256 | 18.697 | 0.018941 | 11 | 19.0907 | 0.014836 | 18.4181 | 0.022808 | 15 | 18.7832 | 0.03516 | 18.2793 | 0.044125 | 0.999667 | 0.999634 | 0.999229 | 0.999176 | 0.999643 | 53 | 444915712 | 3.55787 | 4.13522 | 3.15372 | 2.80053 | 3.06662 | 1.62989 | 1.61636 | 1.25456 | 1.09398 | 1.19706 | 0 | 3.3149 | 4.09851 | 3.95382 | ||||
109091554897205761 | -999 | -999 | 155.48960069 | 0.91276146 | 5 | 21.3409 | 0.096192 | 19.6764 | 0.076313 | 4 | 20.7341 | 0.210861 | 19.2442 | 0.062298 | 4 | 20.8052 | 0.253072 | 19.5661 | 0.124974 | 3 | 21.2265 | 0.121468 | 19.8865 | 0.094278 | 0 | -999 | -999 | -999 | -999 | 0.999139 | 0.99923 | 0.998889 | 0.997634 | -999 | 37 | 310697984 |
...
Sample Query 1 template (this is a template, just cut and paste, do not modify)
...