SELECT objects.diaObjectId,
       objects.g_psfFluxMax,
       objects.r_psfFluxMax,
       objects.i_psfFluxMax,
       objects.z_psfFluxMax,
       objects.lastDiaSourceMjdTai,
       objects.nSourcesGood AS "latest detection",
       sherlock_classifications.classification AS "predicted classification"
FROM objects,
     sherlock_classifications,
     area_hits
WHERE objects.diaObjectId=sherlock_classifications.diaObjectId
  AND objects.diaObjectId=area_hits.diaObjectId
  AND area_hits.ar_id=6
  AND objects.nSourcesGood > 4
  AND sherlock_classifications.separationArcsec > 0.5
  AND sherlock_classifications.separationArcsec < 5.0
  AND ((objects.ngSources > 2
        AND objects.nrSources > 2)
       OR (objects.nrSources > 2
           AND objects.niSources > 2)
       OR (objects.niSources > 2
           AND objects.nzSources > 2))
  AND (objects.g_psfFluxMax > 0
       OR objects.r_psfFluxMax > 0
       OR objects.i_psfFluxMax > 0
       OR objects.z_psfFluxMax > 0)
  AND (objects.lastDiaSourceMjdTai - objects.firstDiaSourceMjdTai) > 2
  AND objects.medianR > 0.75