WordPress database error: [Not unique table/alias: 'nb_postmeta']
SELECT SQL_CALC_FOUND_ROWS DISTINCT nb_posts.ID FROM nb_posts LEFT JOIN nb_term_relationships ON (nb_posts.ID = nb_term_relationships.object_id) INNER JOIN nb_postmeta ON ( nb_posts.ID = nb_postmeta.post_id ) LEFT JOIN nb_icl_translations wpml_translations ON nb_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', nb_posts.post_type) LEFT JOIN nb_postmeta ON nb_posts.ID = nb_postmeta.post_id WHERE 1=1 AND ( nb_posts.ID NOT IN ( SELECT object_id FROM nb_term_relationships WHERE term_taxonomy_id IN (13) ) AND nb_term_relationships.term_taxonomy_id IN (2500,2515,2552,2615,2617,2618,2616,2553,2619,2621,2622,2620,2623,2554,2624,2627,2626,2625,2628,2555,2629,2630,2633,2632,2631,2634,2556,2635,2638,2637,2636,2639,2516,2557,2640,2641,2558,2642,2644,2643,2645,2559,2560,2561,2562,2646,2649,2648,2647,2650,2563,2564,2565,2517,2566,2651,2653,2652,2654,2568,2567,2569,2497,2518,2656,2657,2570,2661,2658,2660,2662,2659,2663,2664,2706,2707,2665,2666,2571,2667,2668,2669,2670) ) AND ( nb_postmeta.meta_key = 'total_sales' ) AND ((nb_posts.post_type = 'post' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request')) OR (nb_posts.post_type = 'page' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request')) OR (nb_posts.post_type = 'attachment' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request')) OR (nb_posts.post_type = 'product' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request')) OR (nb_posts.post_type = 'portfolio' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request')) OR (nb_posts.post_type = 'avia_framework_post' AND (nb_posts.post_status = 'publish' OR nb_posts.post_status = 'acf-disabled' OR nb_posts.post_status = 'wc-ywraq-new' OR nb_posts.post_status = 'wc-ywraq-pending' OR nb_posts.post_status = 'wc-ywraq-expired' OR nb_posts.post_status = 'wc-ywraq-accepted' OR nb_posts.post_status = 'wc-ywraq-rejected' OR nb_posts.post_status = 'wc-qb-spec-request' OR nb_posts.post_status = 'wc-qb-xls-request'))) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND nb_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','um_form','product','product_variation','portfolio' ) ) OR nb_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','um_form','product','product_variation','portfolio' ) ) GROUP BY nb_posts.ID ORDER BY nb_postmeta.meta_value+0 DESC LIMIT 0, 15