How do I overwrite SQL generated by a View?
There are several reasons to overwrite an SQL query generated by a view whether it's to improve performance or join to tables not available to the view. After setting up the view, create a module with a function using hook_views_pre_execute. function [module name]_views_pre_execute(&$view) { if($view->name=="[view name]")...