SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Alimentation%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%tortues%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%aquatiques%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%croissance%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%212%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%grs%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Turtle%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Food%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Growth%" AND id!=23408 AND c_18 < 1597332850 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Zoo%" AND id!=23408 AND c_18 < 1597332850 ) as results WHERE c_18 < 1597332850 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine