Express Complex Sub-Select With Dynamic Query

[Olaseni Oluwunmi, modificado 10 Anos atrás.]

How would you replicate this SQL ( Sub-select ) with an equivalent DynamicQuery expression within a ServiceImpl Class:

SELECT * FROM journalarticle
WHERE (urlTitle,version) IN
( SELECT 
	urlTitle,MAX(version) 
FROM journalarticle 
WHERE structureId = 'structure-id' AND companyId = 10150 AND groupId = 10170
GROUP BY urlTitle ) 
ORDER BY createDate DESC 
LIMIT 0,4