INSERT INTO query_cache(session_id, url_id, weight)    SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,1 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Карлов', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,2 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Георгій', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,3 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Самум', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,4 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Маркін', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,5 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('С', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,6 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Григор', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,7 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('��єва', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT 'qgsnuq8l7k2uofgluu3ndq0885',u.id,8 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Любов', u.painter )>0)
                                    AND u.is_visible=1  
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'locate'