title: Custom Forum Query
body: <p>I'm working on a custom made forum and was wondering if I could get some others ideas and opinions on the matter.</p>
  
  <p>I was wondering what would be the most efficient MySQL query to achieve the following.</p>
  
  <ol>
  <li>Find all Categories. These will list their parent forum_id as "0".</li>
  <li>Find all Forums. These will list their parent forum_id as the categories ID.</li>
  <li>Find all Sub-Forums. These will list their parent forum_id as the forums ID.</li>
  <li>Find the total number of Posts for each forum (including their sub-forums).</li>
  <li>Find the total number of Threads for each forum (including their sub-forums).</li>
  <li>Find the last post information (time, thread, poster) for the Forum (including their sub-forums).</li>
  </ol>
  
  <p>Is this possible?</p>