SELECT 
  DISTINCT T10.*, 
  T20.* 
FROM 
  Files T10 
  INNER JOIN (
    SELECT 
      T0.*, 
      (
        T0.k_red + T0.k_green + T0.k_blue + T0.k_grey + T0.k_color
      ) AS k_sum 
    from (
        SELECT 
          ID_Files, 
          sum(k_red) as k_red, 
          sum(k_green) as k_green, 
          sum(k_blue) as k_blue, 
          sum(k_grey) as k_grey, 
          sum(k_color) as k_color
        FROM 
          (
            SELECT 
              ID_Files, 
              compare_key_9(Key_red, "1e43f4333") as k_red, 
              0 as k_green, 
              0 as k_blue, 
              0 as k_grey, 
              0 as k_color 
            FROM 
              Files_CRC 
            UNION ALL 
            SELECT 
              ID_Files, 
              0 as k_red, 
              compare_key_9(Key_green, "5543f4335") as k_green, 
              0 as k_blue, 
              0 as k_grey, 
              0 as k_color
            FROM 
              Files_CRC 
            UNION ALL 
            SELECT 
              ID_Files, 
              0 as k_red, 
              0 as k_green, 
              compare_key_9(Key_blue, "bbb3f4337") as k_blue, 
              0 as k_grey, 
              0 as k_color
            FROM 
              Files_CRC 
            UNION ALL 
            SELECT 
              ID_Files, 
              0 as k_red, 
              0 as k_green, 
              0 as k_blue, 
              compare_key_9(Key_grey, "1777f4333") as k_grey, 
              0 as k_color
            FROM 
              Files_CRC 
            UNION ALL 
            SELECT 
              ID_Files, 
              0 as k_red, 
              0 as k_green, 
              0 as k_blue, 
              0 as k_grey, 
              compare_key_9(Key_color, "1e4399933") as k_color 
             FROM 
               Files_CRC
           ) AS T
               
        GROUP BY ID_Files ) T0 
        WHERE 
          (
            LEAST(
              T0.k_red, T0.k_green, T0.k_blue, T0.k_grey, 
              T0.k_color
            ) > 70 
            AND GREATEST(
              T0.k_red, T0.k_green, T0.k_blue, T0.k_grey, 
              T0.k_color
            ) > 90
          ) 
          OR GREATEST(
            T0.k_red, T0.k_green, T0.k_blue, T0.k_grey, 
            T0.k_color
          ) > 97
      ) T20 ON T10.ID = T20.ID_Files 
    ORDER BY 
      T20.k_sum DESC 
    LIMIT 
      0, 10
     

            SELECT 
              ID_Files, 
              compare_key_9(Key_red, "1e43f4333") as k_red, 
              0 as k_green, 
              0 as k_blue, 
              0 as k_grey, 
              0 as k_color 
            FROM 
              Files_CRC 
 

BEGIN
DECLARE R INT DEFAULT 0;
DECLARE i INT DEFAULT 1;
DECLARE a INT;
DECLARE L INT;
SET L = LENGTH(key1);
WHILE i<=L DO
	Set a = ABS(ORD(SUBSTRING(key1, i, 1))-ORD(SUBSTRING(key2, i, 1)));
	IF a>10 THEN Set R = R + 100; ELSE Set R = R + a * a; END IF;    
	SET i=i+1;
END WHILE;
Set R = 100 - R / L;
RETURN (R);
END