get_results("SELECT post_id, meta_value FROM $wpdb->postmeta pm JOIN $wpdb->posts p ON p.ID=pm.post_id WHERE pm.meta_key='_movie_data' AND p.post_type='movie_v2'");
$total_p=0;$count_4k=0;$total_c=count($raw_s); $all_genres=[]; foreach($raw_s as $m){
$fmt=get_post_meta($m->post_id,'_movie_format',true); $px=get_post_meta($m->post_id,'_movie_prix',true); if($fmt=='4K')$count_4k++; if($px)$total_p+=floatval($px);
$d=maybe_unserialize($m->meta_value); if(!is_array($d))$d=json_decode($m->meta_value,true); if(!empty($d['genres'])){foreach($d['genres'] as $g){$all_genres[$g['name']]=$g['name'];}}
}
ksort($all_genres); $studios=get_terms(['taxonomy'=>'studio','hide_empty'=>true]); $active_l=$wpdb->get_col("SELECT DISTINCT meta_value FROM $wpdb->postmeta pm JOIN $wpdb->posts p ON p.ID=pm.post_id WHERE pm.meta_key='_movie_first_letter' AND p.post_type='movie_v2' ORDER BY meta_value ASC");
$args=['post_type'=>'movie_v2','posts_per_page'=>$is_rand?1:24,'paged'=>$paged,'meta_key'=>'_movie_sort_title','orderby'=>$is_rand?'rand':'meta_value','order'=>'ASC','s'=>$sel_search,'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_gen!=='all')$args['meta_query'][]=['key'=>'_movie_data','value'=>$sel_gen,'compare'=>'LIKE'];
if($sel_stu!=='all')$args['tax_query']=[['taxonomy'=>'studio','field'=>'name','terms'=>$sel_stu]];
if($is_rand)$args['meta_query'][]=[['key'=>'_movie_vu','value'=>'VU','compare'=>'!=']];
$q=new WP_Query($args); ob_start(); ?>
FILMS: 4K: VALEUR: €
$n],remove_query_arg(['v_search','random','v_page']))."' title='Films commençant par $n' class='".($sel_let==$n?'active':'')."'>$n":"$n"; } ?>
TOUT$l],remove_query_arg(['v_search','random','v_page']))."' title='Films commençant par $l' class='".($sel_let==$l?'active':'')."'>$l":"$l"; } ?>