SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Lofter%" AND id!=31314 AND c_18 < 1594458290 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Armoire%" AND id!=31314 AND c_18 < 1594458290 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%2%" AND id!=31314 AND c_18 < 1594458290 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%portes%" AND id!=31314 AND c_18 < 1594458290 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%m├ętal%" AND id!=31314 AND c_18 < 1594458290 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%gris%" AND id!=31314 AND c_18 < 1594458290 ) as results WHERE c_18 < 1594458290 GROUP BY results.id ORDER BY count DESC LIMIT 6
Incorrect key file for table '/tmp/#sql_65e4_2.MYI'; try to repair it