It's too bad that ON (column = column) comes after and not before INNER JOIN table, because if it came before it would make for much cuter code formatting:
SQL:
-
SELECT DISTINCT $columns
-
FROM
-
$this->comments
-
ON (comment_post_ID = post_id) INNER JOIN
-
$this->post2cat
-
ON (category_id = cat_ID) INNER JOIN
-
$this->categories
-
WHERE
-
blog = '$blog' AND
-
$criteria
