title: Need help with my query
body: <p>Sorry for the horrible title, not sure how to explain this. I have a query that looks like this:</p>
  
  <pre><code>SELECT `name`, `latitude`, `longitude`, `indoor`, `address`,
      `phone`, `email`, `website`, `closed`
  FROM rocks INNER JOIN 
      (SELECT DISTINCT id FROM rock_types WHERE type="DWS" or type="Top rope")
      AS types ON rocks.id=types.id
  WHERE (latitude&gt;-180 AND latitude&lt;180) AND (longitude&gt;-180 AND longitude&lt;180)
  </code></pre>
  
  <p>In addition to what I'm getting right now, I'd like to get the list of types associated with each id. How can I do this? Thanks</p>