SELECT w3t_Users.U_Email, w3t_Users.U_LoginName, w3t_Users.U_Username, COUNT(w3t_Messages.M_Uid) FROM w3t_Messages, w3t_Users GROUP BY w3t_Users.U_Number HAVING COUNT(w3t_Messages.M_uid) > 2
I tried to run this, but my browser seemed to hang. I cancelled the query after 20 minuten (my whole database is only 40mb).
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.