Skip to content

Instantly share code, notes, and snippets.

@Zae

Zae/relatedpostsbytag.sql

Created September 26, 2011 20:29
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 Zae/1243313 to your computer and use it in GitHub Desktop.
Save Zae/1243313 to your computer and use it in GitHub Desktop.
Download ZIP
Related Posts By Tag
Raw
relatedpostsbytag.sql
SELECT posts.* FROM posts
JOIN post_tag A ON A.pid = posts.pid
JOIN post_tag B ON B.tid = A.tid AND B.pid = ?
WHERE
posts.pid != ?
GROUP BY pid
ORDER BY COUNT(*) DESC
LIMIT 0,5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment