This definitely won't be used any more than absolutely necessary. Up to this point I haven't used any JOINS at all and will continue to use them sparingly. The only reason they are used now is Simon Wolf came up with away of actually sorting the JUMP boxes properly, and using the JOINS was really the only way.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.