SELECT CONCAT( '[*][url=http://themepark.nl/ubb/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