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

SQL:
select * from `webberz_results` where `rid`='711' and ( `id`<>'' AND `surname` like '%D'ABADIE%' AND `firstname` like '%ROGER%' ) order by `position` asc