title: MySQL one to many data relationship with added complications
body: <p>I have a database in which there are multiple posts. Each post can be associated with one or more location. Each location is then associated with one country.</p>
  
  <p>This is handled through four tables:</p>
  
  <ul>
  <li>post (with the <code>id</code> and <code>post_title</code>)</li>
  <li>postlocation (with the fields <code>post_id</code> and <code>location_id</code> - to allow a one to many relationship)</li>
  <li>location (with the fields <code>id</code>, <code>location_title</code> and <code>country_id</code>)</li>
  <li>country (with the <code>fields</code>, <code>id</code> and <code>country_title</code>)</li>
  </ul>
  
  <p>I want to perform a simple, effective select to retrieve a list of posts and each one's associated locations and each of those locations' country.</p>
  
  <p>I'm at a loss as to how to best achieve this, and any help would be most welcome. Thank you.</p>