Created
September 23, 2010 21:34
-
-
Save bcmiller/594418 to your computer and use it in GitHub Desktop.
prod cal page
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT COUNT(*) FROM (SELECT DISTINCT node.nid AS nid FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid INNER JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_field_date node_data_field_date2 ON node.vid = node_data_field_date2.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 9735 AND na.realm = 'statusbook_friend') OR (na.gid = 9805 AND na.realm = 'statusbook_friend') OR (na.gid = 9835 AND na.realm = 'statusbook_friend') OR (na.gid = 9855 AND na.realm = 'statusbook_friend') OR (na.gid = 9865 AND na.realm = 'statusbook_friend') OR (na.gid = 9895 AND na.realm = 'statusbook_friend') OR (na.gid = 9925 AND na.realm = 'statusbook_friend') OR (na.gid = 9935 AND na.realm = 'statusbook_friend') OR (na.gid = 10005 AND na.realm = 'statusbook_friend') OR (na.gid = 10055 AND na.realm = 'statusbook_friend') OR (na.gid = 10145 AND na.realm = 'statusbook_friend') OR (na.gid = 10175 AND na.realm = 'statusbook_friend') OR (na.gid = 10365 AND na.realm = 'statusbook_friend') OR (na.gid = 10515 AND na.realm = 'statusbook_friend') OR (na.gid = 10545 AND na.realm = 'statusbook_friend') OR (na.gid = 10995 AND na.realm = 'statusbook_friend') OR (na.gid = 11275 AND na.realm = 'statusbook_friend') OR (na.gid = 11395 AND na.realm = 'statusbook_friend') OR (na.gid = 11405 AND na.realm = 'statusbook_friend') OR (na.gid = 11415 AND na.realm = 'statusbook_friend') OR (na.gid = 11445 AND na.realm = 'statusbook_friend') OR (na.gid = 12565 AND na.realm = 'statusbook_friend') OR (na.gid = 12605 AND na.realm = 'statusbook_friend') OR (na.gid = 14915 AND na.realm = 'statusbook_friend') OR (na.gid = 20845 AND na.realm = 'statusbook_friend') OR (na.gid = 32838 AND na.realm = 'statusbook_friend') OR (na.gid = 34068 AND na.realm = 'statusbook_friend') OR (na.gid = 34608 AND na.realm = 'statusbook_friend') OR (na.gid = 36548 AND na.realm = 'statusbook_friend') OR (na.gid = 37608 AND na.realm = 'statusbook_friend') OR (na.gid = 37708 AND na.realm = 'statusbook_friend') OR (na.gid = 38338 AND na.realm = 'statusbook_friend') OR (na.gid = 9825 AND na.realm = 'statusbook_author') OR (na.gid = 0 AND na.realm = 'statusbook_everyone') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 116988 AND na.realm = 'og_admin') OR (na.gid = 118178 AND na.realm = 'og_admin') OR (na.gid = 126428 AND na.realm = 'og_admin') OR (na.gid = 118768 AND na.realm = 'og_admin') OR (na.gid = 122828 AND na.realm = 'og_admin') OR (na.gid = 116518 AND na.realm = 'og_admin') OR (na.gid = 136038 AND na.realm = 'og_admin') OR (na.gid = 132718 AND na.realm = 'og_admin') OR (na.gid = 136018 AND na.realm = 'og_admin') OR (na.gid = 132728 AND na.realm = 'og_admin') OR (na.gid = 135988 AND na.realm = 'og_admin') OR (na.gid = 135998 AND na.realm = 'og_admin') OR (na.gid = 136008 AND na.realm = 'og_admin') OR (na.gid = 136028 AND na.realm = 'og_admin') OR (na.gid = 88308 AND na.realm = 'og_subscriber') OR (na.gid = 117088 AND na.realm = 'og_subscriber') OR (na.gid = 124038 AND na.realm = 'og_subscriber') OR (na.gid = 141168 AND na.realm = 'og_subscriber'))) AND ( ((node.type in ('vevent', 'feed_ical_item')) AND (node.status <> 0) AND (node_og_ancestry.nid in (137938,138018,138008,137998,137988))) AND (((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date2.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date2.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09')) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date2.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date2.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09'))) )) count_alias |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment