INSERT INTO query_cache(session_id, url_id, weight)    SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,1 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Юрченко', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,2 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Тетяна', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,3 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Ільницький', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,4 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Євген', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,5 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Абесінова', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,6 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Олена', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,7 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Басс', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,8 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Олександр', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,9 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Кожем', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,10 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('€™якіна', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,11 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Ірина', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,12 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Бариба', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,13 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Віктор', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,14 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Ширяєв', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,15 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Владислав', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,16 as weight
                                  FROM lect_url AS u
                                  WHERE (LOCATE('Сахалтуєв', u.painter )>0)
                                    AND u.is_visible=1   UNION SELECT DISTINCT '2peviurrrgkp5k2dvmadacsep4',u.id,17 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'

Читанка