In the FROM block below, substitute RA,Dec,RADIUS with the RA and Dec (both in degrees), and search radius (in arcmin).
Otherwise, modify as needed (see the DR12 schema browser for the available views and columns to select from).
In particular, omit the "TOP 100" after verifying that the query results are sensible. The cone search
"dbo.fGetNearbyObjEq(RA,Dec,RADIUS)" may be replaced with a rectangular area search "dbo.fGetObjFromRectEq(RA1,Dec1,RA2,Dec2)".

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(p.l,11,6) as lII, str(p.[b],11,6) as bII, p.type, p.clean, 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, str(p.fiberMag_u,7,3) as u3f, str(p.fiberMagErr_u,6,3) as e_u3f, str(p.fiberMag_g,7,3) as g3f, str(p.fiberMagErr_g,6,3) as e_g3f, str(p.fiberMag_r,7,3) as r3f, str(p.fiberMagErr_r,6,3) as e_r3f, str(p.fiberMag_i,7,3) as i3f, str(p.fiberMagErr_i,6,3) as e_i3f, str(p.fiberMag_z,7,3) as z3f, str(p.fiberMagErr_z,6,3) as e_z3f, p.run, p.rerun, p.camcol, p.field, p.obj, p.objID, p.specObjID FROM PhotoObj p JOIN dbo.fGetNearbyObjEq(RA,Dec,RADIUS) r ON p.objID = r.objID WHERE p.type IN (0,3) AND ((flags_r & 0x10000000) != 0) AND ((flags_r & 0x8100000c00a0) = 0) AND (((flags_r & 0x100000000000) = 0) OR (flags_r & 0x1000) = 0) AND (p.Err_g <= 0.3 OR p.Err_r <= 0.3 OR p.Err_i <= 0.3) AND p.g BETWEEN 9 AND 27 AND p.r BETWEEN 9 AND 27 AND p.i BETWEEN 9 AND 27
Only check SQL syntax?           Data format: CSV    HTML