exec sp_executesql N'SELECT TOP (128)
[Project5].[kArtikel] AS [kArtikel],
[Project5].[Zustand] AS [Zustand],
[Project5].[kVaterArtikel] AS [kVaterArtikel],
[Project5].[kStueckliste] AS [kStueckliste],
[Project5].[kArtikelForKategorieArtikel] AS [kArtikelForKategorieArtikel],
[Project5].[Artikelnummer] AS [Artikelnummer],
[Project5].[Sortiernummer] AS [Sortiernummer],
[Project5].[Artikelname] AS [Artikelname],
[Project5].[Labels] AS [Labels],
[Project5].[Einheit] AS [Einheit],
[Project5].[EAN] AS [EAN],
[Project5].[Herkunftsland] AS [Herkunftsland],
[Project5].[UNNUmmer] AS [UNNUmmer],
[Project5].[cHan] AS [cHan],
[Project5].[Gefahrennummer] AS [Gefahrennummer],
[Project5].[ISBN] AS [ISBN],
[Project5].[ASIN] AS [ASIN],
[Project5].[TaricCode] AS [TaricCode],
[Project5].[UPC] AS [UPC],
[Project5].[Hersteller] AS [Hersteller],
[Project5].[Lieferstatus] AS [Lieferstatus],
[Project5].[Breite] AS [Breite],
[Project5].[Hoehe] AS [Hoehe],
[Project5].[Laenge] AS [Laenge],
[Project5].[Erstelldatum] AS [Erstelldatum],
[Project5].[Bearbeitungsdatum] AS [Bearbeitungsdatum],
[Project5].[Bearbeiter] AS [Bearbeiter],
[Project5].[EinkaufspreisDurchschnittNetto] AS [EinkaufspreisDurchschnittNetto],
[Project5].[cLagerfuehrungaktiv] AS [cLagerfuehrungaktiv],
[Project5].[EinkaufspreisLetzerEinkauf] AS [EinkaufspreisLetzerEinkauf],
[Project5].[DatumLetzerEinkauf] AS [DatumLetzerEinkauf],
[Project5].[VerkaufspreisNetto] AS [VerkaufspreisNetto],
[Project5].[UVP] AS [UVP],
[Project5].[Gewinn] AS [Gewinn],
[Project5].[GewinnInProzent] AS [GewinnInProzent],
[Project5].[PreisAmazon] AS [PreisAmazon],
[Project5].[PreisEbay] AS [PreisEbay],
[Project5].[Sonderpreis] AS [Sonderpreis],
[Project5].[GrundpreisWert] AS [GrundpreisWert],
[Project5].[Grundpreiseinheit] AS [Grundpreiseinheit],
[Project5].[Masseinheit] AS [Masseinheit],
[Project5].[Gewicht] AS [Gewicht],
[Project5].[Versandgewicht] AS [Versandgewicht],
[Project5].[BestandGesamt] AS [BestandGesamt],
[Project5].[BestandEigen] AS [BestandEigen],
[Project5].[BestandImZulauf] AS [BestandImZulauf],
[Project5].[BestandAufEinkaufsliste] AS [BestandAufEinkaufsliste],
[Project5].[BestandInAuftraegen] AS [BestandInAuftraegen],
[Project5].[BestandVerfuegbar] AS [BestandVerfuegbar],
[Project5].[nHatMindestbestand] AS [nHatMindestbestand],
[Project5].[MindestAbnahmemenge] AS [MindestAbnahmemenge],
[Project5].[Abnahmeintervall] AS [Abnahmeintervall],
[Project5].[BestandInAmazonAngeboten] AS [BestandInAmazonAngeboten],
[Project5].[cIstAufPreisliste] AS [cIstAufPreisliste],
[Project5].[IstStueckliste] AS [IstStueckliste],
[Project5].[cIstAktiv] AS [cIstAktiv],
[Project5].[cIstTopArtikel] AS [cIstTopArtikel],
[Project5].[cIstNeu] AS [cIstNeu],
[Project5].[IstStuecklistenkomponente] AS [IstStuecklistenkomponente],
[Project5].[nIstMHD] AS [nIstMHD],
[Project5].[nIstCharge] AS [nIstCharge],
[Project5].[cIstSeriennummer] AS [cIstSeriennummer],
[Project5].[cIstStueckzahlteilbar] AS [cIstStueckzahlteilbar],
[Project5].[cIstUeberverkaufMoeglich] AS [cIstUeberverkaufMoeglich],
[Project5].[nIstVarkombiVater] AS [nIstVarkombiVater],
[Project5].[nIstVarkombikind] AS [nIstVarkombikind],
[Project5].[nIstFuerBestellvorschlagGesperrt] AS [nIstFuerBestellvorschlagGesperrt],
[Project5].[nShopAktiv] AS [nShopAktiv],
[Project5].[nVPE] AS [nVPE],
[Project5].[EBayBestand] AS [EBayBestand],
[Project5].[VerkaufspreisBrutto] AS [VerkaufspreisBrutto],
[Project5].[ZustandName] AS [ZustandName],
[Project5].[Anmerkung] AS [Anmerkung],
[Project5].[Lieferant] AS [Lieferant],
[Project5].[nBeschaffungszeitAutomatisch] AS [nBeschaffungszeitAutomatisch],
[Project5].[BeschaffungszeitManuell] AS [BeschaffungszeitManuell],
[Project5].[Beschreibung] AS [Beschreibung],
[Project5].[ErscheintAm] AS [ErscheintAm],
[Project5].[Kurzbeschreibung] AS [Kurzbeschreibung],
[Project5].[Serie] AS [Serie],
[Project5].[Steuerklasse] AS [Steuerklasse],
[Project5].[Warengruppe] AS [Warengruppe],
[Project5].[ZusaetzlicheBearbeitungszeit] AS [ZusaetzlicheBearbeitungszeit],
[Project5].[Versandklasse] AS [Versandklasse],
[Project5].[FfnAktiv] AS [FfnAktiv],
[Project5].[FfnEigen] AS [FfnEigen],
[Project5].[JTLFPID] AS [JTLFPID],
[Project5].[ReserviertGesamt] AS [ReserviertGesamt],
[Project5].[AmazonFnsku] AS [AmazonFnsku],
[Project5].[Puffer] AS [Puffer],
[Project5].[nSeriennummernVerfolgung] AS [nSeriennummernVerfolgung],
[Project5].[MetaDescription] AS [MetaDescription],
[Project5].[TitleTag] AS [TitleTag],
[Project5].[MetaKeywords] AS [MetaKeywords],
[Project5].[ZustandSprache] AS [ZustandSprache],
[Project5].[kFirma] AS [kFirma],
[Project5].[nMidestbestand] AS [nMidestbestand]
FROM ( SELECT
[Extent1].[kArtikel] AS [kArtikel],
[Extent1].[Zustand] AS [Zustand],
[Extent1].[kVaterArtikel] AS [kVaterArtikel],
[Extent1].[kStueckliste] AS [kStueckliste],
[Extent1].[kArtikelForKategorieArtikel] AS [kArtikelForKategorieArtikel],
[Extent1].[Artikelnummer] AS [Artikelnummer],
[Extent1].[Sortiernummer] AS [Sortiernummer],
[Extent1].[Artikelname] AS [Artikelname],
[Extent1].[Labels] AS [Labels],
[Extent1].[Einheit] AS [Einheit],
[Extent1].[EAN] AS [EAN],
[Extent1].[Herkunftsland] AS [Herkunftsland],
[Extent1].[UNNUmmer] AS [UNNUmmer],
[Extent1].[cHan] AS [cHan],
[Extent1].[Gefahrennummer] AS [Gefahrennummer],
[Extent1].[ISBN] AS [ISBN],
[Extent1].[ASIN] AS [ASIN],
[Extent1].[TaricCode] AS [TaricCode],
[Extent1].[UPC] AS [UPC],
[Extent1].[Hersteller] AS [Hersteller],
[Extent1].[Lieferstatus] AS [Lieferstatus],
[Extent1].[Breite] AS [Breite],
[Extent1].[Hoehe] AS [Hoehe],
[Extent1].[Laenge] AS [Laenge],
[Extent1].[Erstelldatum] AS [Erstelldatum],
[Extent1].[Bearbeitungsdatum] AS [Bearbeitungsdatum],
[Extent1].[Bearbeiter] AS [Bearbeiter],
[Extent1].[EinkaufspreisDurchschnittNetto] AS [EinkaufspreisDurchschnittNetto],
[Extent1].[cLagerfuehrungaktiv] AS [cLagerfuehrungaktiv],
[Extent1].[EinkaufspreisLetzerEinkauf] AS [EinkaufspreisLetzerEinkauf],
[Extent1].[DatumLetzerEinkauf] AS [DatumLetzerEinkauf],
[Extent1].[VerkaufspreisNetto] AS [VerkaufspreisNetto],
[Extent1].[UVP] AS [UVP],
[Extent1].[Gewinn] AS [Gewinn],
[Extent1].[GewinnInProzent] AS [GewinnInProzent],
[Extent1].[PreisAmazon] AS [PreisAmazon],
[Extent1].[PreisEbay] AS [PreisEbay],
[Extent1].[Sonderpreis] AS [Sonderpreis],
[Extent1].[GrundpreisWert] AS [GrundpreisWert],
[Extent1].[Grundpreiseinheit] AS [Grundpreiseinheit],
[Extent1].[Masseinheit] AS [Masseinheit],
[Extent1].[Gewicht] AS [Gewicht],
[Extent1].[Versandgewicht] AS [Versandgewicht],
[Extent1].[BestandGesamt] AS [BestandGesamt],
[Extent1].[BestandEigen] AS [BestandEigen],
[Extent1].[BestandImZulauf] AS [BestandImZulauf],
[Extent1].[BestandAufEinkaufsliste] AS [BestandAufEinkaufsliste],
[Extent1].[BestandInAuftraegen] AS [BestandInAuftraegen],
[Extent1].[BestandVerfuegbar] AS [BestandVerfuegbar],
[Extent1].[nHatMindestbestand] AS [nHatMindestbestand],
[Extent1].[MindestAbnahmemenge] AS [MindestAbnahmemenge],
[Extent1].[Abnahmeintervall] AS [Abnahmeintervall],
[Extent1].[BestandInAmazonAngeboten] AS [BestandInAmazonAngeboten],
[Extent1].[cIstAufPreisliste] AS [cIstAufPreisliste],
[Extent1].[IstStueckliste] AS [IstStueckliste],
[Extent1].[cIstAktiv] AS [cIstAktiv],
[Extent1].[cIstTopArtikel] AS [cIstTopArtikel],
[Extent1].[cIstNeu] AS [cIstNeu],
[Extent1].[IstStuecklistenkomponente] AS [IstStuecklistenkomponente],
[Extent1].[nIstMHD] AS [nIstMHD],
[Extent1].[nIstCharge] AS [nIstCharge],
[Extent1].[cIstSeriennummer] AS [cIstSeriennummer],
[Extent1].[cIstStueckzahlteilbar] AS [cIstStueckzahlteilbar],
[Extent1].[cIstUeberverkaufMoeglich] AS [cIstUeberverkaufMoeglich],
[Extent1].[nIstVarkombiVater] AS [nIstVarkombiVater],
[Extent1].[nIstVarkombikind] AS [nIstVarkombikind],
[Extent1].[nIstFuerBestellvorschlagGesperrt] AS [nIstFuerBestellvorschlagGesperrt],
[Extent1].[nShopAktiv] AS [nShopAktiv],
[Extent1].[nVPE] AS [nVPE],
[Extent1].[EBayBestand] AS [EBayBestand],
[Extent1].[VerkaufspreisBrutto] AS [VerkaufspreisBrutto],
[Extent1].[ZustandName] AS [ZustandName],
[Extent1].[Anmerkung] AS [Anmerkung],
[Extent1].[Lieferant] AS [Lieferant],
[Extent1].[nBeschaffungszeitAutomatisch] AS [nBeschaffungszeitAutomatisch],
[Extent1].[BeschaffungszeitManuell] AS [BeschaffungszeitManuell],
[Extent1].[Beschreibung] AS [Beschreibung],
[Extent1].[ErscheintAm] AS [ErscheintAm],
[Extent1].[Kurzbeschreibung] AS [Kurzbeschreibung],
[Extent1].[Serie] AS [Serie],
[Extent1].[Steuerklasse] AS [Steuerklasse],
[Extent1].[Warengruppe] AS [Warengruppe],
[Extent1].[ZusaetzlicheBearbeitungszeit] AS [ZusaetzlicheBearbeitungszeit],
[Extent1].[Versandklasse] AS [Versandklasse],
[Extent1].[FfnAktiv] AS [FfnAktiv],
[Extent1].[FfnEigen] AS [FfnEigen],
[Extent1].[JTLFPID] AS [JTLFPID],
[Extent1].[ReserviertGesamt] AS [ReserviertGesamt],
[Extent1].[AmazonFnsku] AS [AmazonFnsku],
[Extent1].[Puffer] AS [Puffer],
[Extent1].[nSeriennummernVerfolgung] AS [nSeriennummernVerfolgung],
[Extent1].[MetaDescription] AS [MetaDescription],
[Extent1].[TitleTag] AS [TitleTag],
[Extent1].[MetaKeywords] AS [MetaKeywords],
[Extent1].[ZustandSprache] AS [ZustandSprache],
[Extent1].[kFirma] AS [kFirma],
[Extent1].[nMidestbestand] AS [nMidestbestand]
FROM [ArtikelVerwaltung].[vArtikelliste] AS [Extent1]
WHERE ([Extent1].[ZustandSprache] = @p__linq__0) AND ([Extent1].[kFirma] = @p__linq__1) AND ( EXISTS (SELECT
1 AS [C1]
FROM ( SELECT DISTINCT
[UnionAll1].[kArtikel] AS [C1]
FROM (SELECT
[Extent2].[kArtikel] AS [kArtikel]
FROM [dbo].[tArtikelSpeicher] AS [Extent2]
WHERE ([Extent2].[nID] IN (cast(0 as tinyint), cast(1 as tinyint), cast(2 as tinyint), cast(3 as tinyint), cast(8 as tinyint), cast(5 as tinyint))) AND (( CAST(PATINDEX(@p__linq__2, [Extent2].[cNummer]) AS int)) > 0)
UNION ALL
SELECT
[Extent3].[kArtikel] AS [kArtikel]
FROM [dbo].[tArtikel] AS [Extent3]
WHERE ( CAST(PATINDEX(@p__linq__3, [Extent3].[cSuchbegriffe]) AS int)) > 0) AS [UnionAll1]
) AS [Distinct1]
WHERE [Distinct1].[C1] = [Extent1].[kArtikel]
)) AND (''Y'' = [Extent1].[cIstAktiv]) AND (1 <> [Extent1].[nIstVarkombikind]) AND ([Extent1].[Zustand] = @p__linq__4) AND ([Extent1].[IstStueckliste] <> 1)
) AS [Project5]
ORDER BY [Project5].[kArtikel] ASC option(recompile,maxdop 1);',N'@p__linq__0 int,@p__linq__1 int,@p__linq__2 nvarchar(4000),@p__linq__3 nvarchar(4000),@p__linq__4 int',@p__linq__0=1,@p__linq__1=1,@p__linq__2=N'hummel%%',@p__linq__3=N'hummel%%',@p__linq__4=1
