[Boofo]

Can someone please tell me how to make the following query only allow searches show up for forums the user who is searching has access to? Right now it shows the word they searched for, and when they click on the word, if they do NOT have access to that forum, it shows the error message that there weren't any instances of the word found, even though it still shows in the list. Is there any way not to even have the word listed for those who can not view the forum?

PHP Code:

 $lastsearches = $db->query_read("  
 SELECT search.searchid, search.orderedids, search.dateline, search.query, search.userid, user.username, user.userid, user.usergroupid  
 FROM " . TABLE_PREFIX . "search,  
 " . TABLE_PREFIX . "user  
 WHERE search.query != ''  
 AND user.userid = search.userid  
 AND user.usergroupid NOT IN (5, 6, 7)  
 ORDER BY search.searchid DESC 
 LIMIT 0, 15 
");