Advertisement
wkblack

Pandey20

Apr 4th, 2024
739
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | Science | 0 0
  1. SELECT
  2.   s.z, s.ra, s.DEC,
  3.   p.petroMag_r AS pMag_r, p.extinction_r, p2.KcorrR, em.ebmv,
  4.   (p.petroMag_u - p.petroMag_r) - (p.extinction_u - p.extinction_r) AS ur_color,
  5.   (p.petroMag_g - p.petroMag_r) - (p.extinction_g - p.extinction_r) AS gr_color,
  6.   sm.logMass AS lmass, sm.ssfr
  7. FROM
  8.   specobj AS s
  9.   JOIN photoobj AS p ON s.specobjID = p.specobjID
  10.   JOIN photoz AS p2 ON p.objID = p2.objID
  11.   JOIN stellarMassFSPSGranWideDust AS sm ON s.specobjID = sm.specobjID
  12.   JOIN emissionLinesPort AS em ON s.specobjID = em.specobjID
  13. WHERE
  14.   s.class = 'galaxy'
  15.   AND s.zwarning = 0
  16.   AND s.z BETWEEN 0 AND 0.3
  17.   AND s.ra BETWEEN 125 AND 235
  18.   AND s.DEC BETWEEN 0 AND 60
  19.   AND sm.ssfr != -9999
  20.   AND sm.logMass != -9999
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement