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