ERROR: Unable to execute query
SELECT tag_video.*,tags.*,videos.*, users.user_id, users.user_name FROM tag_video, tags, videos, users
    WHERE tags.tag='marjorie' AND tags.id=tag_video.tag_id AND  tag_video.vid=videos.video_id AND
    videos.video_user_id=users.user_id AND videos.video_type='public' AND videos.video_approve='1' AND videos.video_active='1'
    GROUP BY tag_video.vid
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vshare27_nsfwall.tag_video.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by