SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Environnement%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%lit%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%160%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%cm%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%COCOON%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%coloris%" AND id!=1566 AND c_18 < 1597330780 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%blanc%" AND id!=1566 AND c_18 < 1597330780 ) as results WHERE c_18 < 1597330780 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine