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' at line 7

---

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