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 ' 10' at line 1
SELECT b.id, b.datum, b.titel, b.pfad, b.anleser, b.inhalt, b.freigabe, a.id AS autorID, a.name, CONCAT(bb.id, '_', bb.filename, '.jpg') AS bild, bb.untertitel, (SELECT COUNT(*) FROM sdr_artikel_kommentar AS ak WHERE ak.tabelle_id = 59 AND ak.artikel_id = b.id) AS kommentarZahl, (SELECT GROUP_CONCAT(s.schlagwort, '|', s.id SEPARATOR '||') FROM sdr_link AS l LEFT JOIN sdr_schlagwort AS s ON l.daten_1_id = s.id WHERE l.tabelle_1_id = 22 AND l.tabelle_2_id = 59 AND l.daten_2_id = b.id AND l.link = 1) AS tags FROM sdr_blog AS b LEFT JOIN sdr_autor AS a ON b.autor_id = a.id LEFT JOIN sdr_bild_blog AS bb ON b.bild_id = bb.id WHERE b.freigabe = 1 ORDER BY b.datum DESC, b.id DESC LIMIT , 10