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