如何查询重复项？

I have a query that targets several tables. I've discovered that I have a lot of duplicate pages I need to be fixed. For example, the URL mysite/africa won't display because there are half a dozen instances of 'africa' in my database tables. It's a little hard to track all the dupes down, because I have thousands of rows of data in several database tables.I have a query that targets several tables. I'v