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

Find new transients for given epoch

SELECT objectId 
FROM   Alert 
JOIN   _Alert2Type USING (alertId) 
JOIN   AlertType USING (alertTypeId)
WHERE  alertTypeDescr = 'newTransients'
  AND  Alert.timeGenerated BETWEEN :timeMin AND :timeMax