Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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

1233115492812104771.08618
 
objIDraStackdecStackraMeandecMeannggMeanPSFMaggMeanPSFMagErrgMeanKronMaggMeanKronMagErrnrrMeanPSFMagrMeanPSFMagErrrMeanKronMagrMeanKronMagErrniiMeanPSFMagiMeanPSFMagErriMeanKronMagiMeanKronMagErrnzzMeanPSFMagzMeanPSFMagErrzMeanKronMagzMeanKronMagErrnyyMeanPSFMagyMeanPSFMagErryMeanKronMagyMeanKronMagErrgQfPerfectrQfPerfectiQfPerfectzQfPerfectyQfPerfectqualityFlagobjInfoFlaggpetRadiusrpetRadiusipetRadiuszpetRadiusypetRadiusgpetR50rpetR50ipetR50zpetR50ypetR50gpsfLikelihoodgKronRadrKronRadiKronRad
109081656511207587165.65123799154.9281261112.75831367154.9281143112.758325181020.08350.0244019060225119165.30165123160.028161906004561671921.041564370.0397183678651820.20904930.009343058567122018.632665740.0233091844061719.705339620.01184907203312211820.013559460.0296430780821719.428319980.00991402617314111820.107756990.0425340765521719.328111580.023553033139220.240.99981200860819.10510.999532027960.9994089997340.9998189994270.999398999521615120245767.654646.897815.744120.9993960.9974685344491571210.42675.579774.2107461004214.78133122526.361782154925.054822602524.0514089351.67238
123311556359837190155.6359545612.76391817155.6359425412.763930651720.63170.02961220.13220.0308722219.58720.03523619.0090.0155462419.20380.02263218.54630.0135141318.72410.02960518.24880.0164071518.71480.02514318.16580.0365890.9998410.9996670.9997230.9996960.999486615120245764.117643.192343.371763.557033.554011.646431.286591.304571.413521.64367
123311563608493897156.3608017212.76123503156.3608191812.761232671219.68280.05332417.59690.0139961019.69950.21460917.24010.0148491419.65990.08852617.14260.013593619.25740.07735617.32680.023463519.49230.21471217.93440.0357960.9995780.9998050.9997710.9995480.9982635344491571210.875911.19911.148410.53479.508674.437944.407084.526884.212623.28768
123311564766811688156.4767324812.75933957156.4767647912.759337741020.60360.03883520.22540.0288231219.61610.02944919.06410.0263251919.29170.02141718.78120.016662918.91180.02102518.54090.0359191218.82950.02484718.36640.056010.999620.9996730.9996850.9995860.99939534449157124.005643.491434.640694.7902-9.089561.38871.119211.253591.44259-9.07378
123311565993385602156.5993128912.76262096156.5993187212.762623021019.35030.02654218.47210.0225391418.80370.03286418.00290.0204261518.55670.01202417.63360.0123151118.32970.06131917.3870.0167211718.24860.05307417.25160.0872250.9998340.9993080.9994170.9998120.999327615120245763.114292.812842.978543.1178.682951.008330.9806321.071040.9847752.965
123311564444738006156.4444791712.76459414156.4445027712.76459045919.95330.02600519.45650.0180231418.96690.01797118.26640.0118211418.5550.0180517.79320.00674718.15250.04844917.50990.019581618.03240.05489917.37980.0214010.9996580.9995810.9996570.9995160.999339615120245764.858214.281384.095613.925654.571841.852111.57081.530561.57951.66867
123311566009794928156.6010257412.76200927156.6010230412.762018481019.0360.05909618.08170.022481417.94790.04404117.12540.0157341417.64110.02353416.71420.006589917.22560.05724716.43490.0057361617.08580.05509616.14440.032470.9996660.9990910.9996630.9994640.998955615120245765.992775.451154.691985.37832.765492.436622.23881.86532.152311.06782
123311566048421351156.6048448112.75900132156.6048454612.7590098819.23690.03449118.7270.0242391218.39250.0109517.75540.0102321618.03910.02866117.34290.0056091117.66640.02475517.08230.0109941817.55880.03483517.02710.0118150.9996640.9995440.9996020.9996230.999433615120245764.166813.540433.218583.6975526.10361.568391.363761.275061.37458-999
123311569207978960156.9207648212.76540801156.9207605612.76544365920.88240.06393520.12540.0383681220.19920.02804719.39530.026821419.9630.01710419.11690.0223851119.39160.09316918.84230.0472321419.37030.05030218.62630.0604360.9995120.9997060.9998580.9993530.999578534449157125.588584.867154.594965.163384.859842.104452.048281.827242.169792.12018
123311577928974093157.7928819512.76131325157.7928603812.761336821019.84320.02699419.41510.0373581419.02660.01078318.50780.009612018.64030.01435918.10070.0080811518.3020.02894917.90150.0164421418.34220.02580217.82780.008720.9992930.9992350.9990650.9992430.9993746151202457613.27313.464663.095033.83952.81046.115661.39391.233341.3563
714275.207232.503062.9793605.316114.991346.30024
109081657271754110165.727168550.90305714165.72715640.903043721420.13350.05522519.37790.0270961819.10850.05028217.94620.022754118.36190.03444217.40180.0063971418.40430.02648317.16190.010811518.08930.0277317.13870.0210280.9998180.9996660.9997560.9992830.9992136151202457617.39587.082746.859666.214116.624785.230862.768162.693692.502312.4374206.147827.207998.64767
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.127764.207983.300793.079223.512891.669211.625551.300191.182621.261711.10623E-284.502344.898164.61272
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.127764.207983.300793.079223.512891.669211.625551.300191.182621.261718.32451E-384.506764.955314.66793
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.451584.515673.299453.263783.356851.716031.699791.290041.214741.320691.10623E-284.502344.898164.61272
109081660112548426166.011254190.90667221166.011229910.906672741019.67370.01875619.13820.0557951419.01170.02988518.45360.0463323718.43670.02598917.94020.0114791218.4730.00992717.78090.0200741518.19920.01773617.58470.0255770.9997270.9995910.9997510.9989760.99934615120245764.451584.515673.299453.263783.356851.716031.699791.290041.214741.320698.32451E-384.506764.955314.66793
109081663334564862166.333503430.90367258166.333523840.903649831120.10580.07697518.74240.0180331819.84830.04617118.23470.0287032619.40880.04793317.97610.0125731219.8440.05079218.18780.050531019.49140.07334418.1280.0603830.9996170.99960.9996370.9994390.998929534449157126.443186.3457847.4016.38315.810852.483342.50278-9992.167521.9412906.672846.624357.05478
109091546911366908154.691110520.91371481154.691116130.913722151221.52110.06192520.63930.0387231219.87120.03321419.13340.037061819.36710.02713818.63870.0201941219.1640.03295418.34980.0215661818.77810.02905118.13540.0617770.9996710.9995620.9993270.9990420.99935615120245765.934786.476884.993034.200244.273732.770742.312051.874841.626621.4579404.032145.360955.44253
109091553299077983155.329859960.91460413155.329888860.914582041321.06220.03455420.3840.0257491219.74960.02952919.14910.0183161819.37540.01425618.6970.0189411119.09070.01483618.41810.0228081518.78320.0351618.27930.0441250.9996670.9996340.9992290.9991760.999643534449157123.557874.135223.153722.800533.066621.629891.616361.254561.093981.1970603.31494.098513.95382
109091554897205761-999-999155.489600690.91276146521.34090.09619219.67640.076313420.73410.21086119.24420.062298420.80520.25307219.56610.124974321.22650.12146819.88650.0942780-999-999-999-9990.9991390.999230.9988890.997634-99937310697984              

 

 

...

Sample Query 1 template (this is a template, just cut and paste, do not modify)

...