SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Chesterfield%" AND id!=26233 AND c_18 < 1597329240 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%origine%" AND id!=26233 AND c_18 < 1597329240 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Brighton%" AND id!=26233 AND c_18 < 1597329240 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Antique%" AND id!=26233 AND c_18 < 1597329240 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%vert3%" AND id!=26233 AND c_18 < 1597329240 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%ges%" AND id!=26233 AND c_18 < 1597329240 ) as results WHERE c_18 < 1597329240 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine