选择开始日期小于当前日期、结束日期大于当前日期的事件

选择开始日期小于当前日期且结束日期大于当前日期的事件

假设事件的开始日期为2013年6月12日，结束日期为2013年7月30日。我有一个查询，其中开始日期是2013-06-20，结束日期是2013-06-30。因此，事件A应该显示在我的查询结果中。但我不明白。这是我的问题

$query = "
SELECT DISTINCT ID
FROM {$wpdb->prefix}posts
JOIN {$wpdb->prefix}postmeta m1
ON ( {$wpdb->prefix}posts.ID = m1.post_id )
WHERE
{$wpdb->prefix}posts.post_type = \'tribe_events\'

AND {$wpdb->prefix}posts.post_status = \'publish\'

AND (

    ( (m1.meta_key = \'_EventStartDate\' AND m1.meta_value >= \'$start_date\') AND ( m1.meta_key = \'_EventStartDate\' AND m1.meta_value <= \'$end_date\' ))

    OR 
    ( (m1.meta_key = \'_EventEndDate\' AND m1.meta_value >= \'$start_date\') AND ( m1.meta_key = \'_EventEndDate\' AND m1.meta_value <= \'$end_date\' ) )

    OR
    ( (m1.meta_key = \'_EventStartDate\' AND m1.meta_value < \'$start_date\') AND ( m1.meta_key = \'_EventEndDate\' AND m1.meta_value > \'$end_date\') )

    )

ORDER BY {$wpdb->prefix}posts.post_date
DESC;
";

$result = $wpdb->get_results($query);

提前谢谢。

$query = " SELECT DISTINCT * FROM {$wpdb->posts} INNER JOIN {$wpdb->postmeta} m1 ON ( {$wpdb->posts}.ID = m1.post_id ) INNER JOIN {$wpdb->postmeta} m2 ON ( {$wpdb->posts}.ID = m2.post_id ) WHERE {$wpdb->posts}.post_type = \'tribe_events\' AND {$wpdb->posts}.post_status = \'publish\' AND ( ( ( m1.meta_key = \'_EventStartDate\' AND CAST( m1.meta_value AS DATE ) >= %s ) AND ( m2.meta_key = \'_EventStartDate\' AND CAST( m2.meta_value AS DATE ) <= %s )) OR ( ( m1.meta_key = \'_EventEndDate\' AND CAST( m1.meta_value AS DATE ) >= %s ) AND ( m2.meta_key = \'_EventEndDate\' AND CAST( m2.meta_value AS DATE ) <= %s ) ) OR ( ( m1.meta_key = \'_EventStartDate\' AND CAST( m1.meta_value AS DATE ) < %s ) AND ( m2.meta_key = \'_EventEndDate\' AND CAST( m2.meta_value AS DATE ) > %s ) ) ) ORDER BY {$wpdb->posts}.post_date DESC;"; $query = $wpdb->prepare( $query, $start_date, $end_date, $start_date, $end_date, $start_date, $end_date ); $result = $wpdb->get_results( $query );

小码农CODE

相关推荐

Only Showing Upcoming Events