wiki:db/queries/032

Version 4 (modified by jbecla, 12 years ago) (diff)

changed notation (input parameters)

Find all galaxies brighter than magnitude ? where the local extinction is > ?

Common Queries

SELECT objectId
FROM   Object
JOIN   _Object2Type USING (objectId)
JOIN   ObjectType USING (typeId)
WHERE  ObjectType.description = "galaxy"
  AND  rMag < :rMagMax
  AND  extinction_r > :extinctionMin

Query volume: high.

This query originally came from SDSS (S-3)