SDSS Query Results

Your SQL command was:

SELECT TOP 30 
s.plate,s.mjd,s.fiberid 
FROM ..SpecObj as s 
JOIN PhotoObj AS p ON s.bestobjid=p.objid 
WHERE  (p.i - p.z) > 3 AND (p.i - p.z) < 4 AND p.u > 0

Your query output (max 500,000 rows):

plate	mjd	fiberid
2052	53401	343
7258	56605	798
7258	56605	970
7258	56605	847
7258	56605	673
1259	52931	385
307	51663	257
4745	55892	330
468	51912	282
3841	55572	654
4007	55327	90
420	51871	7
339	51692	607
3792	55212	527
474	52000	233
476	52314	323
7294	56739	339
7288	57039	107
7285	56991	515
443	51873	89
7311	57038	373
2677	54180	99
7311	57038	650
6377	56245	947
7275	57093	534
2053	53446	55
7378	56715	291
7318	56990	795
355	51788	278
351	51695	574

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

Your SQL command was:
SELECT TOP 30 s.plate,s.mjd,s.fiberid FROM ..SpecObj as s JOIN PhotoObj AS p ON s.bestobjid=p.objid WHERE (p.i - p.z) > 3 AND (p.i - p.z) < 4 AND p.u > 0

Your query output (max 500,000 rows):

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:

Your SQL command was: SELECT TOP 30 s.plate,s.mjd,s.fiberid FROM ..SpecObj as s JOIN PhotoObj AS p ON s.bestobjid=p.objid WHERE (p.i - p.z) > 3 AND (p.i - p.z) < 4 AND p.u > 0

Your query output (max 500,000 rows):

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:

Your SQL command was:
SELECT TOP 30 s.plate,s.mjd,s.fiberid FROM ..SpecObj as s JOIN PhotoObj AS p ON s.bestobjid=p.objid WHERE (p.i - p.z) > 3 AND (p.i - p.z) < 4 AND p.u > 0