Debug slider Università

Università trovate: 0

Termini categoria: economista=5, universita_l2=15, corsi/seminari=27,28, legacy=9241,9242,9250,9251

Strategia: distinct_sql_formazione

Pipeline: università visibili HP=1 (fallback tutte), DISTINCT con post=0, con logo=0, tempo=12ms

SQL DISTINCT:

        SELECT DISTINCT universita_id
        FROM (
            SELECT CAST(pm_legacy.meta_value AS UNSIGNED) AS universita_id
            FROM mm_posts p
            INNER JOIN mm_postmeta pm_legacy
                ON p.ID = pm_legacy.post_id
                AND pm_legacy.meta_key = 'universita_di_riferimento'
             INNER JOIN mm_icl_translations mmn_wpml ON mmn_wpml.element_id = p.ID AND mmn_wpml.element_type = 'post_post' 
            WHERE p.post_type = 'post'
                AND p.post_status = 'publish'
                AND CAST(pm_legacy.meta_value AS UNSIGNED) IN (53)
                AND CAST(pm_legacy.meta_value AS UNSIGNED) > 0
                 AND (EXISTS (
            SELECT 1 FROM mm_postmeta pm_sub_f
            WHERE pm_sub_f.post_id = p.ID
                AND pm_sub_f.meta_key = 'sub_category'
                AND CAST(pm_sub_f.meta_value AS UNSIGNED) IN (27,28)
        ) OR EXISTS (
            SELECT 1 FROM mm_term_relationships tr_f
            INNER JOIN mm_term_taxonomy tt_f
                ON tr_f.term_taxonomy_id = tt_f.term_taxonomy_id
                AND tt_f.taxonomy = 'category'
            WHERE tr_f.object_id = p.ID
                AND tt_f.term_id IN (9241,9242,9250,9251)
        )) 
                 AND mmn_wpml.language_code = 'it' 

            UNION

            SELECT CAST(pm_rel.meta_value AS UNSIGNED) AS universita_id
            FROM mm_posts p
            INNER JOIN mm_postmeta pm_rel
                ON p.ID = pm_rel.post_id
                AND pm_rel.meta_key = 'related_university'
             INNER JOIN mm_icl_translations mmn_wpml ON mmn_wpml.element_id = p.ID AND mmn_wpml.element_type = 'post_post' 
            WHERE p.post_type = 'post'
                AND p.post_status = 'publish'
                AND CAST(pm_rel.meta_value AS UNSIGNED) IN (53)
                AND CAST(pm_rel.meta_value AS UNSIGNED) > 0
                 AND (EXISTS (
            SELECT 1 FROM mm_postmeta pm_sub_f
            WHERE pm_sub_f.post_id = p.ID
                AND pm_sub_f.meta_key = 'sub_category'
                AND CAST(pm_sub_f.meta_value AS UNSIGNED) IN (27,28)
        ) OR EXISTS (
            SELECT 1 FROM mm_term_relationships tr_f
            INNER JOIN mm_term_taxonomy tt_f
                ON tr_f.term_taxonomy_id = tt_f.term_taxonomy_id
                AND tt_f.taxonomy = 'category'
            WHERE tr_f.object_id = p.ID
                AND tt_f.term_id IN (9241,9242,9250,9251)
        )) 
                 AND mmn_wpml.language_code = 'it' 
        ) matched
        WHERE universita_id > 0