Warning system 4.0 - Dirty-weed

This is the 4th version of the cutting agent warning system. Changes to the previous versions are new languages and countries, statistics and weed prices.
The warning system is operated by PHP and a MySQL database, there are a total of 38 tables if you are interested :).
Programmer: Lars L. Kirches (acid-vega@weiter-machen.de)
The query that displays the warnings:
SELECT id AS smm_id, bild_id,streckmittel_id,datum,plz,preis,menge,quali,sorte,kaufort,erkennung,streckmittel,geruchintens,konsistenz,konsistenz_wete,nw_zeit,gallery_id,bild_name ,bild_path,notiz,notiz_sichtbar,
	IF(length(smm.ort)>0,
			(SELECT CONCAT_WS(' ',de_data.plz,de_data.stadt, de_data.region, de_data.bezirk)
     	FROM de_data
		WHERE stadt LIKE smm.ort LIMIT 1), 
			(SELECT CONCAT_WS(' ',de_data.plz,de_data.stadt, de_data.region, de_data.bezirk)
     	FROM de_data
		WHERE plz LIKE CONCAT(smm.plz,'%') LIMIT 1)) AS lokation,
	IF(length(smm.ort)>0,
			(SELECT CONCAT_WS(',',de_data.lat, de_data.lng)
     	FROM de_data 
		WHERE stadt LIKE smm.ort LIMIT 1),
			(SELECT CONCAT_WS(',',de_data.lat, de_data.lng)
     	FROM de_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 Odor,
	(SELECT GROUP_CONCAT(ausehen) FROM `rel_ausehen` 
		LEFT JOIN smm_ausehen USING (ausehen_id)
		WHERE id=smm.id) AS Texture,
	(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 Burnup performance,
	(SELECT GROUP_CONCAT(rauch) FROM `rel_rauch` 
		LEFT JOIN smm_rauch USING (rauch_id) WHERE id=smm.id) AS Smoke taste,
	(SELECT GROUP_CONCAT(merkmal) FROM `rel_merkmal` 
		LEFT JOIN smm_merkmal USING (merkmal_id) 
		WHERE id=smm.id) AS Characteristics
	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_wete USING(konsistenz_wete_id)
	LEFT JOIN smm_nw_zeit USING(nw_zeit_id)
	LEFT JOIN aw_bilder USING(bild_id)
	WHERE land LIKE 'de'
Let me know when making suggestions for optimization :)