A Database Error Occurred

Error Number: 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 'WHERE boote.id=.boot_id AND typ='' AND publish='J' GROUP BY subtyp,' at line 3

SELECT id,name,werft,typ,subtyp,laenge,breite,preis,land,jahrgang,jahrgang as modelljahr, CONCAT(pic,riss,wwwpic1,wwwpic2,wwwpic3,wwwpic4) as bild,MAX(id) AS max_id, MIN(preis) as minPs,MAX(preis) as maxPs, max(jahrgang) AS mxjg FROM boote, WHERE boote.id=.boot_id AND typ='' AND publish='J' GROUP BY subtyp,name,werft ORDER BY subtyp ASC, name ASC, mxjg DESC LIMIT 1000