1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and artikel.ID = top_seller.artikel_ID and artikel.Languag' at line 6

---

select top_seller.artikel_ID as artikel_ID from top_seller, artikel where top_seller.shops_ID = 1 and top_seller.root_dir = and artikel.ID = top_seller.artikel_ID and artikel.Language = 'DE' and artikel.status = 0 and top_seller.no_output = 0 order by top_seller.anzahl desc limit 1