informatique:wordpress:wp_mysql_inner_join
Ceci est une ancienne révision du document !
array ( 'post_type' => 'caf37_event', 'post_status' => 'publish', 'posts_per_page' => 10, 'orderby' => 'date', 'order' => 'ASC', 'meta_query' => array ( 'relation' => 'AND', 0 => array ( 'key' => 'geo_city', 'value' => 'Tours', 'compare' => 'LIKE', ), 1 => array ( 'relation' => 'OR', 0 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_0_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_0_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 1 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_1_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_1_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 2 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_2_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_2_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 3 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_3_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_3_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 4 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_4_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_4_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 5 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_5_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_5_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 6 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_6_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_6_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 7 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_7_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_7_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 8 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_8_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_8_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), 9 => array ( 'relation' => 'AND', 0 => array ( 'key' => 'dates_9_date_start', 'value' => '2020-10-04 00:00:00', 'compare' => '<=', ), 1 => array ( 'key' => 'dates_9_date_end', 'value' => '2020-10-03 00:00:00', 'compare' => '>=', ), ), ), ), )
informatique/wordpress/wp_mysql_inner_join.1601391232.txt.gz · Dernière modification : 29/09/2020 16:53 de cyrille