New search tables question

[Boofo]

I am trying to update an old hack and this is the query that always worked in vb 3, but they don't use a single search table anymore in vb 4. There are four different search-type tables now. Can anyone please give me a clue as to what the vb 4 version of this query would be?

$lastsearches = $db->query_read("
	SELECT search.*
		, user.username
	FROM " . TABLE_PREFIX . "search AS search
	LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
	WHERE search.query != ''
	AND orderedids != ''
	AND personal <> 1
	ORDER BY search.searchid DESC
	LIMIT 0, 15
");