Database error: Invalid SQL: SELECT itunes, video, releaseDate, devices, name.value trackName, url.value trackUrl, artistName, catname, strdev FROM mgc_videos LEFT JOIN mgc_apps ON mgc_videos.itunes = mgc_apps.id LEFT JOIN mgc_apps_char name ON mgc_apps.id = name.id AND name.item='1' LEFT JOIN mgc_apps_char url ON mgc_apps.id = url.id AND url.item='2' LEFT JOIN mgc_apps_artist ON mgc_apps.artistId = mgc_apps_artist.artist LEFT JOIN mgc_apps_categories ON mgc_apps.category_id = mgc_apps_categories.cat LEFT JOIN mgc_devices ON mgc_apps.id = mgc_devices.str WHERE listed = '1' GROUP BY mgc_videos.video ORDER BY mgc_apps.releaseDate DESC limit 8
MySQL Error: 1055 (Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'appwereld.mgc_videos.itunes' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)
Session halted.