Last modified 6 years ago Last modified on 01/31/2013 11:13:56 PM

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.