Views queries:
----------------

SELECT node.nid AS nid,
   node.type AS node_type,
   node.vid AS node_vid,
   node.title AS node_title,
   node_data_field_location.field_englishtitle_value AS node_data_field_location_field_englishtitle_value,
   location_node_data_field_location.city AS location_node_data_field_location_city,
   node_data_field_date.field_date_value AS node_data_field_date_field_date_value
 FROM node node 
 LEFT JOIN content_type_book node_data_field_location ON node.vid = node_data_field_location.vid
 LEFT JOIN location location_node_data_field_location ON node_data_field_location.field_location_lid = location_node_data_field_location.lid
 INNER JOIN content_type_book node_data_field_mark ON node.vid = node_data_field_mark.vid
 LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid
 WHERE (node_data_field_mark.field_mark_value = 'event')
    AND (DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-14400)), '%Y-%m-%d') > '2009-09-10')
   ORDER BY node_data_field_date_field_date_value ASC
   
   
   
   Other queries:
   --------------
   
   These queries were run during view rendering:
[1.25 ms] pre_render
/* Nirbhasa Magee : pre_render */ SELECT node.vid AS _vid, node_data_field_date.delta as _delta, node.nid AS _nid, node_data_field_date.field_date_value AS value, node_data_field_date.field_date_value2 AS value2, node_data_field_date.field_date_rrule AS rrule FROM content_field_date node_data_field_date LEFT JOIN node node ON node.vid = node_data_field_date.vid WHERE node.vid IN (5166,5214) AND 1 ORDER BY node.nid ASC, node_data_field_date.delta ASC
[0.82 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT src FROM url_alias WHERE dst = 'front' AND language IN('en', '') ORDER BY language DESC
[0.73 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT dst FROM url_alias WHERE src = 'node/3548' AND language IN('en', '') ORDER BY language DESC
[0.62 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT dst FROM url_alias WHERE src = 'node/3555' AND language IN('en', '') ORDER BY language DESC
[0.27 ms] render_textarea
/* Nirbhasa Magee : render_textarea */ SELECT name FROM filter_formats WHERE format = 3
[0.77 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT dst FROM url_alias WHERE src = 'admin/build/views/edit/events_sitewide_listing' AND language IN('en', '') ORDER BY language DESC
[0.48 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT dst FROM url_alias WHERE src = 'admin/build/views/export/events_sitewide_listing' AND language IN('en', '') ORDER BY language DESC
[0.45 ms] drupal_lookup_path
/* Nirbhasa Magee : drupal_lookup_path */ SELECT dst FROM url_alias WHERE src = 'admin/build/views/clone/events_sitewide_listing' AND language IN('en', '') ORDER BY language DESC