SELECT objects.diaObjectId,
       r0b_lvra.classification AS r0b_score,
       objects.lastDiaSourceMjdTai AS latest_MJD,
       objects.timestamp AS Alert_arrival_time,
       objects.latestR,
       objects.nDiaSources,
       objects.ebv,
       objects.ra,
       objects.decl,
       objects.tns_name,
       objects.firstDiaSourceMjdTai,
       objects.r_psfFluxMax AS r_flux_max,
       objects.r_psfFluxMin AS r_flux_min,
       sherlock_classifications.separationArcsec,
       sherlock_classifications.direct_distance,
       sherlock_classifications.distance,
       sherlock_classifications.z,
       sherlock_classifications.photoZ,
       sherlock_classifications.photoZErr,
       sherlock_classifications.physical_separation_kpc,
       sherlock_classifications.classification AS sherlock_classifications,
       r0b_lvra.timestamp AS VRAtimestamp
FROM objects,
     sherlock_classifications,
     annotations AS r0b_lvra
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=r0b_lvra.diaObjectId
  AND r0b_lvra.topic="r0b_lvra"
  AND objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=r0b_lvra.diaObjectId
  AND r0b_lvra.topic="r0b_lvra"
  AND objects.nDiaSources > 2
  AND r0b_lvra.classification>0.9
  AND mjdnow() - objects.lastDiaSourceMjdTai < 7
  AND (sherlock_classifications.classification ="NT"
       OR (sherlock_classifications.classification ="SN"
           AND sherlock_classifications.separationArcsec <0.5))
  AND (objects.lastDiaSourceMjdTai - objects.firstDiaSourceMjdTai)>30
ORDER BY objects.lastDiaSourceMjdTai DESC