Query: SELECT DISTINCT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb, v.thumbs, v.add_time, v.total_views, v.ext, u.username, v.likes, v.hd FROM video_history AS vh LEFT JOIN video AS v ON (v.video_id = vh.video_id AND v.status = 1) LEFT JOIN user AS u ON (u.user_id = v.user_id) WHERE vh.user_id = 159 ORDER BY vh.view_time DESC LIMIT 8
Error Message: Expression #1 of ORDER BY clause is not in SELECT list, references column 'joivideo_AVSP.vh.view_time' which is not in SELECT list; this is incompatible with DISTINCT
Error Number: 3065