SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Commode%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%TEXAS%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%12%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%tiroirs%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%palissandre%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%massif%" AND id!=28866 AND c_18 < 1597332625 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%naturel%" AND id!=28866 AND c_18 < 1597332625 ) as results WHERE c_18 < 1597332625 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine