Query: SELECT DISTINCT `songComment`.`id`, `name`, `singer`,
IFNULL(CONCAT(`title`, ' ', `songComment`.`type`), `songComment`.`type`) AS `description`,
`songComment`.`star` AS `score`, DATEDIFF(CURDATE(), `songComment`.`mtime`) AS `mdatediff`,
DATEDIFF(CURDATE(), `songComment`.`ctime`) AS `cdatediff` FROM `songComment` LEFT JOIN `animeComment`
ON `animeComment`.`id` = `anime_id` WHERE `songComment`.`type` <> 'BGM' ORDER BY `score` DESC
Took 0.030340909957886 seconds
Found 1394 Entries