Ok, looks like everything is now under control. That was seriously a bitch!

I got the webhost to get the 'djinfotemp' table dropped and was able to restore a slightly older version of it from a backup.

Then I was able to get the DJ search working again. This was really weird though because it was saying that columns didn't exist, but would access them fine in other queries. I just changed the query so that instead of using more efficient left joins, they're just joined with standard joins.

It works for now.