wiki:db/queries/015

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

rewritten

Select transient variable objects near a known galaxy

Common Queries

SELECT v.objectId, v.ra, v.decl
FROM   Object v, Object o
WHERE  spDist(v.ra, v.decl, o.ra, o.decl, :raDist)
   AND o.objectId = :objectId
   AND getClassif_variable(v.classification)
   AND getClassif_galaxy(o.classification)