MySQL Error: Expression #37 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rodpub_beta.packages.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Statement: SELECT contents.*, packages.title as packagesTitle, GROUP_CONCAT(asset_packages.resource_properties_remaining separator '##|##') AS resource_properties_remaining FROM contents JOIN asset_packages on asset_packages.resource_id = join packages on asset_packages.package_id = WHERE IN (select content_taxonomy.content_id from content_taxonomy where taxonomy_id=23223) and contents.publish_date <= '2022-02-27 12:00:00' and contents.published=1 and contents.magazine_id=9 and asset_packages.published = 1 and asset_packages.resource = contents.resource_id and asset_packages.expire_at>= '2022-02-27 12:00:00' group by ORDER BY contents.title ASC 日本人的色道