get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = '_movie_first_letter'"); // Requête globale pour filtrage Sagas $args = [ 'post_type' => 'movie_v2', 'posts_per_page' => -1, 's' => $sel_search, 'tax_query' => ['relation' => 'AND', ['taxonomy' => 'mv2_statut', 'field' => 'slug', 'terms' => ['liste-denvie', 'vendu'], 'operator' => 'NOT IN']], 'meta_query' => ['relation' => 'AND'] ]; if($sel_let !== 'ALL') $args['meta_query'][] = ['key' => '_movie_first_letter', 'value' => $sel_let]; if($sel_fmt !== 'all') $args['meta_query'][] = ['key' => '_movie_format', 'value' => $sel_fmt]; if($sel_stu !== 'all') $args['tax_query'][] = ['taxonomy' => 'studio', 'field' => 'name', 'terms' => $sel_stu]; if($sel_gen !== 'all') $args['meta_query'][] = ['key' => '_movie_data', 'value' => $sel_gen, 'compare' => 'LIKE']; $query_all = new WP_Query($args); $filtered_ids = []; $sagas_vu = []; while($query_all->have_posts()){ $query_all->the_post(); $mid = get_the_ID(); $sagas = get_the_terms($mid, 'movie_saga'); if ($sagas && !is_wp_error($sagas)) { $sid = $sagas[0]->term_id; if (in_array($sid, $sagas_vu)) continue; $sagas_vu[] = $sid; } $filtered_ids[] = $mid; } wp_reset_postdata(); $per_page = 24; $total_pages = ceil(count($filtered_ids) / $per_page); $current_items = array_slice($filtered_ids, ($paged - 1) * $per_page, $per_page); ob_start(); ?>
TOUT '.$n.''; ?>
'.$l.''; ?>
add_query_arg('v_page','%#%'), 'current'=>$paged, 'total'=>$total_pages, 'prev_text' => '«', 'next_text' => '»']); ?>