Unknown column 'announce.freigabe' in 'where clause'
SELECT announce.*, bereich.name AS bereichname, waehrung.name AS waehrungname, farbe.name AS farbename, kraftstoff.name AS kraftstoffname, marke.name AS markename, kategorie.name AS kategoriename, antriebsart.name AS antriebsartname FROM announce LEFT JOIN bereich ON bereich.id = announce.bereich LEFT JOIN waehrung ON waehrung.id = announce.waehrung LEFT JOIN farbe ON farbe.id = announce.farbe LEFT JOIN kategorie ON kategorie.id = announce.kategorie LEFT JOIN kraftstoff ON kraftstoff.id = announce.kraftstoff LEFT JOIN marke ON marke.id = announce.marke LEFT JOIN land ON land.id = announce.land LEFT JOIN antriebsart ON antriebsart.id = announce.antriebsart WHERE 1=1 AND announce.freigabe=1