You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR (description_original_en LIKE '%illegale%' AND description_original_en ...' at line 1
SELECT id, title_original, description_original_nl AS omschrijving, image, tags, playtime, year, partner FROM link WHERE (title_original LIKE '%illegale%' AND title_original LIKE '%dvd%' AND ) OR (description_original_en LIKE '%illegale%' AND description_original_en LIKE '%dvd%' AND ) OR (description_original_nl LIKE '%illegale%' AND description_original_nl LIKE '%dvd%' AND ) OR id in (SELECT link_id FROM tags_link WHERE tag_id IN (SELECT id FROM tags WHERE tag LIKE '%illegale%' AND tag LIKE '%dvd%' AND )) ORDER BY title_original ASC, omschrijving ASC, image ASC LIMIT 0,2000