Problem with localization in sitemap categories with WPML plugin.

We have it set to “only show translated items”. So I understand correctly that this is not the normal behavior of outputting items? If yes, and it is not a problem from your side, then we will look into it. Thank you very much for your help.

SELECT terms.*, term_taxonomy.taxonomy, term_taxonomy.count, (
				SELECT MAX(p.post_modified)
				FROM logic_posts AS p
				INNER JOIN logic_term_relationships AS tr ON p.ID = tr.object_id
				WHERE p.post_type IN ('post','theme_wiki')
				AND p.post_status = 'publish'
				AND tr.term_taxonomy_id = term_taxonomy.term_taxonomy_id
			) AS post_modified
			FROM logic_terms AS terms
			INNER JOIN logic_term_taxonomy AS term_taxonomy ON terms.term_id = term_taxonomy.term_id
			INNER JOIN logic_icl_translations AS translations ON term_taxonomy.term_taxonomy_id = translations.element_id
			WHERE translations.language_code = 'de' AND translations.element_type IN ('tax_category','tax_post_tag','tax_wiki_archive')
			AND  term_taxonomy.taxonomy IN ('category','post_tag','wiki_archive')
			
			AND term_taxonomy.count > 0
			GROUP BY terms.term_id
			ORDER BY post_modified DESC, terms.name ASC
		 LIMIT 0, 1000;

You have a query error here. You are comparing the wrong id, because element_id is the translation id, not the taxonomy id.

I ran this query manually and it gave the correct result.

Thanks a lot, it’s working now 🙂