SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Banc%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%coffre%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%jardin%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%acacia%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%90x38x43cm%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%147L%" AND id!=27530 AND c_18 < 1597332954 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%PORTOFINO%" AND id!=27530 AND c_18 < 1597332954 ) as results WHERE c_18 < 1597332954 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine