gistfile1.php

<?php

function my_module_views_query_alter(&$view, &$query) {
  if ($view->name == 'faculty') {    
    // Traverse through the 'where' part of the query.
    foreach ($query->where as &$condition_group) {
      foreach ($condition_group['conditions'] as &$condition) {
        if (is_object($condition['field'])) {
          $conditions = &$condition['field']->conditions();
          dpm($conditions[1]['field']->conditions());
        }
      }
    }
  }