SDSS Query Results

Your SQL command was:

 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

Your query output (max 500,000 rows):

bestobjid	specobjid	plate	mjd	fiberid	teffadop	fehadop	loggadop	snr	flag
1237655471822471305	2447835924042718208	2174	53521	471	5256.201	-1.571318	2.682663	48.46709	nnngn
1237655471822471510	2447838397943880704	2174	53521	480	5359.256	-1.576856	2.672465	39.2668	nnngn
1237655471822471238	2447858738908994560	2174	53521	554	5240.685	-1.64079	2.365397	53.98549	nnngn
1237655471822471219	2447860388176436224	2174	53521	560	5441.453	-1.509529	2.894075	30.17394	nnngn
1237655373038354570	2447861212810157056	2174	53521	563	5280.502	-1.765453	2.662382	43.98692	nnngn
1237666211391209784	2457989089543088128	2183	53536	544	5462.372	-1.946091	2.979019	47.09299	nnngn
1237666228569702932	2457974795891927040	2183	53536	492	5435.488	-1.727259	2.812558	41.9136	nnngn
1237666211927687596	2457961326874486784	2183	53536	443	5366.009	-1.899273	2.827104	57.30849	nnngn
1237665571452944519	2457958303217510400	2183	53536	432	5276.87	-1.589958	2.381374	37.05894	nnBgn
1237666228032701014	2457958028339603456	2183	53536	431	5238.569	-1.642147	2.665878	32.53284	nnngn

Use the button below to upload the results of the above query to the SAS and from there click Search to download or view the spectra:
Upload list of spectra to SAS

Your query output (max 500,000 rows):

Use the button below to upload the results of the above query to the SAS and from there click Search to download or view the spectra: