I have the following SQL query:
db_query("SELECT content_id, COUNT(*) as count FROM {votingapi_vote}
WHERE value_type = '%s' AND value = 1
GROUP BY content_id;", "option");
If I want to override the view, which code should I put in mymodule_views_query_alter()
?
The content of $query
is the following:
views_query Object( [table_queue] => Array( [node] => Array( [alias] => node [table] => node [relationship] => node [join] => ) ) [tables] => Array( [node] => Array( [node] => Array( [count] => 1 [alias] => node ) ) ) [relationships] => Array( [node] => Array( [link] => [table] => node [alias] => node [base] => node ) ) [where] => Array( [0] => Array( [clauses] => Array( [0] => node.status 0 [1] => node.type in ('%s') ) [args] => Array( [0] => provider ) [type] => AND ) ) [having] => Array() [group_operator] => AND [orderby] => Array( [0] => node_created DESC ) [groupby] => Array() [header] => Array() [distinct] => [base_table] => node [base_field] => nid [fields] => Array( [nid] => Array( [table] => node [field] => nid [alias] => nid ) [node_title] => Array( [field] => title [table] => node [alias] => node_title ) [node_created] => Array( [field] => created [table] => node [alias] => node_created ) [content_id_] => Array( [field] => [table] => content_id [alias] => content_id_ ) ) [count_field] => Array( [table] => node [field] => nid [alias] => nid [count] => 1 ) )