title: Mysql multiple join with optional value in ON clause
body: <p>Ok, First see this <a href="http://www.sqlfiddle.com/#!2/bbc3a/2" rel="nofollow">http://www.sqlfiddle.com/#!2/bbc3a/2</a></p>
  
  <p>Here the query return the count and all, but what i want is that it selects a forum and return the count of topics and post in it then next forum and all topics and post counts from it and so on with forums name, url and desc. I thought doing this in one query instead of many queries in loop would be better. I don't know what i am doing with that mysql query though, i am not very good with mysql and i haven't sleep for so long. Thanks for help.</p>
  
  <p>EDIT:</p>
  
  <p>This is what i expect to see from the data provided in te fiddle above^</p>
  
  <pre>
  | FORUMNAME | FORUMURL |    FORUMDESC | FORUMTIME | TOPICCOUNT | POSTCOUNT |
  |   Forum 1 |  Forum-1 | Forum 1 Desc | 343243243 |          1 |         1 |
  |   Forum 2 |  Forum-2 | Forum 2 Desc | 343243243 |          0 |         0 |
  </pre>