// get counts for tour
      // $result = db_query("SELECT COUNT(*) AS count FROM {node} JOIN {term_node} ON node.vid = term_node.vid WHERE node.type='date'AND status = 1  AND term_node.tid = 25 AND node.changed > %d", $newtime);
      $result = db_query("SELECT COUNT(*) AS count FROM {node} n JOIN {term_node} tn ON n.vid = tn.vid JOIN {content_type_date} ctd on n.vid = ctd.vid WHERE n.type='date' AND n.status = 1 AND tn.tid = 25 AND ctd.field_date_value > now() AND n.changed > %d", $newtime);