MYSQL语法错误

Question

Every time I try to run this MYSQL statement in phpMyAdmin I get this sytax error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'comments,last_comment, '%d/%m/%Y %H:%i:%s') ASlast_comment FROMposts' at line 7

Code:

"SELECT
                `posts`.`post_id` AS `id`,
                `posts`.`post_title` AS `title`,
                LEFT(`posts`.`post_body`, 512) AS `preview`,
                `posts`.`post_user` AS `user`,
                DATE_FORMAT(`posts`.`post_date`,'%d/%m/%Y %H:%i:%s') AS `date`,
                `comments`.`total_comments`,
                DATE_FORMAT(`comments`.`last_comment`, '%d/%m/%Y %H:%i:%s') AS `last_comment`
            FROM `posts`
            LEFT JOIN (
            SELECT
                `post_id`,
                COUNT(`comment_id`) AS `total_comments`,
                MAX(`comment_date`) AS `last_comment`
            FROM `comments`
            GROUP BY `post_id`  
            ) AS `comments`
            ON `posts`.`post_id` = `comments`.`post_id`
            ORDER BY `posts`.`post_date` DESC";

Also, all of the tables are named correctly. So, that can be ruled out.

UPDATE:

Awesome, thanks. I added the quote on comments and the extra perimeter was meant to be a period not a comma.

Answer 1

DATE_FORMAT() accepts two parameters, not three. See the manual.

I suppose, you meant

`comments`.`total_comments`

instead?