this is incompatible with sql_mode=only_full_group_by