SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Coffre%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%rangement%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%design%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Made%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%com%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%coffre%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%rectangulaire%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%tapissé%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%gris%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%feutrine%" AND id!=28610 AND c_18 < 1597327160 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Capri%" AND id!=28610 AND c_18 < 1597327160 ) as results WHERE c_18 < 1597327160 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine