INSERT INTO `search_tmp_5a5de009b26075_57197513`
SELECT `main_select`.`entity_id`,
       MAX(score) AS `relevance`
FROM (
    SELECT
        `search_index`.`entity_id`,
        (((0) + (0)) * 1 + SUM((
            CASE WHEN `data_index` LIKE ' vt keramieke vervangschijf voor rvs diffusor aqv7757 '
                 THEN 5
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% vt %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% keramieke %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% vervangschijf %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% voor %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% rvs %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% diffusor %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '% aqv7757 %'
                 THEN 3
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '%vt%'
                 THEN 2
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '%keramieke%'
                 THEN 2
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '%vervangschijf%'
                 THEN 2
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '%voor%'
                 THEN 2
                 ELSE 0
            END
            +
            CASE WHEN `data_index` LIKE '%rvs%'
                 THEN 2
                 ELSE 0
            END
            +
            CASE WHEN `data_inde[...]