select destinaions.* ,countries.countries_id , countries_name from destinaions join dest_countries on destinaions.Id=dest_countries.Destination join countries on countries.countries_id=dest_countries.IdCountry where Name= 'Egypt's Western Desert Oasis' and destinaions.Active=0
Mysql Error Number 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 's Western Desert Oasis' and destinaions.Active=0' at line 1