SQL error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '=' - Query was: SELECT p_id, p_namn, p_friendlyname, p_o_id, p_fa, p_com_betyg, p_datum, p_s_id, p_info, p_submiter, p_grad, p_lat, p_lng, o_namn, o_friendlyname, s_namn, s_friendlyname, p_com_grad, com_grades.g_grad as com_grad, fa_grades.g_grad as fa_grad, count(ascents.a_p_id) as ascents FROM problem INNER JOIN grader com_grades ON p_com_grad = com_grades.g_id INNER JOIN grader fa_grades ON p_grad = fa_grades.g_id INNER JOIN crimp_se.omrade ON p_o_id = o_id LEFT OUTER JOIN crimp_se.sektorer ON p_s_id = s_id LEFT OUTER JOIN ascents ON problem.p_id = ascents.a_p_id WHERE p_id IN (SELECT problem_id FROM problem_tag WHERE tag_id = (SELECT id from tag WHERE tag = "fu��ball")) GROUP BY p_id ORDER by `p_namn` ASC