SELECT R_Rating, R_Rater, U_Username, U_Totalposts, R_What FROM _forum_Ratings, _forum_Users WHERE R_Rater = U_Number AND R_Type = 'u' AND U_Totalposts < 50 ORDER BY U_Totalposts, R_Rater ASC
I get a list of Users who have less than 50 posts and have done a rating on somebedy.
I also get the name of the user who rated but I don't know how to get the name of the user who WAS rated (R_What is user ID).
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.