Hi Group, I've just moved hosts and sadly they're running MySQL 4.1.22 and a query running on my previous host (MySQL 5.0.45) has stopped working...
I've got a nice nested query (see http://www.milk-hub.net/pb/08 ) that gets related content based on tags; the outer query collates the uri (like an ID) and tags to get the best 5 matches. Can anyone suggest a way of running this on the new server, preferably all in one query. I could out source the outer query to PHP but the SQL here is much cleaner and returns only the results I need. Cheers, Phill
