SELECT objects.diaObjectId,
       objects.lastDiaSourceMjdTai,
       objects.latestR,
       objects.nDiaSources,
       objects.ra,
       objects.decl,
       sherlock_classifications.separationArcsec
FROM objects,
     sherlock_classifications
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.nDiaSources >= 2
  AND sherlock_classifications.classification IN ("SN")
  AND objects.latestR > 0.9
  AND objects.latest_psfFlux > 5754
ORDER BY objects.lastDiaSourceMjdTai DESC