demo2 sql hanging

SELECT DISTINCT node.nid AS nid, node.title AS node_title, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2, node_data_field_date.field_date_rrule AS node_data_field_date_field_date_rrule, node_data_field_date.delta AS node_data_field_date_delta, node.type AS node_type, node.vid AS node_vid, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid 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 = 1818 AND na.realm = 'statusbook_friend') OR (na.gid = 2328 AND na.realm = 'statusbook_friend') OR (na.gid = 2308 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 = 61918 AND na.realm = 'og_admin') OR (na.gid = 69808 AND na.realm = 'og_admin') OR (na.gid = 61938 AND na.realm = 'og_admin') OR (na.gid = 13418 AND na.realm = 'og_admin') OR (na.gid = 62198 AND na.realm = 'og_admin') OR (na.gid = 62208 AND na.realm = 'og_admin') OR (na.gid = 18668 AND na.realm = 'og_admin') OR (na.gid = 60778 AND na.realm = 'og_admin') OR (na.gid = 60808 AND na.realm = 'og_admin') OR (na.gid = 60818 AND na.realm = 'og_admin') OR (na.gid = 62168 AND na.realm = 'og_admin') OR (na.gid = 66998 AND na.realm = 'og_admin') OR (na.gid = 69818 AND na.realm = 'og_admin') OR (na.gid = 62038 AND na.realm = 'og_admin') OR (na.gid = 60828 AND na.realm = 'og_admin') OR (na.gid = 60838 AND na.realm = 'og_admin') OR (na.gid = 60848 AND na.realm = 'og_admin') OR (na.gid = 60868 AND na.realm = 'og_admin') OR (na.gid = 61968 AND na.realm = 'og_admin') OR (na.gid = 69798 AND na.realm = 'og_admin') OR (na.gid = 60878 AND na.realm = 'og_admin') OR (na.gid = 60928 AND na.realm = 'og_admin') OR (na.gid = 60938 AND na.realm = 'og_admin') OR (na.gid = 62218 AND na.realm = 'og_admin') OR (na.gid = 60948 AND na.realm = 'og_admin') OR (na.gid = 60958 AND na.realm = 'og_admin') OR (na.gid = 60968 AND na.realm = 'og_admin') OR (na.gid = 60978 AND na.realm = 'og_admin') OR (na.gid = 60988 AND na.realm = 'og_admin') OR (na.gid = 60998 AND na.realm = 'og_admin') OR (na.gid = 61008 AND na.realm = 'og_admin') OR (na.gid = 61018 AND na.realm = 'og_admin') OR (na.gid = 62158 AND na.realm = 'og_admin') OR (na.gid = 61028 AND na.realm = 'og_admin') OR (na.gid = 62028 AND na.realm = 'og_admin') OR (na.gid = 62178 AND na.realm = 'og_admin') OR (na.gid = 61978 AND na.realm = 'og_admin') OR (na.gid = 61988 AND na.realm = 'og_admin') OR (na.gid = 61038 AND na.realm = 'og_admin') OR (na.gid = 67008 AND na.realm = 'og_admin') OR (na.gid = 62008 AND na.realm = 'og_admin') OR (na.gid = 18418 AND na.realm = 'og_admin') OR (na.gid = 69828 AND na.realm = 'og_admin') OR (na.gid = 62188 AND na.realm = 'og_admin') OR (na.gid = 68638 AND na.realm = 'og_admin') OR (na.gid = 61058 AND na.realm = 'og_admin') OR (na.gid = 61068 AND na.realm = 'og_admin') OR (na.gid = 60788 AND na.realm = 'og_admin') OR (na.gid = 60688 AND na.realm = 'og_admin') OR (na.gid = 60658 AND na.realm = 'og_admin') OR (na.gid = 60628 AND na.realm = 'og_admin') OR (na.gid = 60908 AND na.realm = 'og_admin') OR (na.gid = 60638 AND na.realm = 'og_admin') OR (na.gid = 60478 AND na.realm = 'og_admin') OR (na.gid = 60698 AND na.realm = 'og_admin') OR (na.gid = 60578 AND na.realm = 'og_admin') OR (na.gid = 61048 AND na.realm = 'og_subscriber'))) AND ( ((node.type in ('vevent', 'feed_ical_item')) AND (node.status <> 0) AND (og_ancestry.group_nid = 60478)) 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'))) ) LIMIT 0, 200

-- paused. press any key to resume or (e) to explain --
MySQL on localhost (5.1.37-1ubuntu5.1-log)              up 0+00:01:33 [15:10:39]
 Queries: 73.0    qps:    1 Slow:     0.0         Se/In/Up/De(%):    763/00/00/00
              qps now:    0 Slow qps: 0.0  Threads:    1 (   1/   4) 11650/00/00/00
 Key Efficiency: 99.7%  Bps in/out:  16.9/ 4.7k   Now in/out:   1.7/636.3

        Id      User         Host/IP         DB      Time    Cmd Query or State 
        --      ----         -------         --      ----    --- -------------- 
      1250      root       localhost                    0  Query show full proce