Skip to content

Instantly share code, notes, and snippets.

@perlDreamer
Created August 18, 2010 18:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save perlDreamer/535651 to your computer and use it in GitHub Desktop.
Save perlDreamer/535651 to your computer and use it in GitHub Desktop.
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