1.
SQL Query
SELECT u.USER_ID, u.USER_DISPLAY_NAME 
FROM ubbt_USERS u, 
ubbt_USER_PROFILE up 
WHERE up.USER_ID=u.USER_ID 
AND up.USER_STYLE=2

.. assumes ubbthreads dark is 2 (you can replace as needed)

2.
SQL Query
SELECT u.USER_ID, u.USER_DISPLAY_NAME 
FROM ubbt_USERS u, 
ubbt_USER_PROFILE up 
WHERE up.USER_ID=u.USER_ID 
AND up.USER_SHOW_LEFT_MYSTUFF=1

3. also an easy way to check on style popularity is

SQL Query
SELECT 
CONCAT('[*][url=http://yoursite.com/ubbthreads/ubbthreads.php?ubb=previewskin&skin=',t2.STYLE_ID ,']',STYLE_NAME,'[/url]') AS Style, 
CONCAT('[color:red](',COUNT(t2.STYLE_NAME),')[/color]') as Count 
FROM ubbt_STYLES as t2, 
ubbt_USER_PROFILE as t1 
WHERE t1.USER_STYLE=t2.STYLE_ID 
GROUP BY t2.STYLE_ID 
ORDER BY t2.STYLE_NAME

replace 'yoursite.com/ubbthreads/' with the real path to your site..

the concat crapola just makes it easy to copy/paste the resulting recordset between a [list] ... tag for display in a post

smile