If you go to group management and click on the number where it shows how many people are in that group you get this message
select COUNT(t1.USER_ID) from ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6) and t4.GROUP_ID IN (6)GROUP BY t1.USER_ID ORDER BY t2.USER_DISPLAY_NAME ASC
Unknown column 't2.USER_DISPLAY_NAME' in 'order clause'
