Sounds as if you need to redesign it. If you want something that´s unique but just isn´t then there was a slip up in the db design. I guess casinos should be your primary key as they would always be unique. The good thing though is that with some sweat you should be able to rework your backend in a way that it returns queries that will run with front end as it is at the moment.
I.e. you won´t have to redesign your urls to match your query strings etcetera etcetera.