SELECT video_comments text video_comments created_at video_comments vi

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
SELECT
`video_comments`.text,
`video_comments`.created_at,
`video_comments`.video_id,
`videos`.name as `video_name`,
`users`.login as `user_name`
FROM `video_comments`
LEFT JOIN `videos` ON `videos`.id = `video_comments`.`video_id`
LEFT JOIN `users` ON `users`.id = `video_comments`.`user_id`
ORDER BY `video_comments`.`id` DESC LIMIT 5