The Beginner’s Class, ages 2-4, have been learning about China and China’s culture during January. They are celebrating Chinese New Year by sharing their dragon dance with the rest of the school. Practice with the struts and dragon’s body has been going on for several weeks. The class will continue to celebrate Chinese New Year for fourteen days, the traditional length of the spring festival in china, culminating in the lantern festival. These same children will dance the dragon dance for their parents in February.

N. Query Duration, ms Row Count
1 SELECT e.post_id, e.timezone_name, e.recurrence_rules, e.exception_rules, e.allday, e.instant_event, e.recurrence_dates, e.exception_dates, e.venue, e.country, e.address, e.city, e.province, e.postal_code, e.show_map, e.contact_name, e.contact_phone, e.contact_email, e.contact_url, e.cost, e.ticket_url, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.longitude, e.latitude, e.show_coordinates, GROUP_CONCAT( ttc.term_id ) AS categories, GROUP_CONCAT( ttt.term_id ) AS tags , IF( aei.start IS NOT NULL, aei.start, e.start ) as start, IF( aei.start IS NOT NULL, aei.end, e.end ) as end FROM wp_ai1ec_events e LEFT JOIN wp_term_relationships tr ON ( e.post_id = tr.object_id ) LEFT JOIN wp_term_taxonomy ttc ON ( tr.term_taxonomy_id = ttc.term_taxonomy_id AND ttc.taxonomy = 'events_categories' ) LEFT JOIN wp_term_taxonomy ttt ON ( tr.term_taxonomy_id = ttt.term_taxonomy_id AND ttt.taxonomy = 'events_tags' ) LEFT JOIN wp_ai1ec_event_instances aei ON aei.id = 1382 AND e.post_id = aei.post_id WHERE e.post_id = 2082 GROUP BY e.post_id 0.57 1
2 SELECT `term_id`, `term_image`, `term_color` FROM `wp_ai1ec_event_category_meta` 0.13 19
3 SELECT DISTINCT p.*, e.post_id, i.id AS instance_id, i.start AS start, i.end AS end, e.allday AS event_allday, e.recurrence_rules, e.exception_rules, e.ticket_url, e.instant_event, e.recurrence_dates, e.exception_dates, e.venue, e.country, e.address, e.city, e.province, e.postal_code, e.show_map, e.contact_name, e.contact_phone, e.contact_email, e.cost, e.ical_feed_url, e.ical_source_url, e.ical_organizer, e.ical_contact, e.ical_uid, e.timezone_name FROM wp_ai1ec_events e INNER JOIN wp_posts p ON e.post_id = p.ID INNER JOIN wp_ai1ec_event_instances i ON e.post_id = i.post_id LEFT JOIN `wp_term_relationships` AS `term_relationships_events_categories` ON ( `e` . `post_id` = `term_relationships_events_categories` . `object_id` ) LEFT JOIN `wp_term_taxonomy` AS `term_taxonomy_events_categories` ON ( `term_relationships_events_categories` . `term_taxonomy_id` = `term_taxonomy_events_categories` . `term_taxonomy_id` AND `term_taxonomy_events_categories` . taxonomy = 'events_categories' ) LEFT JOIN `wp_term_relationships` AS `term_relationships_events_tags` ON ( `e` . `post_id` = `term_relationships_events_tags` . `object_id` ) LEFT JOIN `wp_term_taxonomy` AS `term_taxonomy_events_tags` ON ( `term_relationships_events_tags` . `term_taxonomy_id` = `term_taxonomy_events_tags` . `term_taxonomy_id` AND `term_taxonomy_events_tags` . taxonomy = 'events_tags' ) WHERE post_type = 'ai1ec_event' AND i.end >= 1409623498 AND post_status = 'publish' ORDER BY i.start ASC, post_title ASC LIMIT 0, 5 7.36 5
Total time, ms: 8.06