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 '%rock%' AND ) OR (description_original_n...' at line 1
SELECT id, title_original, description_original_nl AS omschrijving, image, tags, playtime, year, partner FROM link WHERE (title_original LIKE '%rock%' AND ) OR (description_original_en LIKE '%rock%' AND ) OR (description_original_nl LIKE '%rock%' AND ) OR id in (SELECT link_id FROM tags_link WHERE tag_id IN (SELECT id FROM tags WHERE tag LIKE '%rock%' AND )) ORDER BY title_original ASC, omschrijving ASC, image ASC LIMIT 0,2000