Apparently when you are using a table prefix you HAVE to declare the tables with a "table AS table" in it for each table (if you are calling more than 1 table in the query) or the table prefix gets confused, I guess. I hadn't been doing that because that is new in vB3 and I don't use a table prefix. Now that I know that (many, many thanks to NTLDR for enlightening me on this), I will start doing that in any future coding I do just so we can avoid all that you have had to go through for me not knowing that.
It wasn't your fault, there were 3 queries doing that in this hack and as soon as we fixed one of them, it stopped at the next one. I should have looked at all of them the first time but, alas, I didn't. Sorry you had to go through all of this for such a small hack.
I'm glad it's finally working for you, my friend. Enjoy! And thanks for the beer. I can sure use it now.
You remembered the install button, right?