Cannot make query substitutions
I think this is a similar situation to a question I asked a little while ago.

I solved it by using hook_views_query_alter() to remove the fields I didn't need in the query.   In your case, it would probably look like:

function MYMOODULE_views_query_alter(&amp;$view, &amp;$query) {
  if ($view-&gt;name == 'MY_VIEW') {
    unset($query-&gt;fields['nid']);
  }
}


dpm() the $query to see what array keys are in $query-&gt;fields if that doesn't work.