Ähnliche Objekte

SELECT o.id AS oid, o.vid AS vid, f.oid AS foid, o.hits AS hits, o.published, o.created, o.featured AS featured, t1.title AS objektart, t1.id, o.markt AS objektmarkt, t2.title AS objekttyp, t2.id, o.premium, fl.wohnflaeche AS fl_wohnflaeche, -- fl.nutzflaeche AS fl_nutzflaeche, fl.gesamtflaeche AS fl_gesamtflaeche, fl.ladenflaeche AS fl_ladenflaeche, -- fl.lagerflaeche AS fl_lagerflaeche, -- fl.verkaufsflaeche AS fl_verkaufsflaeche, -- fl.freiflaeche AS fl_freiflaeche, -- fl.bueroflaeche AS fl_bueroflaeche, -- fl.bueroteilflaeche AS fl_bueroteilflaeche, -- fl.fensterfront AS fl_fensterfront, -- fl.verwaltungsflaeche AS fl_verwaltungsflaeche, fl.gastroflaeche AS fl_gastroflaeche, -- fl.grz AS fl_grz, -- fl.gfz AS fl_gfz, -- fl.bmz AS fl_bmz, -- fl.bgf AS fl_bgf, fl.grundstuecksflaeche AS fl_grundstuecksflaeche, -- fl.sonstflaeche AS fl_sonstflaeche, fl.anzahl_zimmer AS fl_anzahl_zimmer, fl.anzahl_schlafzimmer AS fl_anzahl_schlafzimmer, fl.anzahl_badezimmer AS fl_anzahl_badezimmer, -- fl.anzahl_sep_wc AS fl_anzahl_sep_wc, fl.anzahl_balkon_terrassen AS fl_anzahl_balkon_terrassen -- fl.balkon_terrasse_flaeche AS fl_balkon_terrasse_flaeche -- fl.anzahl_wohn_schlafzimmer AS fl_anzahl_wohn_schlafzimmer -- fl.gartenflaeche AS fl_gartenflaeche, -- fl.kellerflaeche AS fl_kellerflaeche, -- fl.fensterfront_qm AS fl_fensterfront_qm, -- fl.grundstuecksfront AS fl_grundstuecksfront, -- fl.dachbodenflaeche AS fl_dachbodenflaeche, -- fl.teilbar_ab AS fl_teilbar_ab, -- fl.beheizbare_flaeche AS fl_beheizbare_flaeche, -- fl.anzahl_stellplaetze AS fl_anzahl_stellplaetze, -- fl.plaetze_gastraum AS fl_plaetze_gastraum, -- fl.anzahl_betten AS fl_anzahl_betten, -- fl.anzahl_tagungsraeume AS fl_anzahl_tagungsraeume, -- fl.vermietbare_flaeche AS fl_vermietbare_flaeche, -- fl.anzahl_wohneinheiten AS fl_anzahl_wohneinheiten, -- fl.anzahl_gewerbeeinheiten AS fl_anzahl_gewerbeeinheiten, -- fl.einliegerwohnung AS fl_einliegerwohnung, -- fl.anzahl_balkone AS fl_anzahl_balkone, -- fl.anzahl_terrassen AS fl_anzahl_terrassen, -- fl.anzahl_logia AS fl_anzahl_logia ,g.ort, p.waehrung, p.kaufpreis_auf_anfrage,vt.objektnr_extern,z.verkaufstatus_stand,CASE WHEN o.markt=1 AND p.kaufpreis != 0 THEN p.kaufpreis WHEN p.gesamtbelastungbrutto != 0 THEN p.gesamtbelastungbrutto WHEN o.markt=4 THEN p.erbpacht WHEN o.markt=8 THEN p.pacht WHEN o.markt=2 AND p.warmmiete != 0 THEN p.warmmiete WHEN o.markt=2 AND p.kaltmiete != 0 THEN p.kaltmiete ELSE p.nettokaltmiete + p.nebenkosten END AS preis ,f.objekttitel AS freitexte_objekttitel, f.dreizeiler AS freitexte_dreizeiler, f.lage AS lage, f.ausstatt_beschr AS ausstatt_beschr, f.objektbeschreibung AS objektbeschreibung, f.sonstige_angaben AS sonstige_angaben,lang.objekttitel AS lang_objekttitel, lang.dreizeiler AS lang_dreizeiler, lang.lage AS lang_lage, lang.ausstatt_beschr AS lang_ausstatt_beschr, lang.objektbeschreibung AS lang_objektbeschreibung, lang.sonstige_angaben AS lang_sonstige_angaben,CASE WHEN CHAR_LENGTH(lang.alias) THEN CONCAT_WS(':', o.id, lang.alias) ELSE o.id END as slug,CASE WHEN CHAR_LENGTH(t1.title) THEN CONCAT_WS(':', o.art, t1.title) ELSE o.art END as artslug,loc.loc_name, loc.level, loc.loc_id,fi.file as file, fi.title as filetitle FROM #__prime_objects AS o LEFT JOIN #__prime_geo_xref AS x ON o.id = x.oid LEFT JOIN #__prime_geo_locations AS loc ON x.loc_id = loc.loc_id LEFT JOIN #__prime_object_types AS t1 ON o.art = t1.id LEFT JOIN #__prime_object_types AS t2 ON o.typ = t2.id LEFT JOIN #__prime_geo AS g ON o.id = g.oid LEFT JOIN #__prime_freitexte AS f ON o.id = f.oid LEFT JOIN #__prime_vtech vt ON o.id = vt.oid LEFT JOIN #__prime_preise AS p ON o.id = p.oid LEFT JOIN #__prime_zustand_angaben AS z ON o.id = z.oid LEFT JOIN #__prime_flaechen AS fl ON o.id = fl.oid LEFT JOIN (SELECT x.oid, x.gid FROM #__prime_group_xref AS x GROUP BY x.oid, x.gid) gx ON o.id = gx.oid LEFT JOIN #__prime_lang AS lang ON (o.id = lang.oid AND lang.language="de-DE") LEFT JOIN (SELECT f.* FROM #__prime_files f JOIN (SELECT oid, min(ordering) as min_ordering, file, title, mediatype FROM #__prime_files WHERE mediatype = 1 GROUP BY oid) AS sub ON f.oid = sub.oid AND f.ordering = sub.min_ordering WHERE f.mediatype = 1 ORDER BY f.oid) fi ON o.id = fi.oid WHERE o.id != '4413' AND o.art = AND o.markt = AND o.id != '4413' AND o.access IN (0,1,5) AND o.published = 1 GROUP BY o.id ORDER BY o.created DESC LIMIT 8You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND o.markt = AND o.id != '4413' AND o.access IN (0,1,5) AND o.published = ...' at line 68