Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- p.objid,p.ra,p.DEC,
- s.z AS redshift, s.zErr AS redshift_err,
- 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,
- p.err_u,p.err_g,p.err_r,p.err_i,p.err_z,
- sM.logMass, sM.logMass_min, sM.logMass_max,
- sM.ssfr, sM.ssfr_min, sM.ssfr_max
- FROM stellarMassFSPSGranWideDust AS sM
- JOIN SpecObj AS s ON s.specObjID = sM.specObjID
- JOIN PhotoObj AS p ON s.bestobjid = p.objid
- WHERE
- s.class='galaxy'
- AND i BETWEEN -30 AND 22.00753
- AND u BETWEEN -30 AND 100
- AND g BETWEEN -30 AND 100
- AND r BETWEEN -30 AND 100
- AND p.dered_z BETWEEN -30 AND 100
- AND s.z BETWEEN .3 AND .5
- AND sM.z_err<.05
- AND (err_u+err_g+err_r+err_i+err_z)<5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement