SELECT objects.diaObjectId,
       objects.ra,
       objects.decl,
       objects.latest_psfFlux,
       objects.absMag,
       objects.ebv,
       objects.lastDiaSourceMjdTai,
       objects.firstDiaSourceMjdTai,
       sherlock_classifications.classification
FROM objects,
     sherlock_classifications
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND sherlock_classifications.classification IN ("SN",
                                                  "CV",
                                                  "UNCLEAR")
  AND objects.decl BETWEEN -10.0 AND 90.0
  AND objects.latest_psfFlux > 145000
  AND objects.ebv < 0.1
  AND mjdnow() - objects.lastDiaSourceMjdTai < 7
  AND objects.lastDiaSourceMjdTai - objects.firstDiaSourceMjdTai > 1
ORDER BY objects.latest_psfFlux DESC