SELECT top 10 so.bestobjid, so.specobjid, so.plate, so.mjd, so.fiberid, sp.teffadop, sp.fehadop, sp.loggadop, sp.snr, sp.flag FROM specobjall so JOIN sppparams sp ON so.specobjid = sp.specobjid and so.sciencePrimary=1 WHERE sp.teffadop > 4500 and sp.teffadop < 5500 and fehadop > -2 and fehadop < -1.5 and loggadop > 2 and loggadop < 3 and sp.flag like '_n%' and sp.snr > 30
bestobjid | specobjid | plate | mjd | fiberid | teffadop | fehadop | loggadop | snr | flag |
1237648721220599866 | 307454270284785664 | 273 | 51957 | 304 | 5225.076 | -1.907118 | 2.398281 | 47.8478 | nnngn |
1237674649928466441 | 319764127356577792 | 284 | 51943 | 31 | 5197.167 | -1.669494 | 2.553227 | 57.61084 | nnngn |
1237671990805397538 | 336684782110926848 | 299 | 51671 | 148 | 5389.135 | -1.667502 | 2.819253 | 58.46898 | nnngn |
1237674603753963554 | 342334621570066432 | 304 | 51609 | 222 | 5326.392 | -1.897367 | 2.847921 | 34.52435 | nnngn |
1237654670287437907 | 363676142365861888 | 323 | 51615 | 38 | 5380.791 | -1.752639 | 2.674004 | 30.58183 | nnngn |
1237674648855838762 | 363742937697249280 | 323 | 51615 | 281 | 5372.768 | -1.630422 | 2.835036 | 37.0514 | nnngn |
1237671140405936144 | 369356505503262720 | 328 | 52282 | 223 | 5187.774 | -1.92657 | 2.271522 | 30.15265 | nnngn |
1237671128050565320 | 369356780381169664 | 328 | 52282 | 224 | 5470.338 | -1.685686 | 2.989065 | 33.87917 | nnngn |
1237650371559292943 | 377266387422308352 | 335 | 52000 | 327 | 5349.272 | -1.822258 | 2.6914 | 32.61974 | nnngn |
1237651252580122659 | 684694512831850496 | 608 | 52081 | 536 | 5416.688 | -1.609502 | 2.068411 | 30.67893 | nnngn |
Use the button below to upload the results of the above query to the SAW and from there click Search to download or view the spectra: | Upload list of spectra to SAW |