我决定创建SQL查询：

SELECT posts.post_title, posts.post_content, trans.element_type,
trans.language_code
FROM wp_posts AS posts

INNER JOIN wp_icl_translations AS trans
ON posts.ID = trans.element_id

INNER JOIN wp_postmeta AS meta
ON posts.ID = meta.post_id

WHERE trans.element_type = \'post_product\'
AND trans.language_code = \'de\'

仅当您需要post\\u meta上的某些内容时，才会添加此项：

...
INNER JOIN wp_postmeta AS meta
ON posts.ID = meta.post_id
...

我的解决方案是通过语言获取所有帖子trans.language_code = \'de\', trans.language_code = \'es\', trans.language_code = \'en\' ...

$sql = "SELECT p1.*, wm2.meta_value 
                        FROM wp_posts p1 
                        JOIN wp_icl_translations t
                        ON p1.ID = t.element_id 
                        LEFT JOIN wp_postmeta wm1 ON ( wm1.post_id = p1.ID 
                        AND wm1.meta_value IS NOT NULL 
                        AND wm1.meta_key = \'_thumbnail_id\' ) 
                        LEFT JOIN wp_postmeta wm2 ON ( wm1.meta_value = wm2.post_id 
                        AND wm2.meta_key = \'_wp_attached_file\' 
                        AND wm2.meta_value IS NOT NULL ) 
                        WHERE p1.post_status= \'publish\' 
                        AND p1.post_type=\'post\' 
                        AND t.element_type=\'post_post\'
                        AND t.language_code=\'ru\' 
                        ORDER BY p1.post_date DESC 
                        Limit 0, 3";

用拇指点击lang是ru的最后3篇帖子