Alguien me pude decir si hay errores en este codigo

[GuillermoM]

SELECT
`posts`.`post_id` AS `id`,
`posts`.`post_title` AS `title`,
LEFT(`post`.`post_body`, 512) AS `preview`,
`post`.`post_user` AS `user`,
DATE_FORMAT(`post`.`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

He pasado este codigo miles de veces por le depurador de PHPmyAdmin y simepre me sale errores. Me podrías ayudar.

[gnzsoloyo]

Un error casi imperceptible: Estás usando apóstrofes (') para los nombres de las tablas y alias de tablas, y deben ser acentos inversos (`).

Código MySQL:

SELECT
    `posts`.`post_id` AS `id`,
    `posts`.`post_title` AS `title`,
    LEFT(`post`.`post_body`, 512) AS `preview`,
    `post`.`post_user` AS `user`,
    DATE_FORMAT(`post`.`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;
 

[GuillermoM]

He copiado y pegado el codigo que me facilitas y me sigue dando este error: 1054 - Unknown column 'post.post_body' in 'field list'

[GuillermoM]

perdon, ya esta solucionado no habia declarado bien las tablas. Muchas gracias.