SELECT `comments`.`id`, `comments`.`id_owner`, `comments`.`controller`, `comments`.`id_controller`, `comments`.`id_parent`, `comments`.`num_hits`, `comments`.`num_replies`, `comments`.`id_last_reply`, `comments`.`date_last_reply`, `comments`.`lang`, `comments`.`id_user`, `comments`.`title`, `comments`.`content`, `comments`.`date`, replies.id_user AS id_user_last_reply, IF ( LENGTH(users.pseudonym) > 0, users.pseudonym, CONCAT(users.fname, " ", users.lname)) AS user_public_name, CONCAT(users.fname, " ", users.lname) AS user_name, SUM(statistics.`count`) AS num_hits FROM comments LEFT JOIN comments AS replies ON ( replies.id_parent = comments.id ) LEFT JOIN users ON ( comments.id_user = users.id ) LEFT JOIN statistics ON ( statistics.controller = "comments" AND statistics.id_controller = comments.id ) WHERE comments.controller = "projects" AND comments.id_controller = 195 AND comments.id_parent = 0 AND comments.lang = "fr" GROUP BY comments.id, comments.id ORDER BY date DESC LIMIT 10