Produktfilter
Serie Montage Lichttechnik Leuchtmittel Lampenleistung
SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'LAS' OR FilterText6 = 'LAP' OR FilterText6 = 'RAK' OR FilterText6 = 'LAM' OR FilterText6 = 'LAR' OR FilterText6 = 'LAW' OR FilterText6 = 'LAO | CAO | WAO' OR FilterText6 = 'RAC' OR FilterText6 = 'RAX' OR FilterText6 = 'RAF' OR FilterText6 = 'LAT' OR FilterText6 = 'MA' OR FilterText6 = 'LAK') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SBL' OR FilterText6 = 'SBE' OR FilterText6 = 'SBT' OR FilterText6 = 'SRL' OR FilterText6 = 'SRE' OR FilterText6 = 'SDE' OR FilterText6 = 'SRB' OR FilterText6 = 'SEMI' OR FilterText6 = 'SECO' OR FilterText6 = 'SEGI' OR FilterText6 = 'SDEX') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SQL' OR FilterText6 = 'SQE' OR FilterText6 = 'SQL-LED' OR FilterText6 = 'SVL' OR FilterText6 = 'SVE') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SBA' OR FilterText6 = 'SDAB | SDAL' OR FilterText6 = 'SDAW' OR FilterText6 = 'SDAX' OR FilterText6 = 'SDAZ') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SQA') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SP') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'SP') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'P04H08' OR FilterText6 = 'P04-Anbau/Pendel' OR FilterText6 = 'P04-Einbau' OR FilterText6 = 'P04R06' OR FilterText6 = 'P07H12' OR FilterText6 = 'P07-Anbau/Pendel' OR FilterText6 = 'P07-Einbau' OR FilterText6 = 'P07R08' OR FilterText6 = 'P07H09' OR FilterText6 = 'P10-Anbau/Pendel' OR FilterText6 = 'P10-Einbau') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'LOLA' OR FilterText6 = 'LOBI' OR FilterText6 = 'CSPA' OR FilterText6 = 'LOLA | LOBI') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'CWP' OR FilterText6 = 'CWV' OR FilterText6 = 'LKPW075' OR FilterText6 = 'LIPW075' OR FilterText6 = 'Wandanbauleuchte') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'LQF' OR FilterText6 = 'LQN' OR FilterText6 = 'LQA') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'Lichtleisten' OR FilterText6 = 'höhere Schutzart' OR FilterText6 = 'Reinraum' OR FilterText6 = 'LAELLI') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'RES' OR FilterText6 = 'REM' OR FilterText6 = 'LSF' OR FilterText6 = 'AEF' OR FilterText6 = 'REM | WREM' OR FilterText6 = 'LEF' OR FilterText6 = 'LEW' OR FilterText6 = 'LHF' OR FilterText6 = 'LPH' OR FilterText6 = 'LTF' OR FilterText6 = 'LTN' OR FilterText6 = 'ME') GROUP BY artnr) AS gruppiert SELECT COUNT(artnr) AS anzahl FROM (SELECT artnr FROM import_Tabelle_View_Externe_LDB AS produkte , import_Tabelle_View_Equipment_LDB AS equipment WHERE Internet='1' AND equipment.ArtikelID = produkte.ArtikelID AND Sprache='German' AND (FilterText6 = 'LAT') GROUP BY artnr) AS gruppiert