[Lynne]

You need to use a hook that is called right before the query you are trying to modify. Like the hook forumdisplay_announcement_query is right above the announcement query, and forumdisplay_query_threadscount is right above the threascount query. The variables get emptied right before the query hooks:

PHP Code:

$hook_query_fields = $hook_query_joins = $hook_query_where = '';
($hook = vBulletinHook::fetch_hook('forumdisplay_query_threadscount')) ? eval($hook) : false;