Ford Focus 2 Wagon 1.6 16V
Używane Grill
Marża € 20,00
Można zamówić bezpośrednio
Rok produkcji07-2007 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieKombi |MiejsceFront |Kolor czesciNVT |Numer lakieru czesciNVT |Numer artykulu8C436Szczegół grille
Gwarancja 3 mnd
Dostawca Schaap & Bron
Ford Focus 3 Wagon 1.6 SCTi 16V
Używane Grill
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2012 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieKombi |MiejsceFront |Kolor czesciCZARNY |Numer artykuluBM518A133CSzczegół WIDZIEC ZDJECIE
Gwarancja 3 mnd
Dostawca Autodemontage van de Laar
Ford Focus 3 Wagon 1.6 TDCi ECOnetic
Używane Grill
Marża € 35,00
Można zamówić bezpośrednio
Rok produkcji2013 |Kod klasyfikacjiB1 |Drzwi4Dr |NadwozieKombi |MiejsceFront |Kolor czesciCZARNY |Numer artykulu1719222Szczegół hoogglans zwart. met embleem, lichte krasjes aanwezig
Gwarancja 3 mnd
Dostawca Gebr Opdam B.V.
Ford Focus 2 Wagon 1.8 16V
Używane Grill
Marża € 44,90
Można zamówić bezpośrednio
Rok produkcji09-2009 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieKombi |MiejsceFront |Kolor czesciCZARNY |Numer lakieru czesciH4 |Numer artykulu8M518C436ADSMASSzczegół This part is in neat, usable condition. This part is compatible with multiple models.\ \ Please note: Sometimes multiple parts are shown in the…
Gwarancja 3 mnd
Dostawca Bastiaan Autodemontage
Ford Focus 2 Wagon 1.6 TDCi 16V 110
Używane Grill
Marża € 25,00
Można zamówić bezpośrednio
Rok produkcji2010 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieStacja |MiejsceGóra |Kolor czesciJASNY CZARNY |Numer lakieru czesciNVT |Numer artykulu1704635Gwarancja 6 mnd
Dostawca Auto- en demontagebedrijf Eindewege
Ford Focus 3 1.6 EcoBoost 16V
Używane Grill
Marża € 29,99
Można zamówić bezpośrednio
Rok produkcji2012 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieHatchback |MiejsceSrodek |Kolor czesciCZARNY |Numer lakieru czesciFB |Numer artykuluBM518A133CSzczegół Kleur: FB (Panther Black Metallic) - Kleine beschadiging (zie foto), verder in goede staat. Met Ford logo en chroom randje.
Gwarancja 3 mnd
Dostawca Autodemontage Aandijk
Ford Focus 2 Wagon 1.8 16V Flexifuel
Używane Grill
Marża € 60,00
Można zamówić bezpośrednio
Rok produkcji2009 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieStacja |MiejsceFront |Kolor czesciJASNY CZARNY |Numer lakieru czesciNVVT |Numer artykulu8M518200Szczegół grille
Gwarancja 3 mnd
Dostawca Alexander Autodemontage
Ford Focus 3 Wagon 1.5 TDCi
Używane Grill
Marża € 249,99
Można zamówić bezpośrednio
Rok produkcji05-2016 |Kod klasyfikacjiA1 |Drzwi4Dr |NadwozieStacja |MiejsceFront |Kolor czesciCHROM |Numer artykuluF1EB8200CASzczegół 3 MIESIĄCE GWARANCJI
Gwarancja 3 mnd
Dostawca Autodemontagebedrijf de Jong
Ford Focus 3 Wagon 1.0 Ti-VCT EcoBoost 12V 125
Używane Grill
Marża € 30,00
Można zamówić bezpośrednio
Rok produkcji2013 |Kod klasyfikacjiA2 |Drzwi4Dr |NadwozieStacja |MiejsceZderzak |Kolor czesciCZARNY |Numer artykuluBM518A133CSzczegół zobacz zdjęcie
Gwarancja 3 mnd
Dostawca Carparts Heesch
Ford Focus 3 Wagon 1.6 TDCi ECOnetic
Używane Grill
Marża € 45,00
Można zamówić bezpośrednio
Rok produkcji06-2014 |Kod klasyfikacjiC1 |Drzwi4Dr |NadwozieKombi |MiejsceFront |Kolor czesciCZARNY |Numer artykuluBM6117K945ASzczegół in nette staat, scheurtje in bovenste bevestigingslipje
Gwarancja 3 mnd
Dostawca Bakker Parts
PreLoad
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/" ], "UrlSet": false, "Query": null }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 0, "Size": 10, "Rows": 0, "SizeMax": 150, "SetMax": false, "GetIndexMax": 0, "GetSizeValid": true, "GetIndex": 0, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": {}, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }
All sessions
LoadComplete
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/ford/model/focus/czesc/grill/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; DECLARE @RM TABLE ([RecordId] BIGINT NOT NULL, [xPR] DECIMAL(9, 2), [xPS] BIT NOT NULL, [xPD] INT, [xTP] DECIMAL(5, 2) NOT NULL, [xTT] INT NOT NULL, [xShopState] INT, [xShippingState] TINYINT, [xPF] DECIMAL(9, 2), [xPE] DECIMAL(9, 2), [xPI] DECIMAL(9, 2) PRIMARY KEY CLUSTERED (RecordId ASC)) INSERT INTO @RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [xPF], [xPE], [xPI]) SELECT *, CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 1 THEN CAST([xPF] / ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPE], CASE WHEN [xPF] IS NOT NULL THEN CASE WHEN [xTT] = 0 THEN CAST([xPF] * ((100 + [xTP]) / 100) AS DECIMAL(9, 2)) ELSE [xPF] END END AS [xPI] FROM (SELECT *, CASE WHEN [xPS] = 1 AND [xPR] IS NOT NULL THEN CAST(CASE WHEN [xPD] IS NOT NULL THEN (CAST((100 - ISNULL([xPD], 0)) AS DECIMAL) / 100) * [xPR] ELSE [xPR] END AS DECIMAL(10, 2)) END AS [xPF] FROM (SELECT [R].[RecordId], (ISNULL(CASE WHEN [R].[Shop] = 1 THEN ISNULL([R].[PriceShop],ROUND ( [R].[Prijs] * ((100 + ISNULL([D].[ShopPricePercentage], 0)) / 100), 2)) END, [R].[Prijs])) AS [xPR], CASE WHEN [R].[PrijsTonen] IS NOT NULL THEN [R].[PrijsTonen] WHEN [R].[SoortId] = 0 THEN [D].[OOLPrijzenG] WHEN [R].[SoortId] = 1 THEN [D].[OOLPrijzenR] WHEN [R].[SoortId] = 2 THEN [D].[OOLPrijzenN] ELSE 1 END AS [xPS], (SELECT [T].[Discount] FROM dbo.[AutomatePartDiscount] [T] WHERE [T].[SupplierId] = [R].[DebiteurId] AND [T].[StateId] = [R].[SoortId] AND [T].[PartAutomateId] = [R].[DeelId]) AS [xPD], ISNULL([VT].[General], 21) AS [xTP], CASE WHEN [R].[SoortId] = 0 AND NOT ISNULL([R].[PrijsSoort], 0) = 1 THEN 2 WHEN [D].[OOLPrijzenExcl] = 0 THEN 1 ELSE 0 END AS [xTT], CASE WHEN NOT [D].[ShopActive] = 1 THEN 11 ELSE dbo.fnGetOOLShopStateQuick([R].[RecordId], 1, 7, xShippingState) END AS [xShopState], xShippingState AS [xShippingState] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '02A07X' OR ([R].[AldocModelCode] IN (60884, 60892, 45700, 46066, 46080, 34284, 34166, 34169, 34211, 33202, 33224, 33225, 7962, 7963, 7964, 7965, 7966, 7967, 7968, 7969, 7970, 7971, 7972) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (143404, 143421, 141048, 153469, 151776, 130861, 130862, 132518, 132517, 131284, 131283, 131282, 131166, 134070, 136161, 136164, 141047, 141039, 153471, 151777, 131603, 131604, 132520, 132521, 131647, 131650, 131651, 131602, 135563, 136165, 136163, 141038, 55540, 8027, 8015, 8039, 8017, 8014, 8041, 8058, 8077, 8019, 8022, 11892, 29567, 14799, 29566, 29716, 60022, 100022, 55514, 42575, 108575, 64885, 107885, 64882, 107882, 64880, 107880, 107872, 107871, 42574, 108574, 64871, 64872, 41055, 117983, 129171, 7965, 7966, 7967, 7969, 7970, 7991, 7993, 7997, 8011, 8013, 31181, 31094, 31093, 31095, 117059, 42572, 108572, 42571, 108571, 42570, 108570, 42567, 108567, 108564, 108562, 42562, 42564, 129172, 8096, 107891, 107889, 8111, 8151, 8150, 8165, 8170, 8175, 8204, 8205, 8206, 30637, 30438, 55485, 30437, 30487, 30439, 55511, 143536, 107888, 107886, 42576, 108576, 64892, 107892, 64891, 64889, 64886, 64888, 42577, 108577, 113328, 113330, 113332, 113333, 113336, 113337, 113343, 113344, 143647, 129170, 19522, 19520, 19519, 18305, 18302, 18303, 18304, 18378, 18379, 18934, 18935, 19167, 19264, 10323, 30834, 13389, 33342, 30837, 30405, 33494, 33343, 33346, 10324, 30836, 18513, 18514, 18515, 18516, 18517, 18518, 18519, 18936, 19265, 10304, 10476, 33344, 30407, 33345, 10322, 18959, 18957, 18956, 18953, 18952, 18958, 18955, 18954, 19786, 18275, 30835, 57583, 57584, 30406, 9639, 9640, 9641, 9899, 9900, 14485, 15810, 17012, 16631, 16967, 27581, 133206, 9644, 10040, 9642, 9643, 10041, 15811, 28562, 16969, 9647, 10042, 9645, 9646, 10043, 14486, 15812, 16968, 16970, 27247, 27582)))) AND [R].[DeelId] IN ('0410A') AND [R].[DebiteurId] IN (100001, 100003, 100007, 100008, 100012, 100019, 100022, 100029, 100034, 100044, 100045, 100056, 100062, 100081, 100085, 100086, 100107, 100109, 100110, 100116, 100119, 100120, 100121, 100124, 100129, 100131, 100139, 100141, 100145, 100152, 100153, 100155, 100159, 100160, 100161, 100177, 100178, 100180, 100181, 100184, 100187, 100189, 100191, 100194, 100197, 100208, 100209, 100216, 100219, 100232, 100238, 100248, 100249, 100251, 100255, 100261, 100278, 100282, 100283, 100284, 100291, 100294, 100305, 100307, 100315, 100324, 100327, 100328, 100336, 100345, 100353, 100358, 100359, 100378, 100385, 100386, 100414, 100417, 100426, 100433, 100457, 100471, 100473, 100480, 100493, 100509, 100512, 100515, 100617, 100727, 100771, 100803, 100805, 100883, 100886, 100997, 101112, 101113, 101114, 101115, 101117, 101118, 101119, 101120, 101121, 101122, 101175, 101185, 101186, 101205, 101209, 101221, 101222, 101232, 101234, 101237, 101238, 101239, 101240, 101249, 101255, 101257, 101262, 101268, 101269, 101271, 101273, 101275, 101276, 101277, 101279, 101280, 101285, 101293, 101300, 101301, 101302, 101304, 101305, 101309, 101311, 101313, 101314, 101315, 101317, 101319, 101321, 101328, 101331, 101332, 101334, 101335, 101337, 101340, 101342, 101343, 101344, 101345, 101348, 101349, 101352, 101353, 101355, 101356, 101361, 101362, 101363, 101365, 101366, 101368, 101369, 101370, 101371, 101374, 101385, 101387, 101390, 101391, 101394, 101395, 101396, 101397, 101398, 101400, 101401, 101403, 101405, 101406, 101407, 101408, 101412, 101413, 101414, 101415, 101417, 101418, 101420, 101422, 101423, 101424, 101425, 101429, 101432, 101433, 101434, 101436, 101438, 101441, 101442, 111111, 123456, 123457, 123462)) [RM] LEFT JOIN dbo.[OOLInternet] [R] ON [R].[RecordId] = [RM].[RecordId] LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1) LEFT JOIN [Basis].dbo.[CountryVatRate] [VT] ON [VT].[CountryId] = [D].[LandId] AND [VT].[Active] = 1 OUTER APPLY (SELECT dbo.fnGetOOLShippingStateExtended([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 616, NULL) [xShippingState]) [SHS]) [R]) [R]; SELECT [R].[DeelId], [R].[SoortId], COUNT(*) AS [Aantal] FROM (SELECT [R].[DeelId], [R].[SoortId], [R].[RecordId], [R].[DebiteurId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) [R] GROUP BY [R].[DeelId], [R].[SoortId]; SELECT [R].*, [xTP] AS [PrijsTaxPerc], [xPD] AS [PrijsKorting], (SELECT [VIBM].[Bouwmaand] FROM dbo.[VOLInternet] [VIBM] WHERE [VIBM].[RecordId] = [R].[AutoRecordId]) AS [ConstructionMonth], [xPE] AS [PrijsAlt], STUFF((SELECT '|' + CAST([V].[VeldId] AS VARCHAR(10)) + '^' + [V].[Waarde] FROM (SELECT [V].[VeldId], [V].[Waarde], [V].[OrderId] FROM dbo.[OOLVelden] [V] WHERE [V].[RecordId] = [R].[RecordId] AND [V].[VeldId] IN (26, 232)) [V] ORDER BY [V].[VeldId], [V].[OrderId] FOR XML PATH('')), 1, 1, '') AS [Automate2Velden], CASE WHEN [R].[GarantieToelichting] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 2) AND [TV].[LanguageId] IN (7, 2, 1) ORDER BY [TV].[LanguageId] DESC) END AS [GarantieTranslated], CASE WHEN [R].[BijzonderheidInet] IS NOT NULL THEN (SELECT TOP 1 [TV].[Translation] FROM [Storage].dbo.[TranslateTextResult] [TV] WHERE [TV].[TextId] = (SELECT [TR].[TextId] FROM [Storage].dbo.[TranslateTextRecord] [TR] WHERE [TR].[RecordId] = [R].[RecordId] AND [TR].[TextTypeId] = 1) AND [TV].[LanguageId] IN (7, 2, 1) ORDER BY [TV].[LanguageId] DESC) END AS [BijzonderheidInetTranslated], [xShopState] AS [ShopState], CASE WHEN [R].[AldocModelCode] IS NOT NULL THEN (SELECT ISNULL((STUFF((SELECT '^' + [T3].[NaamInternet] + '~' + [T2].[NaamInternet] FROM [Basis].dbo.[AutomateModellenTranslated] [T2] LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [T3] ON [T3].[MerkId] = [T2].[MerkId] AND [T3].[LanguageId] = 7 WHERE [T2].[ModelId] IN (SELECT [T].[ModelId] FROM [Basis].dbo.[AldocModelKoppelingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode]) AND [T2].[LanguageId] = 7 AND [T2].[Synoniem] = 0 FOR XML PATH('')), 1, 1,'')), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocModelOmschrijvingen] [T] WHERE [T].[ModelCode] = [R].[AldocModelCode] AND [T].[LanguageId] = 7), '') + '|' + ISNULL((SELECT [T].[Omschrijving] FROM [Basis].dbo.[AldocTypeOmschrijvingen] [T] WHERE [T].[TypeId] = [R].[AldocTypeId] AND [T].[LanguageId] = 7), '')) END AS [AldocDescription] FROM (SELECT [R].*, ROW_NUMBER() OVER (PARTITION BY R.SortId, R.DebiteurId ORDER BY SortId + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, CASE WHEN [12] IS NULL THEN 1 END ASC, [12] DESC, CASE WHEN [14] IS NULL THEN 1 END ASC, [14] ASC, RIGHT([RecordId], 2)%(DATEPART(WEEKDAY, GETDATE()) + 3) ASC, [RecordId] ASC) AS [RowId] FROM (SELECT [R].[SortId], [R].[RecordId], [R].[DebiteurId], [R].[ExternalId], [R].[ReferenceId], [R].[Youtube] AS [181], [184], [190], ISNULL([R].[Fotos], (SELECT 'G^' + CAST([G].[GroupId] AS VARCHAR(20)) + '^' + [G].[Images] FROM dbo.[OOLFotoGroups] [G] WHERE [G].[DebiteurId] = [R].[DebiteurId] AND [G].[SModelId] = [R].[SModelId] AND [G].[DeelId] = [R].[DeelId])) AS [58], [R].[SoortId] AS [StateId], CASE WHEN SUBSTRING([R].[ModelId], 1, 3) IN ('00X', '0XX') THEN NULL ELSE [MET].[NaamInternet] + '^' + [MOT].[NaamInternet] END AS [MakeModel], [xPS] AS [PrijsTonen], CASE WHEN [xTT] IN (0, 1) THEN 1 ELSE [xTT] END AS [PrijsTaxType], [xPI] AS [14], [R].[Bouwjaar] AS [12], [R].[AutoRecordId], CASE WHEN [135] IS NULL THEN CASE WHEN [R].[SoortId] = 0 THEN [D].[OOLGarantieG] WHEN [R].[SoortId] = 1 THEN [D].[OOLGarantieR] WHEN [R].[SoortId] = 2 THEN [D].[OOLGarantieN] ELSE NULL END ELSE [135] END AS [135], [37], CASE WHEN [22] = '2' THEN '2Dr' WHEN [22] = '4' THEN '4Dr' WHEN ISNULL([22], '') = '' THEN NULL ELSE [22] END AS [22], [V23].[NaamLang] AS [23], CASE WHEN [20] = 'A' THEN 'Brama tylna' WHEN [20] = 'O' THEN 'Dól' WHEN [20] = 'S' THEN 'Ekran' WHEN [20] = 'V' THEN 'Front' WHEN [20] = 'BO' THEN 'Góra' WHEN [20] = 'L' THEN 'Linki' WHEN [20] = 'BU' THEN 'Na zewnatrz' WHEN [20] = '-' THEN 'Nie dot.' WHEN [20] = 'R' THEN 'Prawy' WHEN [20] = 'M' THEN 'Srodek' WHEN [20] = 'AC' THEN 'Tył' WHEN [20] = 'BI' THEN 'Wewnatrz' WHEN [20] = 'BP' THEN 'Zderzak' WHEN ISNULL([20], '') = '' THEN NULL ELSE [20] END AS [20], CASE WHEN [35] IS NOT NULL THEN ISNULL(STUFF((SELECT '^' + [KT].[Naam] FROM dbo.[OOLKleuren] [RK] LEFT JOIN [Basis].dbo.[KleurenTranslated] [KT] ON [KT].[ColorId] = [RK].[ColorId] AND [KT].[LanguageId] = 7 WHERE [RK].[RecordId] = [R].[RecordId] AND [RK].[VeldID] = 35 ORDER BY [RK].[OrderId] FOR XML PATH('')),1,1,'') + '|', '') + STUFF((SELECT '|' + [XOV].[Waarde] FROM dbo.[OOLVelden] [XOV]\t\t\t\t\t\t WHERE [XOV].[RecordId] = [R].[RecordId] AND [XOV].[VeldId] = 35 ORDER BY [XOV].[OrderId] FOR XML PATH('')), 1, 1, '') END AS [35], [138], [25], [R].[Artikelnummers] AS [21], ISNULL([D].[Bedrijfsnaam], '') + '|' + ISNULL([D].[BedrijfKort], '') AS [Leverancier], [R].[BijzonderheidInet], [R].[WarrantyText] AS [GarantieToelichting], [R].[Shop], [R].[Created], [xShippingState] AS [ShippingState], [R].[WarrantyConstruction] AS [WarrantyInstallation], [R].[DeelId], [R].[DebiteurRecordId], [R].[AldocModelCode], [R].[AldocTypeId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState], [R].[SModelId], [R].[ModelId], [R].[PrijsSoort], [R].[PriceShop] FROM (SELECT * FROM (SELECT [R].*, [OV].[VeldId], [OV].[Waarde] FROM (SELECT [R].[SortId], [R].[RecordId], [R].[DebiteurId], [R].[ExternalId], [R].[ReferenceId], [R].[Youtube], [R].[Fotos], [R].[SoortId], [R].[PrijsTonen], [R].[Prijs], [R].[Bouwjaar], [R].[AutoRecordId], [R].[Artikelnummers], [R].[BijzonderheidInet], [R].[WarrantyText], [R].[Shop], [R].[Created], [R].[WarrantyConstruction], [R].[DeelId], [R].[DebiteurRecordId], [R].[AldocModelCode], [R].[AldocTypeId], [R].[DebiteurLocatieId], [R].[SModelId], [R].[ModelId], [R].[PrijsSoort], [R].[PriceShop], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId]) AS [R] LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 22, 23, 20, 35, 138, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [22], [23], [20], [35], [138], [25])) AS [R]) [R] LEFT JOIN [Basis].dbo.[AutomateVeldWaardenTranslated] [V23] ON [V23].[VeldId] = 23 AND [V23].[Waarde] = [23] AND [V23].[LanguageId] = 7 LEFT JOIN [Basis].dbo.[AutomateModellenTranslated] [MOT] ON [MOT].[ModelId] = [R].[ModelID] AND [MOT].[LanguageId] = 7 AND [MOT].[Synoniem] = 0 LEFT JOIN [Basis].dbo.[AutomateMerkenTranslated] [MET] ON [MET].[MerkId] = [MOT].[MerkId] AND [MET].[LanguageId] = 7 LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) [R] ORDER BY [SortId] DESC, + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [RowId] ASC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY) [R]; WITH [R] AS (SELECT [R].[RecordId], [xPR], [xPF], [xPD], [xPS], [xPE], [xPI], [xTP], [xTT], [xShopState], [xShippingState], [Bouwjaar], [xPI] AS [Prijs], [ModelId] FROM @RM [RM] LEFT JOIN dbo.[OOLInternet] [R] With (NOLOCK FORCESEEK) On [R].[RecordId] = [RM].[RecordId] LEFT JOIN dbo.[DebiteurLocatieData] [D] ON [D].[DebiteurId] = [R].[DebiteurId] AND [D].[LocatieId] = ISNULL([R].[DebiteurLocatieId], 1)) SELECT [VeldId], [Waarde] AS [Value], NULL AS [ValueMIN], NULL AS [ValueMAX] FROM dbo.[OOLVelden] [OV] WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (184,190,37,22,23,20,35,138,25) GROUP BY [VeldId], [Waarde] UNION SELECT [VeldId], NULL AS [Value], MIN([Waarde]) AS [ValueMIN], MAX([Waarde]) AS [ValueMAX] FROM (SELECT [VeldId], TRY_CAST([Waarde] AS INT) AS [Waarde] FROM dbo.[OOLVelden] [OV] WHERE [RecordId] IN (SELECT [R].[RecordId] FROM [R]) AND [VeldId] IN (135)) [OV] GROUP BY [VeldId] UNION SELECT 12, NULL AS [Value], MIN([R].[Bouwjaar]) AS [ValueMIN], MAX([R].[Bouwjaar]) AS [ValueMAX] FROM [R] UNION SELECT 14, NULL AS [Value], MIN(CAST([Prijs] AS INT)) AS [ValueMIN], MAX(CAST([Prijs] AS INT)) AS [ValueMAX] FROM [R] ORDER BY 1, 2; SELECT DISTINCT [R].[DebiteurId] FROM (SELECT DISTINCT [DebiteurId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE [R].[RecordId] In (Select [RM].[RecordId] FROM @RM [RM])) [R]" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 232, "SizeMax": 150, "SetMax": false, "GetIndexMax": 24, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "25696042": 1, "24856244": 1, "22852008": 1, "23326781": 1, "19290348": 1, "19867003": 1, "17258049": 1, "24531687": 1, "15162154": 1, "24228668": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }