Advertisement
wkblack_um

SDSS z|(.3,.5) sSFR selection

Dec 9th, 2021
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.70 KB | None | 0 0
  1. SELECT
  2.    p.objid,p.ra,p.DEC,
  3.    s.z AS redshift, s.zErr AS redshift_err,
  4.    p.dered_u AS u,p.dered_g AS g,p.dered_r AS r,p.dered_i AS i,p.dered_z AS z,
  5.    p.err_u,p.err_g,p.err_r,p.err_i,p.err_z,
  6.    sM.logMass, sM.logMass_min, sM.logMass_max,
  7.    sM.ssfr, sM.ssfr_min, sM.ssfr_max
  8. FROM stellarMassFSPSGranWideDust AS sM
  9.    JOIN SpecObj AS s ON s.specObjID = sM.specObjID
  10.    JOIN PhotoObj AS p ON s.bestobjid = p.objid
  11. WHERE
  12.    s.class='galaxy'
  13.    AND i BETWEEN -30 AND 22.00753
  14.    AND u BETWEEN -30 AND 100
  15.    AND g BETWEEN -30 AND 100
  16.    AND r BETWEEN -30 AND 100
  17.    AND p.dered_z BETWEEN -30 AND 100
  18.    AND s.z BETWEEN .3 AND .5
  19.    AND sM.z_err<.05
  20.    AND (err_u+err_g+err_r+err_i+err_z)<5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement