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 'BRADY%' AND `firstname` like '%BRIAN%' ) order by `position` asc' at line 1

SQL:
select * from `webberz_results` where `rid`='1075' and ( `id`<>'' AND `surname` like '%O'BRADY%' AND `firstname` like '%BRIAN%' ) order by `position` asc