Unknown column 'us_data.region' in 'field list'
	SELECT id AS smm_id, bild_id,streckmittel_id,datum,plz,preis,menge,quali,sorte,kaufort,erkennung,streckmittel,geruchintens,konsistenz,konsistenz_feuchte,nw_zeit,gallery_id,bild_name ,bild_path,notiz,notiz_sichtbar,
	IF(length(smm.ort)>0,
			(SELECT CONCAT_WS(' ',us_data.plz,us_data.stadt, us_data.region, us_data.bezirk)
     	FROM us_data
		WHERE stadt LIKE smm.ort LIMIT 1), 
			(SELECT CONCAT_WS(' ',us_data.plz,us_data.stadt, us_data.region, us_data.bezirk)
     	FROM us_data
		WHERE plz LIKE CONCAT(smm.plz,'%') LIMIT 1)) AS lokation,
	IF(length(smm.ort)>0,
			(SELECT CONCAT_WS(',',us_data.lat, us_data.lng)
     	FROM us_data 
		WHERE stadt LIKE smm.ort LIMIT 1),
			(SELECT CONCAT_WS(',',us_data.lat, us_data.lng)
     	FROM us_data 
		WHERE plz LIKE CONCAT(smm.plz,'%') LIMIT 1))AS coord,
	DATE_FORMAT( `datum` , '%d.%m.%Y %H:%i' ) AS datum,
	(SELECT GROUP_CONCAT(geruch) FROM `rel_geruch` 
		LEFT JOIN smm_geruch USING (geruch_id)
		WHERE id=smm.id) AS Geruch,
	(SELECT GROUP_CONCAT(ausehen) FROM `rel_ausehen` 
		LEFT JOIN smm_ausehen USING (ausehen_id)
		WHERE id=smm.id) AS Aussehen,
	(SELECT GROUP_CONCAT(nw_unerwartet) FROM `rel_nw_unerwartet` 
		LEFT JOIN smm_nw_unerwartet USING (nw_unerwartet_id) 
		WHERE id=smm.id) AS nw_unerwartet,
	(SELECT GROUP_CONCAT(abbrenn) FROM `rel_abbrenn` 
		LEFT JOIN smm_abbrenn USING (abbrenn_id) WHERE id=smm.id) AS Abbrennverhalten,
	(SELECT GROUP_CONCAT(rauch) FROM `rel_rauch` 
		LEFT JOIN smm_rauch USING (rauch_id) WHERE id=smm.id) AS Rauchgeschmack,
	(SELECT GROUP_CONCAT(merkmal) FROM `rel_merkmal` 
		LEFT JOIN smm_merkmal USING (merkmal_id) 
		WHERE id=smm.id) AS Merkmale
	FROM `smm` 
	LEFT JOIN smm_sorte USING(sorte_id)
	LEFT JOIN smm_kaufort USING(kaufort_id)
	LEFT JOIN smm_erkennung USING(erkennung_id)
	LEFT JOIN smm_streckmittel USING(streckmittel_id)
	LEFT JOIN smm_geruchintens USING(geruchintens_id)
	LEFT JOIN smm_konsistenz USING(konsistenz_id)
	LEFT JOIN smm_konsistenz_feuchte USING(konsistenz_feuchte_id)
	LEFT JOIN smm_nw_zeit USING(nw_zeit_id)
	LEFT JOIN aw_bilder USING(bild_id)
	WHERE land='us'
	 ORDER BY smm.datum DESC LIMIT 1000