SELECT
	CONCAT(COUNT(*), 'x') AS `Anzahl`,
	ArticleEntry_Language.ArticleEntry_Language_Title AS `Titel`
FROM ShopArticle
INNER JOIN ArticleEntry ON (ShopArticle.ArticleEntry_ID = ArticleEntry.ArticleEntry_ID)
LEFT JOIN ArticleEntry_Language ON (ArticleEntry_Language.ArticleEntry_ID = ArticleEntry.ArticleEntry_ID AND ArticleEntry_Language.Language_Code = 'de')
GROUP BY ArticleEntry_Language.ArticleEntry_Language_Title
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC