Skip to content

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #35 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nova_db.vcs.sort_order' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byselect * from videos v LEFT JOIN videos_category_sort vcs on v.video_id = vcs.video_id where v.status = 'Active' AND v.photo_file IS NULL and (concat(',',v.tag_id,',') like '%,1,%' or v.tag_id = '1') AND vcs.tag_id = '1' group by v.video_id order by vcs.sort_order ASC limit 25