SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Jouet%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%chien%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%corde%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%1%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%balle%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Corde%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Coton%" AND id!=23170 AND c_18 < 1597331298 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Zootopia%" AND id!=23170 AND c_18 < 1597331298 ) as results WHERE c_18 < 1597331298 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine