In the FROM block below, substitute values for RA (degrees), Dec (degrees), search radius RADIUS (arcmin), Redshift_min and Redshift_max.
The cone search "dbo.fGetNearbyObjEq(RA,Dec,RADIUS)" may be replaced with a rectangular area search "dbo.fGetObjFromRectEq(RA1,Dec1,RA2,Dec2)".
Otherwise, modify as needed. Hitting Reset will restore the default SQL query.

Note, that as of DR8 the isophotal parameters isoA_*, isoB_*, and isoPhi_* have been dropped from CAS. Reconstruct
alternative size, shape, and orientation measures based on, e.g., petroRad_*, expAB_*, and expPhi_*, instead.

SELECT TOP 100 dbo.fIAUFromEq(p.ra,p.[dec]) as SDSSname, 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, p.type, str(p.petroRad_r,6,2) as rp_r, str(p.petroRadErr_r,6,2) as e_rp_r, str(p.expAB_r,6,4) as ba_r, str(p.expABErr_r,6,4) as e_ba_r, str(p.expPhi_r,6,1) as PA_r, 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, str(p.extinction_u,6,3) as Ag_u, str(p.extinction_g,6,3) as Ag_g, str(p.extinction_r,6,3) as Ag_r, str(p.extinction_i,6,3) as Ag_i, str(p.extinction_z,6,3) as Ag_z, p.run, p.rerun, p.camcol, p.field, p.obj, p.objID, p.specObjID FROM dbo.fGetNearbyObjEq( RA,Dec,RADIUS ) as b, PhotoObj as p, SpecObj as s WHERE ( p.specObjID = s.specObjID AND b.objID = p.objID ) AND ( s.z > Redshift_min AND s.z <= Redshift_max ) AND p.type IN (0,3) AND p.dered_r < 22 AND ( flags & dbo.fPhotoFlags('BINNED1') ) > 0 AND ( p.Err_g <= 0.3 OR p.Err_r <= 0.3 OR p.Err_i <= 0.3 ) AND p.g BETWEEN 10 AND 27 AND p.r BETWEEN 9 AND 27 AND p.i BETWEEN 9 AND 27
Only check SQL syntax?           Data format: CSV    HTML