UBB.threads PHP Forum Software Community Forums Thread Like Summary - CP Saved member searches error 7.7.3

Script: /home/sundan21/public_html/forum/admin/membersearch.php
Line: 331
SQL Error: Unknown column 't4.GROUP_ID' in 'where clause'
SQL Error: 1054

Query:
select COUNT(t1.USER_ID)
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 (1) GROUP BY t1.USER_ID,
t1.USER_LOGIN_NAME,
t1.USER_MEMBERSHIP_LEVEL,
t1.USER_DISPLAY_NAME,
t2.USER_REAL_EMAIL,
t2.USER_TOTAL_POSTS,
t1.USER_REGISTRATION_IP,
t1.USER_IS_BANNED,
t1.USER_IS_UNDERAGE,
t2.USER_BIRTHDAY,
t1.USER_REGISTERED_ON,
t3.USER_LAST_POST_TIME,
t3.USER_LAST_IP,
t3.USER_LAST_VISIT_TIME,
t3.USER_LAST_POST
ORDER BY t1.USER_ID ASC

		$extra .= " and t4.GROUP_ID IN ($g_inlist) ";
		$group = ",{$config['TABLE_PREFIX']}USER_GROUPS as t4";
		$groups = "and t1.USER_ID = t4.USER_ID";

		$extra .= "AND t4.GROUP_ID IN ($g_inlist) AND t1.USER_ID = t4.USER_ID";

	{$config['TABLE_PREFIX']}USER_DATA as t3
	$group

	{$config['TABLE_PREFIX']}USER_DATA AS t3,
	{$config['TABLE_PREFIX']}USER_GROUPS AS t4

	$groups
	$removedlist
	$nomods
	$extra

AND	t1.USER_ID = t4.USER_ID
	$removedlist
	$nomods
	$extra