INSERT INTO query_cache(session_id, url_id, weight) SELECT DISTINCT 'm8r0ccppgdaarg8a3fioje9ss5',u.id,1 as weight
FROM lect_url AS u
WHERE (LOCATE('Безп', u.painter )>0)
AND u.is_visible=1 UNION SELECT DISTINCT 'm8r0ccppgdaarg8a3fioje9ss5',u.id,2 as weight
FROM lect_url AS u
WHERE (LOCATE('ятов', u.painter )>0)
AND u.is_visible=1 UNION SELECT DISTINCT 'm8r0ccppgdaarg8a3fioje9ss5',u.id,3 as weight
FROM lect_url AS u
WHERE (LOCATE('Ростислав', u.painter )>0)
AND u.is_visible=1 UNION SELECT DISTINCT 'm8r0ccppgdaarg8a3fioje9ss5',u.id,4 as weight
FROM lect_url AS u
WHERE (LOCATE('Філатов', u.painter )>0)
AND u.is_visible=1 UNION SELECT DISTINCT 'm8r0ccppgdaarg8a3fioje9ss5',u.id,5 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'