Alter view query output

Using the hook_views_query_alter(&$view, &$query)  you can alter the query output from the views.
Put a print_r for $query & make the necessary changes to the $query array to alter the query
Use $view to get what the view name is