RBP rok

SELECT p.naziv,ir.naziv
FROM predmet AS p LEFT JOIN ispit AS i ON(i.id_predmeta=p.id_predmeta)
JOIN ispitni_rok AS ir ON (i.godina=ir.godina AND i.oznaka_roka=ir.oznaka)
WHERE COALESCE(i.datum_pismenog,i.datum_usmenog)=
(SELECT MAX(COALESCE(i2.datum_pismenog,i2.datum_usmenog)) FROM ispit AS i2 WHERE
i2.id_predmeta=p.id_predmeta)
AND i.ocena>5 AND i.status_prijave='o'