Double Query in conjunction with WPML

Hello,

We are currently experiencing an issue with your plugin when used in conjunction with WPML.

I use WPML to translate my website into four additional languages. However, a serious error is currently occurring: it appears that a duplicate database query is being executed, which results in a database error.

As a result, taxonomies are corrupted, and all posts or content types linked to taxonomies are no longer displayed correctly.

Here is an example of a faulty (duplicated) SQL query:



SELECT COUNT(*)
FROM wacdp_comments JOIN wacdp_icl_translations icltr2
ON icltr2.element_id = wacdp_comments.comment_post_ID JOIN wacdp_posts
ON wacdp_posts.ID = icltr2.element_id
AND CONCAT('post_', wacdp_posts.post_type) = icltr2.element_type
LEFT JOIN wacdp_icl_translations icltr_comment
ON icltr_comment.element_id = wacdp_comments.comment_ID
AND icltr_comment.element_type = 'comment' JOIN wacdp_icl_translations icltr2
ON icltr2.element_id = wacdp_comments.comment_post_ID
AND wacdp_posts.ID = icltr2.element_id
AND CONCAT('post_', wacdp_posts.post_type) = icltr2.element_type
LEFT JOIN wacdp_icl_translations icltr_comment
ON icltr_comment.element_id = wacdp_comments.comment_ID
AND icltr_comment.element_type = 'comment'
WHERE ( comment_approved = 'spam' )
AND comment_type NOT IN ('note')
AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code )
AND icltr2.language_code = 'de'
AND (icltr_comment.language_code IS NULL
OR icltr_comment.language_code = icltr2.language_code )

My questions:

Is this issue known when used with WPML?
Is there a recommended solution or workaround?
Can I configure this behavior somewhere, or does a fix need to be implemented in the plugin?

Thank you very much for your support! We could also provide admin access

Best regards

The page I need help with: [log in to see the link]