select L.*,ifnull(D.loc_code,'') as dcode from bg_loc L left outer join bg_loc_direct D on D.loc_code=L.loc_code where L.loc_city ='1 Rue Paul Colonna D'istria' and L.region_code='FR0' order by L.region_name

1064 : 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 'istria' and L.region_code='FR0' order by L.region_name' at line 1

error file : /index.php