SELECT
				  cd_bez
				, cd_picture
				, cd_pl_no
				, cd_rgb = ISNULL(cd_rgb, '')
				, hersteller = ISNULL(pl_ku_no, 0)
				, cd_cg_no, cg_bez = ISNULL(cg_bez, '')
				, cd_cf_no, cf_bez = ISNULL(cf_bez, '')
				, cd_cl_no, cl_bez = ISNULL(cl_bez, '')
				, cd_cw_no, cw_bez = ISNULL(cw_bez, '')
				, cd_transmission = ISNULL(cd_transmission, 0), cd_reflexion = ISNULL(cd_reflexion, 0), cd_absorption = ISNULL(cd_absorption, 0)
				, cd_uvschutz = ISNULL(cd_uvschutz, 0)
				, cd_material = ISNULL(cd_material, '')
				, cd_rueckseite = ISNULL(cd_rueckseite,'')
				, cd_stoffbreite_mm = ISNULL(cd_stoffbreite_mm, 0)
				, cd_faltenbreite_mm = ISNULL(cd_faltenbreite_mm, 0)
				, cd_kz_wabe = ISNULL(cd_kz_wabe, 0)
				, cd_kz_feuchtraum = ISNULL(cd_kz_feuchtraum, -1), cd_kz_feuchtabwischbar = ISNULL(cd_kz_feuchtabwischbar, 0)
				, cd_kz_bildschirmarbeitsplatz = ISNULL(cd_kz_bildschirmarbeitsplatz, 0)
				, cd_kz_schwerentflammbar = ISNULL(cd_kz_schwerentflammbar, 0), cd_kz_objekt = ISNULL(cd_kz_objekt, 0), cd_kz_schlafbereich = ISNULL(cd_kz_schlafbereich, 0)
				, cd_kz_kinderzimmer = ISNULL(cd_kz_kinderzimmer, 0), cd_kz_wohnbereich = ISNULL(cd_kz_wohnbereich, 0), cd_kz_wintergarten = ISNULL(cd_kz_wintergarten, 0)
				, cd_kz_waschbar = ISNULL(cd_kz_waschbar, 0)
				, cd_farbbezeichnung = ISNULL(cd_farbbezeichnung, '')
				, cd_musterung = ISNULL(cd_musterung, '')
				, cd_ersetzt_dessin = ISNULL(cd_ersetzt_dessin, ''), cd_ersetzt_bez = ISNULL((SELECT b.cd_bez FROM f_cd_dessin AS b WHERE a.cd_ersetzt_dessin = b.cd_dessin), '')
				, pl_bez
				, pl_system
				, minpreis = ISNULL(cache_value_int, 0)
				, cd_text = ISNULL(cd_text, '')
				, marke_no = ISNUll(cd_marke_no, 0)
				, marke_idbez = ISNUll(marke_idbez, '')
				, cd_kz_oekotex = ISNUll(cd_kz_oekotex, 0)
				, cd_kz_recycelt = ISNUll(cd_kz_recycelt, 0)
				, cd_kz_modell_plc38
				, cd_kz_antibakteriell = ISNUll(cd_kz_antibakteriell, 0)
		FROM v_cd_dessin AS a
		LEFT OUTER JOIN f_s_preislist ON cd_pl_no = pl_no
		LEFT OUTER JOIN f_cf_farbe ON cd_cf_no = cf_no
		LEFT OUTER JOIN f_cw_waerme ON cd_cw_no = cw_no
		LEFT OUTER JOIN f_cg_gruppe ON cd_cg_no = cg_no
		LEFT OUTER JOIN f_cl_licht ON cd_cl_no = cl_no
		LEFT OUTER JOIN f_marke ON cd_marke_no = marke_no
		LEFT OUTER JOIN f_bd_caching ON cache_key = 'minpreisPlissee' + CASE WHEN cd_kz_modell_plc38 = 1 THEN 'Xl' ELSE '' END  + 'Plno_' + CAST(cd_pl_no AS varchar(10))
		WHERE cd_dessin = :design
		AND (cd_kz_modell_plc38 = :kz_modell_plc38 OR cd_faltenbreite_mm > 40)
		AND (
				pl_ku_no != 70000
				OR
				pl_ku_no = 70000 && cd_marke != 9
		)

				AND ISNULL(cd_kz_wwwaus, 0) = 0
		<br />
