I got this:
select t2.USER_REAL_EMAIL from ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3 where t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t4.GROUP_ID IN (33) and t4.GROUP_ID IN (33) and t4.GROUP_ID IN (33)GROUP BY t1.USER_ID ORDER BY t1.USER_DISPLAY_NAME ASC
Unknown table 't4' in where clause