wiki:db/queries/047
Last modified 6 years ago Last modified on 02/01/2013 12:23:18 AM

Select all variable objects within certain distance of all known galaxies

This query was suggested by the LSST Science Collaboration (Supernovae)

SELECT v.objectId
FROM   Object g, Object v
WHERE  g.extendedParam > 0.8 -- is galaxy
  AND  v.variability > 0.8   -- is variable
  AND  spDist(g.ra, g.decl, v.ra, v.decl) < :distance