function hook_views_query_alter(&$view, &$query) {

  if ($view->name == 'my_view_name') {

      //print_r($query);
      if (!isset($query->where[1]['conditions'][0] ))
      {
           $query->where[1]['conditions'][0] = array(
                                'field' => 'guarantee.vin',
                                'value' => 'X',
                                'operator' =>'LIKE'
                            );
      }
  }
}