<?php
// Build a custom query to get posts from future dates.
$querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta

    LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
    LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
    LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)

WHERE $wpdb->terms.name = 'TDU'
    AND $wpdb->term_taxonomy.taxonomy = 'category'
    AND $wpdb->posts.post_status = 'publish'
    AND $wpdb->posts.post_type = 'post'
    AND $wpdb->postmeta.meta_key = 'order'
    AND $wpdb->posts.ID = wpostmeta.post_id
    AND $wpdb->postmeta.meta_key = 'Date'

AND STR_TO_DATE(wpostmeta.meta_value,'%m/%d/%Y <span class=\"hide\">%H:%i</span>') >= CURDATE()


ORDER BY STR_TO_DATE(wpostmeta.meta_value,'%m/%d/%Y <span class=\"hide\">%H:%i</span>') ASC
LIMIT 200
";

$events = $wpdb->get_results($querystr, OBJECT);

 if ($events):
    foreach ($events as $post):
        global $post;
        setup_postdata($post); ?>