SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Couette%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Nature%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%500%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%g%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%m²%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%traitée%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%GREENFIRST%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%100%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%polyester%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%enveloppe%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%coton%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%bio%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%LIVRAISON%" AND id!=777 AND c_18 < 1597329766 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%GRATUITE%" AND id!=777 AND c_18 < 1597329766 ) as results WHERE c_18 < 1597329766 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine