Extra Views Handlers

Extra fields & filter handlers for Views module.

View Type:

1. Node Type

Global Fields:

1. Custom query (add_field, add_relationship, add_where, alter GROUP BY)

Node Revision Fields:

1. Promoted to front page(promote)
2. Published(status)

Node Revision Filters:

1. Promoted to front page(promote)
2. Published(status)

Node Revision Bulk Actions: http://drupal.org/project/views_bulk_operations

1. Published(status)

Query Alter, Where condition supports following dynamic values:

1. ***CURRENT_TIME***
2. ***CURRENT_LANGUAGE***
3. ***DEFAULT_LANGUAGE***
4. ***CURRENT_USER***
5. URL Arguments: arg() ***CURRENT_ARG_0*** ***CURRENT_ARG_1*** ***CURRENT_ARG_2*** .......

TODO:
Operator: "Contains any phrase" https://drupal.org/node/1117538
Field: Global custom text area with user role access restriction

Alter query using "Global: Query Alter". Handler Source Code
FROM

SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created
FROM 
{node} node
LEFT JOIN {og_membership} og_membership_node ON node.nid = og_membership_node.gid AND og_membership_node.group_type = 'node'
LEFT JOIN {node} node_og_membership ON og_membership_node.etid = node_og_membership.nid AND og_membership_node.entity_type = 'node'
WHERE (( (node.status = '1') AND (node.type IN  ('forum_discussion')) )AND( (og_membership_node.entity_type LIKE 'node' ESCAPE '\\') OR (og_membership_node.entity_type IS NULL ) ))
ORDER BY node_created DESC
LIMIT 20 OFFSET 0

TO

SELECT node.nid AS nid, node.title AS node_title, node_og_membership__node_comment_statistics.comment_count AS node_og_membership__node_comment_statistics_comment_count, node.created AS node_created
FROM 
{node} node
LEFT JOIN {og_membership} og_membership_node ON node.nid = og_membership_node.gid AND og_membership_node.group_type = 'node'
LEFT JOIN {node} node_og_membership ON og_membership_node.etid = node_og_membership.nid AND og_membership_node.entity_type = 'node'
INNER JOIN {node_comment_statistics} node_og_membership__node_comment_statistics ON (node_og_membership.nid) = node_og_membership__node_comment_statistics.nid
WHERE (( (node.status = '1') AND (node.type IN  ('forum_discussion')) )AND( (og_membership_node.entity_type LIKE 'node' ESCAPE '\\') OR (og_membership_node.entity_type IS NULL ) ))
ORDER BY node_created DESC
LIMIT 20 OFFSET 0

also Look at http://drupal.org/project/views_raw_sql