SDSS Query Results

Your SQL command was:

CREATE TABLE #upload ( up_id int, up_name varchar(32), up_ra float, up_dec float ) 
INSERT INTO #upload values ( 1, 'A1', 195.2, 2.5),( 2, 'A2', 194.5, 2.6),( 3, 'A3', 193.6, 2.8),( 4, 'A4', -90.1, -90.051)
create table #x (up_id int,objID bigint)
INSERT INTO #x 
SELECT up_id, dbo.fGetNearestObjIdEq(up_ra,up_dec,0.5) as objId 
     FROM #upload WHERE dbo.fGetNearestObjIdEq(up_ra,up_dec,0.5) IS NOT NULL 
SELECT u.up_name as [name], 
   p.objID, p.ra, p.dec, p.run, p.rerun, p.camcol, p.field,
   dbo.fPhotoTypeN(p.type) as type,
   p.modelMag_u, p.modelMag_g, p.modelMag_r, p.modelMag_i, p.modelMag_z 
FROM #x x, #upload u, PhotoTag p
WHERE u.up_id = x.up_id and x.objID=p.objID 
ORDER BY x.up_id

Your query output (max 500,000 rows):

name	objID	ra	dec	run	rerun	camcol	field	type	modelMag_u	modelMag_g	modelMag_r	modelMag_i	modelMag_z
A1	1237651754016965215	195.203427667563	2.49847295457233	1462	301	4	466	GALAXY	23.8992	21.42422	20.57347	19.72576	19.14023
A2	1237651754016637114	194.498200172082	2.59933439020135	1462	301	4	461	STAR	23.8924	24.23151	23.78504	22.06244	23.31111
A3	1237651736836637478	193.597924549659	2.80119305327068	1458	301	4	459	GALAXY	24.08971	22.89107	21.61831	21.61565	20.43842

Use the button below to upload the results of the above query to the SAW and retrieve the corresponding FITS files:
Upload list of fields to SAW

Your query output (max 500,000 rows):

Use the button below to upload the results of the above query to the SAW and retrieve the corresponding FITS files: