Making views table filters take precedence over sort criteria

gistfile1.php

<?php
/**
 * Implements hook_views_query_alter().
 * 
 * By default, views will make sort criteria take precedence over views table sorts when
 * "Override normal sorting if click sorting is used" is unticked. This is not ideal when
 * you want the user initiated sorting to be secondary sorted on another column.
 */
function hook_views_query_alter(&$view, &$query) {
  // Reverse the query order. Note if you have more than one sort criteria,
  // that will be reversed as well.
  if ($view->name == 'my_view') {
    $query->orderby = array_reverse($query->orderby);
  }
}