Removed the RAND section all together for now and it's sped up the search by about half which is good but still a bit slow.

Not been able to use JOIN yet - should that see a speed increase?