title: How does Wordpress link posts to categories in its database?
body: <p>At present I am displaying a list of the last 5 posts in a site's blog in its footer using this mysql query:</p>
  
  <pre><code>SELECT post_title, guid, post_date FROM wp_posts WHERE post_type = 'post' AND post_status = 'Publish' ORDER BY post_date DESC LIMIT 5
  </code></pre>
  
  <p>How can I edit this query to restrict the search to a particular category id? I thought it would be as simple as looking for a category field in the posts table but it isn't!</p>