Remove "where" clause in views 3
It was a lot easier than I thought. I dsm the query and did it like below. Not sure it's the perfect way to do it but it's working.

function distprox_mini_views_query_alter(&amp;$view, &amp;$query) {
//dsm($query);
  if ($view-&gt;name == 'search' &amp;&amp; $view-&gt;current_display == 'page_3') 
    unset($query-&gt;where[1]['conditions'][0]);
    unset($query-&gt;where[1]['conditions'][1]);
  }
}