Your SQL command was:
SELECT TOP 50
photoobj.run, photoobj.camcol, photoobj.field, photoobj.obj,
photoobj.psfmag_u, photoobj.psfmag_g, photoobj.psfmag_r,
photoobj.psfmag_i, photoobj.psfmag_z,
photoobj.ra as photoobj_ra, photoobj.dec as photoobj_dec,
star.apstar_id, star.ra as star_ra, star.dec as star_dec,
aspcap.teff, aspcap.m_h, aspcap.logg
FROM apogeeStar AS star
CROSS APPLY dbo.fGetNearestObjEq( star.ra, star.dec, 0.05) AS near
JOIN photoobj ON near.objid=photoobj.objid
JOIN aspcapStar as aspcap ON star.apstar_id = aspcap.apstar_id
WHERE star.glat > 60. and aspcap.teff > 0
| run | camcol | field | obj | psfmag_u | psfmag_g | psfmag_r | psfmag_i | psfmag_z | photoobj_ra | photoobj_dec | apstar_id | star_ra | star_dec | teff | m_h | logg |
| 4646 | 6 | 117 | 31 | 9.627772 | 14.56853 | 13.78523 | 13.93141 | 6.935448 | 211.732382864921 | 28.4381252023225 | apogee.apo1m.s.stars.1.2M14065583+2826168 | 211.732650756836 | 28.438024520874 | 4885.425 | -0.126327 | 2.512196 |
| 3813 | 1 | 129 | 122 | 13.34685 | 11.57479 | 10.51801 | 10.22186 | 11.23738 | 165.002251528695 | 42.2627328491461 | apogee.apo25m.s.stars.2111.2M11000054+4215459 | 165.002291 | 42.262753 | 4653.202 | -0.4375612 | 2.497646 |
| 3813 | 1 | 137 | 21 | 13.02661 | 11.90973 | 11.23596 | 11.11832 | 11.61838 | 166.457794224256 | 42.4958978282368 | apogee.apo25m.s.stars.2111.2M11054988+4229452 | 166.457866 | 42.495895 | 5708.114 | 0.1330739 | -9999 |
| 3813 | 1 | 129 | 104 | 14.87798 | 13.41448 | 12.8538 | 12.70026 | 12.66427 | 164.995086439766 | 42.1649989844138 | apogee.apo25m.s.stars.2111.2M10595883+4209540 | 164.995136 | 42.165012 | 5532.617 | 0.1810543 | -9999 |
| 3813 | 1 | 129 | 10 | 11.13019 | 9.766741 | 9.111295 | 8.989175 | 9.81788 | 164.917574169993 | 42.1566603770513 | apogee.apo25m.s.stars.2111.2M10594029+4209239 | 164.917896 | 42.156654 | 5748.808 | -0.0326529 | -9999 |
| 3647 | 6 | 165 | 49 | 18.62515 | 16.03593 | 14.63593 | 13.70693 | 13.21625 | 164.439823860804 | 41.7913635139693 | apogee.apo25m.s.stars.2111.2M10574554+4147289 | 164.439769 | 41.791382 | 3734.558 | -0.3737789 | -9999 |
| 3647 | 6 | 165 | 14 | 16.84863 | 14.53847 | 13.61 | 13.24605 | 13.08153 | 164.372696262279 | 41.7435873977765 | apogee.apo25m.s.stars.2111.2M10572943+4144367 | 164.372625 | 41.743549 | 4567.737 | -0.08517773 | -9999 |
| 3647 | 6 | 164 | 119 | 12.50991 | 11.32091 | 10.99155 | 10.90003 | 11.30722 | 164.347278953108 | 41.762140121981 | apogee.apo25m.s.stars.2111.2M10572333+4145438 | 164.347235 | 41.762169 | 5933.632 | -0.08123405 | -9999 |
| 3647 | 6 | 164 | 75 | 16.78458 | 14.0713 | 12.66689 | 11.36681 | 11.08214 | 164.311417365277 | 41.7151089801398 | apogee.apo25m.s.stars.2111.2M10571475+4142549 | 164.311472 | 41.715252 | 3659.823 | -0.08470868 | -9999 |
| 3647 | 3 | 166 | 22 | 14.43831 | 13.03243 | 13.75273 | 12.48319 | 12.49788 | 164.963939989212 | 40.6755715654796 | apogee.apo25m.s.stars.2111.2M10595133+4040321 | 164.963916 | 40.675594 | 5659.842 | 0.04143457 | -9999 |
| 3813 | 4 | 129 | 15 | 13.22222 | 12.01107 | 11.61319 | 11.50784 | 11.49706 | 164.507687027044 | 43.3573152802242 | apogee.apo25m.s.stars.2111.2M10580185+4321264 | 164.507724 | 43.357334 | 5866.606 | 0.03453673 | -9999 |
| 3840 | 5 | 75 | 76 | 14.69315 | 14.00047 | 12.06241 | 13.36061 | 11.72545 | 164.937690123626 | 41.3635500055182 | apogee.apo25m.s.stars.2111.2M10594504+4121488 | 164.937708 | 41.363567 | 4873.786 | 0.01345973 | 3.219723 |
| 3840 | 5 | 77 | 49 | 14.31427 | 12.58135 | 11.89344 | 11.68464 | 12.59063 | 165.314690110144 | 41.4266562507467 | apogee.apo25m.s.stars.2111.2M11011552+4125359 | 165.314679 | 41.426666 | 5257.709 | 0.07798503 | -9999 |
| 3893 | 4 | 72 | 5 | 15.59326 | 13.51465 | 12.72676 | 12.42678 | 12.23389 | 164.267315926456 | 41.0144411388954 | apogee.apo25m.s.stars.2111.2M10570416+4100519 | 164.267341 | 41.01442 | 4659.407 | -0.5260166 | 2.274538 |
| 3664 | 5 | 86 | 18 | 10.0213 | 10.81568 | 10.7193 | 10.42702 | 9.845544 | 224.033236720839 | 43.3179668198813 | apogee.apo1m.s.stars.1.2M14560801+4319041 | 224.033386230469 | 43.3178024291992 | 5403.166 | 0.1197266 | -9999 |
| 4678 | 3 | 145 | 35 | 10.11929 | 14.18926 | 14.31161 | 13.76551 | 6.723223 | 223.379987842031 | 19.8883938585407 | apogee.apo1m.s.stars.1.2M14533121+1953183 | 223.38005065918 | 19.888427734375 | 4698.854 | 0.1295861 | 2.433572 |
| 5183 | 4 | 590 | 29 | 10.97945 | 15.23201 | 15.15539 | 7.358258 | 7.475739 | 223.346157881838 | 18.235378470718 | apogee.apo1m.s.stars.1.2M14532303+1814074 | 223.345977783203 | 18.2354011535645 | 4925.401 | 0.1509378 | 3.148532 |
| 4576 | 3 | 668 | 123 | 10.34203 | 8.735462 | 14.81741 | 7.941055 | 8.204534 | 223.299478952842 | 28.5083603243397 | apogee.apo1m.s.stars.1.2M14531191+2830295 | 223.299667358398 | 28.5082149505615 | 5021.073 | -0.1562235 | 3.439703 |
| 4512 | 5 | 159 | 40 | 9.6803 | 14.37813 | 10.75301 | 10.1895 | 9.471613 | 223.182288734222 | 31.9249602099603 | apogee.apo1m.s.stars.1.2M14524375+3155301 | 223.182342529297 | 31.9250411987305 | 4911.506 | 0.09738509 | 2.572517 |
| 3813 | 6 | 368 | 24 | 11.89331 | 10.63174 | 10.73068 | 10.81759 | 10.96933 | 214.152530624045 | 42.3600670179412 | apogee.apo1m.s.stars.1.2M14163658+4221356 | 214.151992797852 | 42.3599014282227 | 7874.646 | -9999 | -9999 |
| 2391 | 5 | 42 | 46 | 10.547 | 8.221742 | 7.432834 | 7.052735 | 7.928219 | 213.475804163728 | 7.12152220471357 | apogee.apo1m.s.stars.1.2M14135418+0707172 | 213.47575378418 | 7.12146902084351 | 4723.28 | 0.2287455 | 2.681994 |
| 3919 | 5 | 67 | 43 | 10.56902 | 15.04672 | 11.70293 | 14.78806 | 13.27939 | 212.607527962315 | 39.5263045059218 | apogee.apo1m.s.stars.1.2M14102581+3931346 | 212.607543945313 | 39.5262794494629 | 4955.879 | 0.1488684 | 3.430855 |
| 3818 | 2 | 306 | 30 | 11.42105 | 7.99011 | 14.44707 | 13.89656 | 6.718943 | 212.498839150543 | 40.7782480638076 | apogee.apo1m.s.stars.1.2M14095971+4046417 | 212.498794555664 | 40.7782745361328 | 4532.173 | 0.1576514 | 2.251074 |
| 4576 | 1 | 599 | 70 | 24.63392 | 17.30725 | 16.04617 | 16.24029 | 14.45026 | 211.609224801224 | 30.8463670303937 | apogee.apo1m.s.stars.1.2M14062615+3050475 | 211.608978271484 | 30.8465366363525 | 4714.563 | 0.1321718 | 3.291756 |
| 4552 | 2 | 245 | 26 | 10.55515 | 10.38742 | 10.0028 | 9.749068 | 7.321417 | 210.631657709571 | 31.6609415948455 | apogee.apo1m.s.stars.1.2M14023163+3139390 | 210.6318359375 | 31.6608543395996 | 5956.513 | 0.001353728 | -9999 |
| 5087 | 5 | 334 | 74 | 9.938412 | 14.08908 | 10.91683 | 10.24074 | 7.678409 | 204.855631637934 | 26.6846533460937 | apogee.apo1m.s.stars.1.2M13392537+2641052 | 204.855743408203 | 26.6847953796387 | 4877.198 | 0.1239047 | 2.56364 |
| 5224 | 1 | 327 | 142 | 9.920289 | 7.971127 | 7.25637 | 7.141893 | 7.813651 | 204.503424611957 | 22.5272938884654 | apogee.apo1m.s.stars.1.2M13380093+2231385 | 204.503890991211 | 22.5273761749268 | 4899.833 | -0.02067808 | 3.179154 |
| 6174 | 4 | 71 | 13 | 10.31826 | 8.872067 | 8.508085 | 8.466306 | 8.783274 | 204.315583664964 | 4.41765352204274 | apogee.apo1m.s.stars.1.2M13371576+0425034 | 204.315673828125 | 4.41762065887451 | 6234.019 | -0.3313441 | -9999 |
| 3103 | 2 | 233 | 50 | 15.42658 | 15.98825 | 8.412766 | 14.71689 | 15.04739 | 204.139719363537 | 52.6874624257535 | apogee.apo1m.s.stars.1.2M13363360+5241148 | 204.139999389648 | 52.6874694824219 | 4003.627 | 0.3454049 | 1.464681 |
| 6174 | 3 | 59 | 51 | 9.184104 | 14.45934 | 14.59964 | 10.29949 | 12.10174 | 203.288269875573 | 5.85311991358594 | apogee.apo1m.s.stars.1.2M13330920+0551110 | 203.288345336914 | 5.85305881500244 | 5027.63 | -0.3284285 | 2.420166 |
| 5183 | 1 | 401 | 62 | 10.65757 | 10.1583 | 9.092672 | 9.467793 | 7.992647 | 193.323833384429 | 21.2449974747564 | apogee.apo1m.s.stars.1.2M12531775+2114418 | 193.323974609375 | 21.2449588775635 | 4981.728 | 0.2562821 | 2.715051 |
| 6005 | 1 | 184 | 70 | 9.979392 | 10.46762 | 10.11897 | 9.516441 | 6.616284 | 192.9035464645 | 3.05677661691419 | apogee.apo1m.s.stars.1.2M12513689+0303242 | 192.903732299805 | 3.05674695968628 | 4397.991 | 0.06872979 | 2.00136 |
| 5115 | 1 | 136 | 116 | 10.0991 | 7.895464 | 6.716527 | 6.577703 | 7.6018 | 192.452776889525 | 26.4313385466902 | apogee.apo1m.s.stars.1.2M12494863+2625524 | 192.452651977539 | 26.4312400817871 | 4717.693 | -0.07266475 | 2.567446 |
| 2964 | 1 | 354 | 62 | 10.0641 | 14.21149 | 6.601258 | 6.58954 | 11.9148 | 192.408453442612 | 48.7400932905906 | apogee.apo1m.s.stars.1.2M12493802+4844241 | 192.408462524414 | 48.7400398254395 | 4593.585 | 0.02454633 | 2.490499 |
| 5225 | 1 | 179 | 281 | 9.755933 | 13.92219 | 7.227499 | 7.190938 | 7.704916 | 192.001636993314 | 18.836879044208 | apogee.apo1m.s.stars.1.2M12480040+1850125 | 192.001678466797 | 18.8368072509766 | 4968.844 | -0.3006276 | 2.446394 |
| 6005 | 3 | 187 | 152 | 10.58007 | 14.30645 | 10.5306 | 9.603684 | 5.717469 | 191.964227073672 | 3.57270063349995 | apogee.apo1m.s.stars.1.2M12475142+0334217 | 191.964263916016 | 3.57270503044128 | 3777.537 | 0.2794649 | 1.199219 |
| 4381 | 5 | 139 | 24 | 8.992086 | 14.35872 | 9.11705 | 8.983899 | 8.889258 | 191.794151455898 | 15.591693029286 | apogee.apo1m.s.stars.1.2M12471058+1535300 | 191.794097900391 | 15.591685295105 | 5143.401 | -0.05409937 | 2.719326 |
| 3130 | 5 | 11 | 17 | 10.55074 | 14.20093 | 10.87091 | 10.32444 | 7.607872 | 183.073932952367 | 55.70590126581 | apogee.apo1m.s.stars.1.2M12121780+5542211 | 183.074172973633 | 55.7058868408203 | 4543.62 | 0.3205968 | 2.669892 |
| 5115 | 1 | 74 | 70 | 10.09694 | 8.186426 | 7.351937 | 7.25503 | 7.761972 | 182.155232115261 | 26.4935518252126 | apogee.apo1m.s.stars.1.2M12083723+2629369 | 182.155166625977 | 26.4935932159424 | 4888.905 | 0.001332125 | 2.457286 |
| 3893 | 5 | 154 | 25 | 8.822527 | 8.967754 | 10.79955 | 10.13103 | 7.0848 | 180.619980745764 | 43.0836699307131 | apogee.apo1m.s.stars.1.2M12022896+4305030 | 180.620697021484 | 43.0841674804688 | 4970.894 | -0.3956454 | 3.185587 |
| 6781 | 3 | 106 | 70 | 9.878724 | 9.658506 | 9.189985 | 8.844587 | 5.989431 | 180.218208784706 | 6.61432247364142 | apogee.apo1m.s.stars.1.2M12005238+0636518 | 180.218276977539 | 6.61440896987915 | 7772.542 | -9999 | -9999 |
| 4599 | 5 | 72 | 74 | 9.056576 | 14.28639 | 10.08893 | 5.479802 | 12.13771 | 179.823057732311 | 33.1669807596021 | apogee.apo1m.s.stars.1.2M11591754+3310013 | 179.823104858398 | 33.1670379638672 | 4562.472 | -0.1298834 | 2.172349 |
| 3031 | 2 | 391 | 43 | 11.84589 | 9.901222 | 9.146066 | 8.922071 | 8.974235 | 178.863182518519 | 9.12913463050086 | apogee.apo1m.s.stars.1.2M11552715+0907449 | 178.863174438477 | 9.12917137145996 | 4935.306 | -2.276843 | 1.920478 |
| 5071 | 5 | 375 | 9 | 11.57888 | 10.47513 | 10.07582 | 9.992095 | 10.50248 | 172.451899704843 | 30.0672930542119 | apogee.apo1m.s.stars.1.2M11294849+3004025 | 172.451995849609 | 30.0673007965088 | 6474.186 | -1.643466 | -9999 |
| 4576 | 1 | 363 | 55 | 9.821278 | 7.785551 | 6.951107 | 6.951486 | 7.394396 | 169.88203001644 | 32.8252324694589 | apogee.apo1m.s.stars.1.2M11193174+3249303 | 169.882293701172 | 32.8251113891602 | 4875.509 | 0.08557621 | 2.546615 |
| 3840 | 6 | 99 | 63 | 9.704265 | 7.847602 | 7.335683 | 6.735571 | 7.004837 | 169.619691606044 | 42.3163474260344 | apogee.apo1m.s.stars.1.2M11182872+4218589 | 169.619674682617 | 42.3163795471191 | 4899.64 | -0.09850119 | 2.480001 |
| 5183 | 4 | 253 | 107 | 9.676451 | 7.699745 | 7.124043 | 6.812498 | 6.622352 | 169.5056427317 | 22.1798706450814 | apogee.apo1m.s.stars.1.2M11180141+2210476 | 169.505889892578 | 22.1799163818359 | 5082.363 | 0.03159863 | 2.774633 |
| 3631 | 1 | 347 | 96 | 8.991037 | 7.348243 | 14.70647 | 14.1822 | 6.366793 | 168.965960987298 | 13.3076738354965 | apogee.apo1m.s.stars.1.2M11155189+1318272 | 168.966201782227 | 13.3075656890869 | 4448.327 | 0.06996691 | 2.002679 |
| 4576 | 3 | 356 | 35 | 18.76637 | 16.78137 | 15.597 | 16.35461 | 6.550088 | 168.332085817796 | 33.4437646994414 | apogee.apo1m.s.stars.1.2M11131971+3326374 | 168.332168579102 | 33.443733215332 | 4612.469 | -0.4050017 | 2.421538 |
| 4576 | 1 | 350 | 20 | 10.54449 | 7.928596 | 6.844697 | 6.660902 | 7.863479 | 167.481449144584 | 32.531188843812 | apogee.apo1m.s.stars.1.2M11095557+3231519 | 167.481567382813 | 32.5310974121094 | 4811.84 | 0.2113782 | 2.977599 |