Anfrage:
SELECT DISTINCT(a.id),a.titel,a.einleitung,a.text,a.datum,a.ordner_id,a.thumbnail,a.bild,a.bildlink,a.template,a.audio_url,a.programm_id,o.name as ordner_name FROM articles a, ordner o
WHERE a.ordner_id=o.id AND (
(a.ordner_id=414 AND a.published='Y'
AND (
(a.datum<=NOW() AND a.enddatum='0000-00-00 00:00:00')
OR
(a.datum<=NOW() AND a.enddatum>=NOW())
)
) OR (
((a.additional_ordner=414 OR a.additional_ordner2=414) AND a.published='Y')
AND (
(a.datum<=NOW() AND a.enddatum='0000-00-00 00:00:00')
OR
(a.datum<=NOW() AND a.enddatum>=NOW())
)
) ) ORDER BY a.`order` ASC, a.datum DESC LIMIT 0,
Antwort:
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 '' at line 17
Fehlercode: 1064