[eluser]dmorin[/eluser]
My post wasn't supposed to show queries that I would use in a blog but to instead show how to write queries for the different tables and relationships that were created.
If you can't figure out the right queries, write back and let us know what type of page you're trying to create and we'll help by writing out the queries we would use. In general , I wouldn't recommend getting posts and comments in the same query since it would return the post data once for each comment (because of the join) which could result in a lot of extra data being transferred. Instead, I would get the post in one query, all of the categories in a second (using a join) and all of the comments in a third.