wiki:db/queries/007
Last modified 6 years ago Last modified on 02/01/2013 06:13:56 AM

Select time series data for all objects in a given area of the sky, in a given photometric band with a given variability index

SELECT objectId, taiMidPoint, fluxToAbMag(psfMag)
FROM   Source
JOIN   Object USING(objectId)
JOIN   Filter USING(filterId)
WHERE  areaSpec_box(:raMin, :declMin, :raMax, :declMax)
  AND  filterName = 'u'
  AND  variability BETWEEN :varMin AND :varMax
ORDER BY objectId, taiMidPoint ASC

Note: we don't have variability in the schema yet, but it would be in Object, not Source.