Last modified 6 years ago Last modified on 02/01/2013 06:10:56 AM

Select all variable objects of a specific type

For example, select all Supernova, elliptical galaxies, eclipsing binaries, etc.

FROM   Object
JOIN   _ObjectToType USING(objectId)
JOIN   ObjectType USING (typeId)
WHERE  description = 'Supernova'
  AND  variability > 0.8
  AND  probability > 0.8

Note, we will not have objects classified in DC3b beyond star/galaxy, so this query will not work.