Day 108 / 365 - เรียนคำศัพท์ภาษาอังกฤษ สาธารณะ

SELECT u.*, v.*, c.iconClass, c.name as category, c.clean_name as clean_category,c.description as category_description, v.created as videoCreation, v.modified as videoModified, (SELECT count(id) FROM likes as l where l.videos_id = v.id AND `like` = 1 ) as likes, (SELECT count(id) FROM likes as l where l.videos_id = v.id AND `like` = -1 ) as dislikes FROM videos as v LEFT JOIN categories c ON categories_id = c.id LEFT JOIN users u ON v.users_id = u.id WHERE 1=1 AND (SELECT count(id) FROM videos_group_view as gv WHERE gv.videos_id = v.id ) = 0 AND v.status IN ('a','xmp4','xwebm','xmp3','xogg') ORDER BY v.created desc LIMIT 0, 10 \nError : ()