In the FROM block below, substitute values for RA (degrees), Dec (degrees), search radius RADIUS (arcmin), Redshift_min and Redshift_max.
Otherwise, modify as needed. Hitting Reset will restore the default SQL query.
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, p.objID, p.specObjID, str(s.z,7,5) as zspec, str(s.zErr,7,5) as e_zspec, str(100*s.zConf,5,2) as P_z_spec, s.specClass as S, str(p.isoA_r,6,2) as dmaj, str(p.isoB_r,6,2) as dmin, str(p.isoPhi_r,6,1) as PA, p.type, 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 FROM dbo.fGetNearbyObjEq( RA,Dec,RADIUS ) as b, BESTDR6..PhotoObj as p, BESTDR6..SpecObj as s WHERE ( p.specObjID = s.specObjID AND b.objID = p.objID ) AND ( s.z > Redshift_min AND s.z <= Redshift_max ) AND ( s.specClass = 2 ) AND p.dered_r < 22 AND ( flags & dbo.fPhotoFlags('BINNED1') ) > 0 AND p.u > 10 AND p.u < 27 AND p.g > 10 AND p.g < 27 AND p.r > 10 AND p.r < 27 AND p.i > 10 AND p.i < 27 AND p.z > 10 AND p.z < 27
Only check SQL syntax?           Data format: CSV    HTML