Advertisement
wkblack_um

SDSS z=.1 sSFR selection

Oct 27th, 2021 (edited)
491
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.55 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 0 AND 18.13
  14.    AND s.z BETWEEN .095 AND .105
  15.    AND (err_u+err_g+err_r+err_i+err_z)<.3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement