What a truly bizarre query. Joining to the same (presumably long but lean) table 3 times on the same varchar column using 3 different aliases is an awful lot of work. The poor index on the lotro_game_ready_for_web.wc_na me column must be getting the **** beat out of it!

I have a new respect for the Lorebook developers now, because the database you're given to work with looks like a real mine field!