select * from hip_riads where riadurl = 'tangiers-hotels' or lower(replace(name,' ','-')) = 'tangiers-hotels' or replace(lower(name),'riad ','') = 'tangiers-hotels' and active > 0