UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support SQL Query to Display Users with Right Column Displayed

This should do it:

SELECT * FROM ubbt_USER_PROFILE WHERE USER_HIDE_RIGHT_COLUMN = "1"

You'll need to adjust the table prefix to match your own.

Actually, that shows you every profile with the right column turned off, are you wanting to count the number or view the profile?