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 fanatvideo_history AS vh
LEFT JOIN fanatvideo AS v ON (v.video_id = vh.video_id AND v.status = 1)
LEFT JOIN fanatuser AS u ON (u.user_id = v.user_id)
WHERE vh.user_id = 20
ORDER BY vh.view_time DESC
LIMIT 8
Error Message: Expression #1 of ORDER BY clause is not in SELECT list, references column 'adult.vh.view_time' which is not in SELECT list; this is incompatible with DISTINCT
Error Number: 3065