Your SQL command was:
SELECT TOP 100
s.apogee_id,s.ra, s.dec, s.glon, s.glat,
s.vhelio_avg,s.vscatter,
a.teff,a.logg, a.m_h, a.alpha_m,
dbo.fApogeeAspcapFlagN(a.aspcapflag),
dbo.fApogeeStarFlagN(s.starflag)
FROM apogeeStar s
JOIN aspcapStar a on a.apstar_id = s.apstar_id
WHERE (a.aspcapflag & dbo.fApogeeAspcapFlag('STAR_BAD')) = 0
and a.teff > 0 and a.m_h < -2
apogee_id | ra | dec | glon | glat | vhelio_avg | vscatter | teff | logg | m_h | alpha_m | Column1 | Column2 |
2M02264972+4457464 | 36.7072410583496 | 44.9629211425781 | 140.134614164 | -14.6987834598 | -141.778 | 0 | 5454.313 | 3.219407 | -2.590867 | -0.2195505 | METALS_WARN | SUSPECT_BROAD_LINES |
2M03115210-1121140 | 47.9670829772949 | -11.3539085388184 | 96.3372141634 | -60.1884830266 | -28.2266 | 0 | 6199.798 | -9999 | -2.289166 | 0.6678795 | SN_WARN STAR_WARN | |
2M03585942+5611127 | 59.7475509643555 | 56.1868591308594 | 146.921968516 | 2.31433434943 | -320.47 | 0 | 6106.694 | -9999 | -2.333948 | 0.4016035 | STAR_WARN LOGG_WARN | SUSPECT_BROAD_LINES |
2M06445636+2250145 | 101.234832763672 | 22.8373641967773 | 191.73152397 | 8.84265253153 | 0.559809 | 0 | 7710.037 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M06504983-0032270 | 102.707626342773 | -0.540883004665375 | 213.344111132 | -0.381731730323 | -10.4357 | 0 | 6606.622 | -9999 | -9999 | -9999 | | |
2M06513340-0657592 | 102.889198303223 | -6.96644020080566 | 219.151750173 | -3.14404921383 | -262.837 | 0 | 5802.539 | -9999 | -2.36916 | -0.396278 | STAR_WARN ALPHAFE_WARN METALS_WARN LOGG_WARN TEFF_WARN | |
2M10255481+3347462 | 156.478393554688 | 33.7961730957031 | 191.855457149 | 58.1118154892 | 11.1707 | 0 | 7956.573 | -9999 | -9999 | -9999 | STAR_WARN TEFF_WARN | SUSPECT_BROAD_LINES |
2M11552715+0907449 | 178.863174438477 | 9.12917137145996 | 264.002935954 | 67.6642987928 | 180.858 | 0.121297 | 4935.306 | 1.920478 | -2.276843 | 0.3917075 | NFE_WARN | |
2M12005238+0636518 | 180.218276977539 | 6.61440896987915 | 270.296246947 | 66.2280296442 | -5.77588 | 0.434254 | 7772.542 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M12121191+7736584 | 183.04963684082 | 77.6162338256836 | 125.638548248 | 39.3052205174 | -59.4409 | 0 | 6823.477 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M14023185+0941100 | 210.632690429688 | 9.68609619140625 | 350.167073689 | 65.8039488968 | -24.9832 | 0 | 4752.99 | 1.426359 | -2.552026 | 0.2842405 | NFE_WARN METALS_WARN | |
2M14163658+4221356 | 214.151992797852 | 42.3599014282227 | 79.7301688952 | 66.9233511904 | -63.3727 | 14.6436 | 7874.646 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION LOW_SNR |
2M15260106-0911388 | 231.504455566406 | -9.19412803649902 | 354.238677209 | 37.8300185098 | -164.084 | 0 | 4625.45 | 1.099077 | -2.502198 | 0.08919345 | SN_WARN STAR_WARN METALS_WARN | |
2M18272750+4949069 | 276.864593505859 | 49.8186111450195 | 78.2668856598 | 24.1011621099 | -28.0804 | 0 | 7520.081 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M22152563+0649214 | 333.856994628906 | 6.82262992858887 | 69.144754724 | -39.2391106897 | -64.8686 | 5.68761 | 7272.92 | -9999 | -9999 | -9999 | | SUSPECT_RV_COMBINATION |
2M17002727+3544183 | 255.113646 | 35.738426 | 58.7479598617 | 37.059722865 | -19.6535 | 0.0358191 | 6552.434 | -9999 | -9999 | -9999 | | |
2M17030646+3633427 | 255.776925 | 36.561886 | 59.8700409478 | 36.6610578021 | -316.618 | 0.136943 | 4634.768 | 1.212059 | -2.38515 | 0.4026304 | | |
2M17104698+3518481 | 257.695752 | 35.31337 | 58.6820721795 | 34.9164484636 | 20.9813 | 0.15491 | 6705.832 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17113159+3440081 | 257.881659 | 34.668926 | 57.947486374 | 34.6435484076 | -1.32919 | 0.351078 | 6600.507 | -9999 | -9999 | -9999 | VMICRO_WARN | |
2M17121360+3517075 | 258.056672 | 35.285435 | 58.7163107322 | 34.6219061442 | 20.9272 | 0.175299 | 6592.742 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17132277+3525512 | 258.344878 | 35.430904 | 58.9439945038 | 34.4188832202 | -7.26656 | 1.31827 | 7717.185 | -9999 | -9999 | -9999 | | |
2M17045824+3329375 | 256.242698 | 33.493763 | 56.2109327753 | 35.7434440983 | -210.815 | 0.249814 | 4760.212 | 1.568114 | -2.556825 | 0.2042291 | METALS_WARN | |
2M17075805+3502388 | 256.991911 | 35.044121 | 58.2276759719 | 35.431710595 | -9.27272 | 0.659565 | 6587.224 | -9999 | -9999 | -9999 | VMICRO_WARN | |
2M17080122+3351177 | 257.005117 | 33.854935 | 56.799929186 | 35.1930769015 | 35.9316 | 0.323119 | 6870.134 | -9999 | -9999 | -9999 | | |
2M17091372+3247329 | 257.307186 | 32.792477 | 55.5948568298 | 34.727080723 | -0.828972 | 0.218229 | 6557.302 | -9999 | -9999 | -9999 | VMICRO_WARN | SUSPECT_BROAD_LINES |
2M17102380+3404224 | 257.599187 | 34.072891 | 57.1806751664 | 34.7538305423 | 1.51312 | 0.0657786 | 6801.943 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17110602+3356388 | 257.775093 | 33.94413 | 57.0631896202 | 34.5849978807 | -21.7146 | 0.0499719 | 6587.531 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17113159+3440081 | 257.881659 | 34.668926 | 57.947486374 | 34.6435484076 | 10.6364 | 0.103992 | 6675.187 | -9999 | -9999 | -9999 | | |
2M17120693+3313210 | 258.028908 | 33.222523 | 56.2612865488 | 34.2276415578 | -404.861 | 0.287318 | 5086.841 | 1.811042 | -2.379595 | 0.4876854 | | |
2M17131282+3431146 | 258.303423 | 34.520744 | 57.8549292108 | 34.2738575862 | 7.22966 | 0.0699303 | 6709.664 | -9999 | -9999 | -9999 | | |
2M17132412+3433440 | 258.350539 | 34.562244 | 57.9135535239 | 34.2441743053 | -79.0634 | 0.241013 | 6615.625 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17142877+3410081 | 258.619888 | 34.168934 | 57.503417046 | 33.9462271245 | -304.008 | 0.197259 | 5105.719 | 2.471321 | -2.375925 | 0.2826334 | NFE_WARN | BRIGHT_NEIGHBOR |
2M17101448+3114368 | 257.560352 | 31.243565 | 53.8219436437 | 34.1722050146 | -41.543 | 0.234421 | 6579.322 | -9999 | -9999 | -9999 | | PERSIST_LOW |
2M17113195+3144444 | 257.883153 | 31.745676 | 54.4886729877 | 34.0204066869 | -14.8904 | 0.347438 | 6622.205 | -9999 | -9999 | -9999 | | PERSIST_LOW |
2M17123961+3108310 | 258.165043 | 31.141962 | 53.8496119806 | 33.6455539361 | -10.7192 | 1.42897 | 6551.993 | -9999 | -9999 | -9999 | VMICRO_WARN | PERSIST_LOW |
2M17140195+3223402 | 258.508135 | 32.394524 | 55.3945333423 | 33.6525402093 | 1.45771 | 1.36782 | 7203.358 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M17154966+3043167 | 258.956929 | 30.721327 | 53.5586901904 | 32.8845250895 | -18.6204 | 1.32942 | 6901.952 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M17172937+3205114 | 259.372376 | 32.08651 | 55.238088779 | 32.8701651962 | -5.97462 | 0.20928 | 6540.043 | -9999 | -9999 | -9999 | VMICRO_WARN | SUSPECT_BROAD_LINES |
2M17184080+3240025 | 259.670024 | 32.667377 | 55.9800013741 | 32.7614191151 | -27.9262 | 0.157492 | 6841.327 | -9999 | -9999 | -9999 | | |
2M17185417+3206549 | 259.725731 | 32.115261 | 55.355514959 | 32.5861463731 | 9.40876 | 0.565472 | 6582.748 | -9999 | -9999 | -9999 | VMICRO_WARN | SUSPECT_BROAD_LINES |
2M17190953+3304425 | 259.789715 | 33.078491 | 56.4832596147 | 32.7580374047 | -216.013 | 0.446689 | 4601.47 | 1.153058 | -2.269614 | 0.3869983 | | |
2M17193133+3104458 | 259.880568 | 31.079411 | 54.2037696882 | 32.2058193656 | -16.6145 | 0.28973 | 6899.92 | -9999 | -9999 | -9999 | | |
2M17204338+3105301 | 260.180756 | 31.091722 | 54.2938349731 | 31.9600158852 | 21.2153 | 0.444735 | 6950.976 | -9999 | -9999 | -9999 | | |
2M17211994+3119470 | 260.33312 | 31.329746 | 54.6038154265 | 31.8935316053 | 7.63942 | 8.04994 | 7982.166 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN TEFF_WARN | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M17144177+2758300 | 258.674075 | 27.975002 | 50.3336030246 | 32.4058088742 | -37.857 | 0 | 6566.873 | -9999 | -9999 | -9999 | VMICRO_WARN | |
2M17152024+2752553 | 258.834346 | 27.88205 | 50.2739868157 | 32.2440867171 | 28.5632 | 0 | 7401.31 | -9999 | -9999 | -9999 | | |
2M17155720+2804128 | 258.988372 | 28.070234 | 50.5320821696 | 32.1652060364 | 12.4591 | 0 | 7137.49 | -9999 | -9999 | -9999 | | |
2M17171602+2746463 | 259.316754 | 27.779552 | 50.2977228178 | 31.8058140168 | 9.82178 | 0 | 6744.79 | -9999 | -9999 | -9999 | STAR_WARN VMICRO_WARN LOGG_WARN | |
2M17174811+2844003 | 259.450494 | 28.733427 | 51.415833414 | 31.9552032227 | -16.3865 | 0 | 7393.189 | -9999 | -9999 | -9999 | | PERSIST_LOW |
2M17182262+2755287 | 259.594283 | 27.924648 | 50.5421588766 | 31.6108259708 | 24.0555 | 0 | 6570.69 | -9999 | -9999 | -9999 | VMICRO_WARN | |
2M17184847+2735451 | 259.701999 | 27.595865 | 50.2035917667 | 31.4267459192 | -241.974 | 0 | 7836.433 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN | SUSPECT_BROAD_LINES |
2M17190968+2601392 | 259.790338 | 26.027573 | 48.4772393928 | 30.8943121465 | -40.4353 | 0 | 6565.689 | -9999 | -9999 | -9999 | VMICRO_WARN | SUSPECT_BROAD_LINES |
2M17203581+2839445 | 260.14923 | 28.66238 | 51.532263321 | 31.3462010866 | -30.5343 | 0 | 6677.812 | -9999 | -9999 | -9999 | | |
2M17221177+2638093 | 260.549076 | 26.635942 | 49.3879643312 | 30.4265517094 | 9.8515 | 0 | 6562.92 | -9999 | -9999 | -9999 | | |
2M17221481+2824154 | 260.561749 | 28.404297 | 51.3602963696 | 30.9263364399 | -61.9102 | 0 | 7280.291 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17224202+2815389 | 260.675101 | 28.26082 | 51.2326037863 | 30.7902342256 | 15.5408 | 0 | 6811.8 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17252102+2749074 | 261.337622 | 27.818727 | 50.9353600552 | 30.1034206888 | -7.39346 | 0 | 6979.415 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M20595057-0013167 | 314.960738 | -0.221307 | 48.6800193162 | -28.3405306584 | -15.7693 | 0.0993378 | 7048.431 | -9999 | -9999 | -9999 | VMICRO_WARN | SUSPECT_BROAD_LINES PERSIST_LOW |
2M21001846+0046468 | 315.076956 | 0.779678 | 49.7182687335 | -27.9196409272 | 24.8696 | 0.0909252 | 6716.578 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21003591-0053573 | 315.149642 | -0.899276 | 48.1282589456 | -28.851048783 | 19.2447 | 0.046131 | 6577.87 | -9999 | -9999 | -9999 | VMICRO_WARN | |
2M21022031-0122308 | 315.58465 | -1.375249 | 47.914393067 | -29.4681641115 | 12.2117 | 0.0729458 | 7676.389 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21031515+0110561 | 315.813152 | 1.182251 | 50.5456869082 | -28.3336718891 | -14.0049 | 0.118974 | 6695.748 | -9999 | -9999 | -9999 | | |
2M21032904-0123141 | 315.871029 | -1.387277 | 48.0707008706 | -29.7204297689 | 0.530455 | 0.24042 | 7291.375 | -9999 | -9999 | -9999 | | |
2M21050161-0103316 | 316.256718 | -1.058792 | 48.6236820321 | -29.8826986378 | -37.3468 | 0.53461 | 7694.188 | -9999 | -9999 | -9999 | | SUSPECT_RV_COMBINATION |
2M21054932+0041566 | 316.455537 | 0.699073 | 50.4656521726 | -29.1343483575 | -11.1528 | 0.13407 | 6587.436 | -9999 | -9999 | -9999 | | |
2M21055009+0039263 | 316.458726 | 0.657306 | 50.4269933137 | -29.1591411645 | 17.7952 | 0.100571 | 6643.456 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21060046-0057060 | 316.501937 | -0.951686 | 48.8756641152 | -30.0373798155 | 8.50652 | 0.101563 | 6602.992 | -9999 | -9999 | -9999 | | |
2M21070128-0059353 | 316.75535 | -0.993143 | 48.9863102069 | -30.2756385801 | 114.012 | 0.0987906 | 4671.846 | 1.367501 | -2.025802 | 0.3308879 | NFE_WARN | |
2M21071366+0104019 | 316.806958 | 1.067216 | 51.0366815845 | -29.2366338333 | 2.35821 | 0.235131 | 5096.796 | 2.583412 | -2.39556 | 0.3193744 | NFE_WARN | |
2M21081137+0018023 | 317.047387 | 0.300657 | 50.4367129506 | -29.8473399283 | -5.50445 | 4.36207 | 7512.48 | -9999 | -9999 | -9999 | STAR_WARN LOGG_WARN | SUSPECT_RV_COMBINATION |
2M21084603-0002121 | 317.191822 | -0.036721 | 50.1938718437 | -30.1480968696 | -6.43339 | 0.0999126 | 7615.433 | -9999 | -9999 | -9999 | | |
2M21271739+0040470 | 321.822467 | 0.679735 | 53.8557773238 | -33.6549597317 | 11.1242 | 0.225702 | 6638.961 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21283166+0019096 | 322.13193 | 0.319341 | 53.7016243306 | -34.1124164576 | -7.63193 | 0.447739 | 6859.17 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES BRIGHT_NEIGHBOR |
2M21292127+0118556 | 322.338644 | 1.315451 | 54.8361077766 | -33.726795937 | 13.6944 | 1.26531 | 8015.417 | -9999 | -9999 | -9999 | STAR_WARN TEFF_WARN | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION BRIGHT_NEIGHBOR |
2M21292254+0108131 | 322.343918 | 1.136981 | 54.6622329709 | -33.8316423125 | 10.5802 | 4.49807 | 7833.907 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN VMICRO_WARN | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M21293325-0018042 | 322.388573 | -0.301188 | 53.2468122552 | -34.6692509386 | 16.8712 | 0.405112 | 6666.239 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21305678+0101303 | 322.736585 | 1.025108 | 54.8173757284 | -34.2190835278 | -26.9533 | 0.368737 | 6613.015 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21332943+0044430 | 323.372647 | 0.74528 | 54.9727629215 | -34.9020336515 | -0.701332 | 0.225924 | 6607.543 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21334187-0051401 | 323.424492 | -0.861142 | 53.3739793127 | -35.8421814903 | -9.8017 | 0.531206 | 6738.383 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES PERSIST_LOW |
2M21024825+0924574 | 315.701043 | 9.41595 | 58.1052783545 | -23.6752463335 | -19.1322 | 0.516626 | 6628.881 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES PERSIST_LOW PERSIST_MED |
2M21032618+0954121 | 315.859086 | 9.903385 | 58.6373914608 | -23.519999203 | -7.54011 | 2.76558 | 6775.975 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES PERSIST_LOW |
2M21040895+1001576 | 316.037293 | 10.032687 | 58.863492921 | -23.5875501504 | -21.1973 | 0.489672 | 7998.135 | -9999 | -9999 | -9999 | STAR_WARN TEFF_WARN | SUSPECT_BROAD_LINES PERSIST_LOW |
2M21045096+1115392 | 316.212374 | 11.260911 | 60.0567925067 | -23.0070827179 | 20.1633 | 0.35258 | 7179.606 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION PERSIST_LOW |
2M21045532+0921538 | 316.230525 | 9.364958 | 58.3905458988 | -24.1307466431 | 19.1967 | 0.477729 | 6555.507 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21045695+0906174 | 316.23732 | 9.104834 | 58.1623926638 | -24.2869793931 | 2.31449 | 0.12246 | 6697.62 | -9999 | -9999 | -9999 | | |
2M21051279+0854126 | 316.303292 | 8.903516 | 58.0235285718 | -24.456612843 | -55.8352 | 0.0782028 | 4394.857 | 0.7234721 | -2.148443 | 0.3796519 | | |
2M21053515+1045378 | 316.396499 | 10.760513 | 59.7325890993 | -23.4478855036 | 16.9968 | 0.180854 | 7126.989 | -9999 | -9999 | -9999 | | PERSIST_LOW |
2M21070903+0914550 | 316.787634 | 9.248619 | 58.6377321915 | -24.6456190024 | 0.567593 | 0.542765 | 6844.437 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21071622+1017502 | 316.817614 | 10.297284 | 59.5896008253 | -24.055224183 | 28.0269 | 0.946608 | 6863.895 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M21073714+0851355 | 316.904779 | 8.859863 | 58.3637857041 | -24.9660568644 | 21.9929 | 1.3088 | 7969.358 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN TEFF_WARN | SUSPECT_RV_COMBINATION |
2M21083562+0952263 | 317.148458 | 9.873975 | 59.4244466726 | -24.5677132241 | -6.99678 | 0.189665 | 6574.997 | -9999 | -9999 | -9999 | VMICRO_WARN | PERSIST_LOW |
2M21092555+1051284 | 317.356467 | 10.857908 | 60.4280899021 | -24.1505038996 | -29.262 | 0.477358 | 7239.274 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M21094459+1054215 | 317.435803 | 10.905974 | 60.5212446269 | -24.1844917686 | 27.8846 | 1.52132 | 7872.027 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN | SUSPECT_BROAD_LINES SUSPECT_RV_COMBINATION |
2M21101078+0926379 | 317.544931 | 9.443883 | 59.2947732916 | -25.1368297825 | -116.53 | 0.500417 | 4494.792 | 0.7135207 | -2.567696 | 0.5714505 | METALS_WARN | |
2M21114163+1011025 | 317.923471 | 10.184049 | 60.197156718 | -24.9994728266 | 13.7998 | 0.398018 | 6675.202 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17175751+5745488 | 259.489649 | 57.763557 | 86.2066769551 | 35.0301592018 | -5.33513 | 0 | 7359.607 | -9999 | -9999 | -9999 | COLORTE_WARN STAR_WARN | SUSPECT_BROAD_LINES |
2M17193183+5831452 | 259.882653 | 58.529247 | 87.1205082081 | 34.7701983472 | -34.8753 | 0 | 6593.604 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17202564+5753044 | 260.106844 | 57.88456 | 86.3283345443 | 34.6944565567 | -50.5615 | 0 | 6872.914 | -9999 | -9999 | -9999 | | SUSPECT_BROAD_LINES |
2M17221518+5716420 | 260.563285 | 57.278339 | 85.5773321977 | 34.4820186426 | -2.07677 | 0 | 6665.617 | -9999 | -9999 | -9999 | VMICRO_WARN | PERSIST_MED BRIGHT_NEIGHBOR |
2M17232296+5621409 | 260.845706 | 56.361385 | 84.4594069729 | 34.362435488 | -5.49909 | 0 | 6639.549 | -9999 | -9999 | -9999 | | PERSIST_LOW |