custom sql query for views

chinh sua sql trong drupal
http://drupal.org/node/409808
dai loai la thuc hien nhu sau:
b1: vao mysqladmin tao query va chay no
b2: them mot function vao cuoi file view.module co dinh dang kieu nhu sau:
function views_views_pre_execute(&$view) {
drupal_set_message($view->name);
if($view->name=="groups_list2") {
// drupal_set_message($this->build_info['query'][1]);
// drupal_set_message($view->build_info['query_args'][0]);
// drupal_set_message($view->build_info['query_args'][1]);
if($view->build_info['query_args'][1]==0) { // is the current choice, so, show everything
$view->build_info['query']="SELECT node.nid AS nid FROM node WHERE node.type='%s'";
} else {
$view->build_info['query']="SELECT node.nid AS nid, node.title AS title, term_data.tid AS tid, term_data.name AS name FROM node,term_node,term_data,term_data term_data2 WHERE node.type='%s' AND term_data2.tid=%d AND term_data2.name = term_data.name AND term_node.tid in (term_data.tid) AND term_node.nid = node.nid ORDER BY tid, node.title";
}
}
}

b3: chinh sua phan "groups_list2" thanh dung voi ten view va copy sql thay vao sql ben tren
b4: save lai. nhu vay la xong