Michael adjusted the query to display it a bit different. From what you want above this is not it. You want to link the lastpost from the list and this needs a complete rewrite not a query adjustment.
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.
