wiki:db/queries/015
Last modified 7 years ago Last modified on 02/01/2013 06:17:36 AM

Select transient variable objects near a known galaxy

SELECT v.objectId, v.ra, v.decl
FROM   Object v, Object o
WHERE  o.objectId = :objectId
   AND spDist(v.ra, v.decl, o.ra, o.decl, :dist)
   AND v.variability > 0.8
   AND o.extendedParameter > 0.8