title: MySQL: Taxonomy - Get ID that belongs to multiple categories
body: <p>I was hoping someone could help me come up with a query for what I'm looking to do.
  I have a website that lists game servers and I'm trying to improve my search system a bit.</p>
  <p>There's three tables of interest; servers, version_taxonomy and category_taxonomy. The taxonomy tables contain two columns, one for a server ID and one for a version/category ID, where associations between a server and it's supported versions and categories can be made.</p>
  <p>Up till now, I've been joining both taxonomy tables to the server table and be looking up servers for <strong>one</strong> version and <strong>one</strong> category, it's been working fine. However I'm looking to allow the search of a server that has <strong>multiple</strong> categories at the same time.</p>
  <p>I've made an image to try and illustrate what I'm looking to do:
  <a href="https://i.stack.imgur.com/7jbvu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7jbvu.png" alt="taxonomy tables" /></a></p>
  <p>Say I'm looking for a server that has <strong>both categories 5 and 12</strong> - Based on the table on the left that would be servers 1 and 3. But how would that be in a query? And how would I use that query to later get and work with the rest of the server data (JOIN like I'd normally do?)</p>
  <p>Hopefully that makes sense! Looking forward to your responses.</p>