Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
WHERE
asset.parentId = ?
AND Post.threadId = Post.assetId
AND assetData.status = "approved"
GROUP BY assetId
HAVING MAX(Post.revisionDate)
ORDER BY Post.revisionDate DESC
LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.