jo-snips

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(wp_posts.post_title, ' ', 1), ' ', -1) as memberfirst,
       SUBSTRING_INDEX(SUBSTRING_INDEX(wp_posts.post_title, ' ', 2), ' ', -1) as memberlast,
       wp_postmeta.meta_value
FROM wp_posts, wp_postmeta
WHERE wp_posts.ID = wp_postmeta.post_id 
AND wp_posts.post_type = 'member'
AND wp_posts.post_status = 'publish'
AND wp_postmeta.meta_key = 'email'
AND wp_postmeta.meta_value != '' 
ORDER BY wp_posts.post_date DESC

jo-snips

<?php 

$args = array(
  'post_status'=>'publish',
  'post_type'=>array(TribeEvents::POSTTYPE),
  'posts_per_page'=>10,
  //order by startdate from newest to oldest
  'meta_key'=>'_EventStartDate',
  'orderby'=>'_EventStartDate',
  'order'=>'DESC',

jo-snips

<?php

add_action( 'pre_get_posts', 'exclude_events_category' );
function exclude_events_category( $query ) {
if ( tribe_is_event() && !tribe_is_day() && !is_single() && !is_tax() && !tribe_is_month() ) {
  $query->set( 'tax_query', array(
    array(
      'taxonomy' => TribeEvents::TAXONOMY,
      'field' => 'slug',
      'terms' => array('zoo'),

ryanurban

// Customize Events Community Datepicker
if($("div.tribe-community-events-date input.datepicker").length) {
	var datepickerOpts = { 
		dateFormat: 'yy-mm-dd',
		changeMonth: true,
      		changeYear: true,
		onSelect: function(selectedDate) {
			var option = this.id == "EventStartDate" ? "minDate" : "maxDate";
			var instance = $(this).data("datepicker");
			var date = $.datepicker.parseDate(instance.settings.dateFormat || $.datepicker._defaults.dateFormat, selectedDate, instance.settings);