SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (2238,2239,2240,2242,2245,2246,2248,2251,2252,2255,2259,2261,2263,2277,2281,2283,2285,2287,2289,2309,2311,2313,2315,2319,2323,2325,2327,2394,2400,2402,2404,2406,2412,2414,2416,2418,2420,2422,2424,2426,2428,2430,2432,2434,2436,2438,2440,2442,2444,2446,2448,2450,2455,2458,2467,2470,2474,2476,2480,2491,2492,2505,2508,2509,2516,2518,2520,2527,2531,2532,2533,2542,2544,2546,2563,2564,2567,2570,2574,2575,2576,2577,2578,2579,2588,2591,2594,2597,2601,2608,2609,2614,2625,2673,2676,2677,2680,2683,12571,22526)
) AND (
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '1' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '0' )
OR
( wp_postmeta.meta_key = 'premium' AND wp_postmeta.meta_value = '' )
) AND wp_posts.post_type = 'listing' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'de' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','listing','acf-field-group','cookielawinfo','g','comarcas' ) ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC, RAND() DESC LIMIT 0, 10
Was unternehmen in TUDESTINO