wiki:db/queries/002
Last modified 6 years ago Last modified on 01/31/2013 11:10:56 PM

Select all variable objects of a specific type

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

SELECT *
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.