SELECT SQL_CALC_FOUND_ROWS COUNT(results.c_1) as count, results.* FROM ( SELECT * FROM p_1 WHERE c_1 LIKE "%Puzzle%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Willem%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Janszoon%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Blaeu%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Carte%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%l%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%Ame%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%rique%" AND id!=16190 AND c_18 < 1597327280 UNION ALL SELECT * FROM p_1 WHERE c_1 LIKE "%1645%" AND id!=16190 AND c_18 < 1597327280 ) as results WHERE c_18 < 1597327280 GROUP BY results.id ORDER BY count DESC LIMIT 6
Got error 28 from storage engine