WordPress database error: [Column 'ID' in field list is ambiguous]
SELECT ID, post_title
FROM wp_posts
LEFT JOIN wp_ak_popularity pop
ON wp_posts.ID = pop.post_id
JOIN wp_icl_translations t ON wp_posts.ID = t.element_id
AND t.element_type IN ('post_post','post_page') JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1
WHERE post_status = 'publish'
AND post_date < NOW()
AND t.language_code='de'
GROUP BY wp_posts.ID
ORDER BY pop.total DESC
LIMIT 10