jfburdet
01/13/2020, 2:37 PMSELECT p.id, p.title
FROM Publication p
JOIN (
SELECT psc.publicationId, psc.publicationStateId ,max(psc.id)
FROM PublicationStateChange psc
GROUP BY psc.publicationId
) lastpsc ON p.id = lastpsc.publicationId and lastpsc.publicationStateId = ps.id
JOIN PublicationState ps ON ps.id = lastpsc.publicationStateId
WHERE ps.tag = "new"
;
tapac
01/13/2020, 10:41 PMtapac
01/13/2020, 10:42 PMjfburdet
01/14/2020, 10:13 AMjfburdet
01/14/2020, 12:47 PM