Search fixed.

Turns out it was a mysql bug with a left join, just needed to use brackets around it.

Well documented, and a easy fix

Now to test everything else!