At 5am I found the solution. The solution (as always) was simpler than I had expected. I spent a few hours reading up on SQL SELECT's and found that I just needed to be more specific with the query so as to avoid anonymous data problems impeding properly filtering the results. For future reference, here's my new query. [quote] SELECT `phpbb_user_group`.`group_id`, `phpbb_user_group`.`user_id`, `phpbb_users`.`user_id`, `phpbb_users`.`username` FROM `phpbb_user_group` , `phpbb_users` WHERE '107' = `phpbb_user_group`.`group_id` AND `phpbb_users`.`user_id` = `phpbb_user_group`.`user_id` ORDER BY `phpbb_users`.`user_id` ASC [/quote] Night guys.