SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Canapé%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%club%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%2%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%places%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%vintage%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%microfibre%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%aspect%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%cuir%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%vieilli%" AND id!=26745 AND c_18 < 1597331992 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Jazzy%" AND id!=26745 AND c_18 < 1597331992 ) as results WHERE c_18 < 1597331992 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine