For a specified unique SDSS specObjID, return spectroscopic redshift and type information, as well as some basic photometry.
In the WHERE block below, provide a 18-digit unique specObjID anywhere after the final equals-sign ('=').
Otherwise, modify as needed. Hitting Reset will restore the default SQL query.
SELECT dbo.fIAUFromEq(p.ra,p.[dec]) as SDSSname, p.objID, p.specObjID, str(p.ra,11,6) as ra, str(p.[dec],11,6) as dec, str(s.z,7,5) as zspec, str(s.zErr,7,5) as e_zspec, s.class, s.subClass, str(p.u,7,3) as u, str(p.Err_u,6,3) as e_u, str(p.g,7,3) as g, str(p.Err_g,6,3) as e_g, str(p.r,7,3) as r, str(p.Err_r,6,3) as e_r, str(p.i,7,3) as i, str(p.Err_i,6,3) as e_i, str(p.z,7,3) as z, str(p.Err_z,6,3) as e_z FROM PhotoObj as p, SpecObj as s WHERE ( p.specObjID = s.specObjID ) AND s.specObjID =
Only check SQL syntax?           Data format: CSV    HTML

The query results will be written to a file name "result*.csv".