SELECT DISTINCT ta.id AS id FROM `agi_artikel` AS ta LEFT JOIN `agi_artikel_modelle` AS tam ON tam.article_id=ta.id LEFT JOIN `agi_artikel_kategorie` AS tk ON tk.id=ta.kategorie LEFT JOIN `agi_artikel_aktion` AS aa ON ta.id = aa.article_id WHERE ta.del=0 AND tam.delete=0 AND ta.kategorie>0 AND ta.shop_0=1 AND ta.shop_active=1 AND tk.visible=1 AND aa.start <= '2019-10-20 09:41:24' AND aa.end > '2019-10-13 09:41:24' AND LIMIT 0,10
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 'LIMIT 0,10' at line 1