<b>Fatal error</b>:  Uncaught Exception: 
		SELECT
				  cd_bez
				, cd_picture
				, cd_pl_no
				, cd_rgb = ISNULL(cd_rgb, '')
				, hersteller = ISNULL(pl_ku_no, 0)
				, cd_cg_no, cg_bez = ISNULL(cg_bez, '')
				, cd_cf_no, cf_bez = ISNULL(cf_bez, '')
				, cd_cl_no, cl_bez = ISNULL(cl_bez, '')
				, cd_cw_no, cw_bez = ISNULL(cw_bez, '')
				, cd_transmission = ISNULL(cd_transmission, 0), cd_reflexion = ISNULL(cd_reflexion, 0), cd_absorption = ISNULL(cd_absorption, 0)
				, cd_uvschutz = ISNULL(cd_uvschutz, 0)
				, cd_material = ISNULL(cd_material, '')
				, cd_rueckseite = ISNULL(cd_rueckseite,'')
				, cd_stoffbreite_mm = ISNULL(cd_stoffbreite_mm, 0)
				, cd_faltenbreite_mm = ISNULL(cd_faltenbreite_mm, 0)
				, cd_kz_wabe = ISNULL(cd_kz_wabe, 0)
				, cd_kz_feuchtraum = ISNULL(cd_kz_feuchtraum, -1), cd_kz_feuchtabwischbar = ISNULL(cd_kz_feuchtabwischbar, 0)
				, cd_kz_bildschirmarbeitsplatz = ISNULL(cd_kz_bildschirmarbeitsplatz, 0)
				, cd_kz_schwerentflammbar = ISNULL(cd_kz_schwerentflammbar, 0), cd_kz_objekt = ISNULL(cd_kz_objekt, 0), cd_kz_schlafbereich = ISNULL(cd_kz_schlafbereich, 0)
				, cd_kz_kinderzimmer = ISNULL(cd_kz_kinderzimmer, 0), cd_kz_wohnbereich = ISNULL(cd_kz_wohnbereich, 0), cd_kz_wintergarten = ISNULL(cd_kz_wintergarten, 0)
				, cd_kz_waschbar = ISNULL(cd_kz_waschbar, 0)
				, cd_farbbezeichnung = ISNULL(cd_farbbezeichnung, '')
				, cd_musterung = ISNULL(cd_musterung, '')
				, cd_ersetzt_dessin = ISNULL(cd_ersetzt_dessin, ''), cd_ersetzt_bez = ISNULL((SELECT b.cd_bez FROM f_cd_dessin AS b WHERE a.cd_ersetzt_dessin = b.cd_dessin), '')
				, pl_bez
				, pl_system
				, minpreis = ISNULL(cache_value_int, 0)
				, cd_text = ISNULL(cd_text, '')
				, marke_no = ISNUll(cd_marke_no, 0)
				, marke_idbez = ISNUll(marke_idbez, '')
				, cd_kz_oekotex = ISNUll(cd_kz_oekotex, 0)
				, cd_kz_recycelt = ISNUll(cd_kz_recycelt, 0)
				, cd_kz_modell_plc38
				, cd_kz_antibakteriell = ISNUll(cd_kz_antibakteriell, 0)
		FROM v_cd_dessin AS a
		LEFT OUTER JOIN f_s_preislist ON cd_pl_no = pl_no
		LEFT OUTER JOIN f_cf_farbe ON cd_cf_no = cf_no
		LEFT OUTER JOIN f_cw_waerme ON cd_cw_no = cw_no
		LEFT OUTER JOIN f_cg_gruppe ON cd_cg_no = cg_no
		LEFT OUTER JOIN f_cl_licht ON cd_cl_no = cl_no
		LEFT OUTER JOIN f_marke ON cd_marke_no = marke_no
		LEFT OUTER JOIN f_bd_caching ON cache_key = 'minpreisPlissee' + CASE WHEN cd_kz_modell_plc38 = 1 THEN 'Xl' ELSE '' END  + 'Plno_' + CAST(cd_pl_no AS varchar(10))
		WHERE cd_dessin = :design
		AND (cd_kz_modell_plc38 = :kz_modell_plc38 OR cd_faltenbreite_mm &gt; 40)
		AND (
				pl_ku_no != 70000
				OR
				pl_ku_no = 70000 &amp;&amp; cd_marke != 9
		)

				AND ISNULL(cd_kz_wwwaus, 0) = 0
		 -- SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Falsche Syntax in der Nähe von &quot;&amp;&quot;. in D:\www\raumtexLayoutumstellung\php\inc_database.php:91
Stack trace:
#0 D:\www\raumtexLayoutumstellung\plissee\mass_design.php(180): DB_PDOStatement-&gt;execute()
#1 {main}
  thrown in <b>D:\www\raumtexLayoutumstellung\php\inc_database.php</b> on line <b>91</b><br />