Pandey20

SELECT
  s.z, s.ra, s.DEC,
  p.petroMag_r AS pMag_r, p.extinction_r, p2.KcorrR, em.ebmv,
  (p.petroMag_u - p.petroMag_r) - (p.extinction_u - p.extinction_r) AS ur_color,
  (p.petroMag_g - p.petroMag_r) - (p.extinction_g - p.extinction_r) AS gr_color,
  sm.logMass AS lmass, sm.ssfr
FROM
  specobj AS s
  JOIN photoobj AS p ON s.specobjID = p.specobjID
  JOIN photoz AS p2 ON p.objID = p2.objID
  JOIN stellarMassFSPSGranWideDust AS sm ON s.specobjID = sm.specobjID
  JOIN emissionLinesPort AS em ON s.specobjID = em.specobjID
WHERE
  s.class = 'galaxy'
  AND s.zwarning = 0
  AND s.z BETWEEN 0 AND 0.3
  AND s.ra BETWEEN 125 AND 235
  AND s.DEC BETWEEN 0 AND 60
  AND sm.ssfr != -9999
  AND sm.logMass != -9999