Volkswagen Passat Variant (3C5) 3.2 FSI V6 32V 4Motion
Używane Modul kamery
Marża € 125,00
Można zamówić bezpośrednio
Rok produkcji2009 |Kod klasyfikacjiC1 |Marka czesciMATSUSHI |Numer artykulu3C0907441Szczegół STAN CZYSTY, UŻYWALNY
Gwarancja 3 mnd
Dostawca Gebr Opdam B.V.
Volkswagen Passat Variant (3C5) 2.0 FSI 16V
Używane Modul kamery
Marża € 125,00
Można zamówić bezpośrednio
Rok produkcji2008 |Kod klasyfikacjiB1 |Marka czesciMATSUSHITA |Numer artykulu3C0907441Szczegół Zobacz obrazki
Gwarancja 3 mnd
Dostawca Carparts Heesch
Volkswagen Passat Variant (3G5) 2.0 TSI 16V
Używane Modul kamery
Marża € 270,00
Można zamówić bezpośrednio
Rok produkcji01-2020 |Numer artykulu5Q0907556CGwarancja 12 mnd
Dostawca Auto Bek
Volkswagen Passat (3G2) 2.0 TDI 16V 150
Używane Modul kamery
Marża € 294,99
Można zamówić bezpośrednio
Rok produkcji02-2016 |Kod klasyfikacjiA2 |Marka czesciVALEO |Numer artykulu5Q0907556Szczegół Gebruikte Camera module in nette staat
Gwarancja 3 mnd
Dostawca Venema Autoparts
Volkswagen Passat Variant (3C5) 2.0 TDI 140
Używane Modul kamery
Marża € 90,00
Można zamówić bezpośrednio
Rok produkcji2006 |Kod klasyfikacjiA2 |Marka czesciMATSUSHITA |Numer artykulu3C0907441Szczegół Module in good condition.
Gwarancja 3 mnd
Dostawca DP Auto-onderdelen & Demontage
Volkswagen Passat (3G2)
Używane Modul kamery
€ 299,00 Z VAT
Można zamówić bezpośrednio
Rok produkcji2020 |Kod klasyfikacjiA1 |Marka czesciVW-AG |Numer artykulu5Q0907556CSzczegół VW Passat B8 Camera Module * 5Q0907556C
Gwarancja 3 mnd
Dostawca FZN Parts
Volkswagen Passat Variant 4Motion (3C5) 3.6 FSI R36 3.6 24V
Używane Modul kamery
Marża € 150,00
Można zamówić bezpośrednio
Rok produkcji2008 |Numer artykulu3C0907441Gwarancja 3 mnd
Dostawca De Witte Boerderij AutoMotive
Volkswagen Passat
Używane Modul kamery
Marża € 125,00
Można zamówić bezpośrednio
Rok produkcji2010 |Kod klasyfikacjiC2 |Marka czesciMATSUSHI |Numer artykulu3C8907441Szczegół CONTROL DEVICE FOR REVERSING CAMERA SYSTEM
Gwarancja 12 mnd
Dostawca Klein Gunnewiek Autodemontage & Motorentechniek
Volkswagen Passat (3G2) 2.0 TDI BiTurbo 16V 4Motion
Używane Modul kamery
€ 250,00 Z VAT
Można zamówić bezpośrednio
Rok produkcji08-2016 |Kod klasyfikacjiA3 |Marka czesciVALEO |Numer artykulu5Q0907556Szczegół zobacz zdjęcie, aby uzyskać szczegółowe informacje
Gwarancja 1 mnd
Dostawca Pijffers B.V. Raalte
Volkswagen Passat
Używane Modul kamery
Marża € 95,00
Można zamówić bezpośrednio
Rok produkcji2009 |Kod klasyfikacjiB2 |Marka czesciMATSUSHI |Numer artykulu3C0907441Szczegół REGELAPPARAAT TBV ACHTERUITRIJCAMERASYSTEEM
Gwarancja 12 mnd
Dostawca Klein Gunnewiek Autodemontage & Motorentechniek
PreLoad
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/volkswagen/model/passat/czesc/modul-kamery/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/volkswagen/model/passat/czesc/modul-kamery/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/volkswagen/model/passat/czesc/modul-kamery/" ], "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/volkswagen/model/passat/czesc/modul-kamery/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/volkswagen/model/passat/czesc/modul-kamery/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/volkswagen/model/passat/czesc/modul-kamery/" ], "UrlSet": false, "Query": "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; IF OBJECT_ID('tempdb..#TD') IS NOT NULL DROP TABLE #TD; CREATE TABLE #TD ([DebtorId] INT PRIMARY KEY NOT NULL); INSERT INTO #TD ([DebtorId]) SELECT DISTINCT [DebiteurId] FROM dbo.[Debiteuren] WHERE [OOL] = 1 AND [OOLGeenVoorraad] = 0 AND [DebiteurId] NOT IN (101190); IF OBJECT_ID('tempdb..#RM') IS NOT NULL DROP TABLE #RM; CREATE TABLE #RM ([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), [RowId] INT PRIMARY KEY CLUSTERED ([RecordId] ASC)) INSERT INTO #RM ([RecordId], [xPR], [xPS], [xPD], [xTP], [xTT], [xShopState], [xShippingState], [xPF], [xPE], [xPI], [RowId]) SELECT [R].[RecordId], [R].[xPR], [R].[xPS], [R].[xPD], [R].[xTP], [R].[xTT], [R].[xShopState], [R].[xShippingState], [R].[xPF], [R].[xPE], [R].[xPI], ROW_NUMBER() OVER (ORDER BY [SortId] DESC, + CASE WHEN [R].[xShopState] = 1 THEN 1 ELSE 0 END DESC, [PartRank] ASC, RIGHT([RecordId], 2)%(DATEPART(WEEKDAY, GETDATE()) + 3) ASC, [R].[RecordId] ASC) AS [RowId] FROM (SELECT [R].[RecordId], [R].[xPR], [R].[xPS], [R].[xPD], [R].[xTP], [R].[xTT], [R].[xShopState], [R].[xShippingState], [R].[xPF], [R].[xPE], [R].[xPI], [R].[SortId], 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 [PartRank] FROM (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], 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 [14] 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 ISNULL([ss].[StateId], 6) END AS [xShopState], xShippingState AS [xShippingState], [R].[SortId], [R].[DebiteurId], [R].[Bouwjaar] AS [12] FROM (SELECT [R].[RecordId] FROM dbo.[OOLInternet] [R] WITH (NOLOCK) WHERE ([R].[ModelId] = '06A45A' OR ([R].[AldocModelCode] IN (32674, 32735, 32811, 32812, 32813, 15067, 11077, 31775, 31776, 31550, 34227, 34228, 33507, 33513, 33604, 33605, 33908, 34077, 34078, 40143, 34537, 56248, 47755, 52497, 52504, 45386, 45393) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (5724, 5725, 5726, 5727, 5728, 5729, 5730, 8440, 9036, 8443, 7941, 10179, 10055, 11542, 15119, 16309, 16306, 16296, 16297, 16307, 16308, 16298, 8439, 7932, 7933, 7934, 7935, 7937, 7939, 8442, 9035, 8444, 10178, 10056, 11543, 15120, 7936, 16313, 16310, 16301, 16302, 16311, 16312, 16299, 1923, 17975, 6261, 1935, 1936, 1922, 18626, 1925, 1926, 1929, 6260, 1930, 1931, 1932, 1934, 1928, 59368, 1933, 1927, 1924, 1921, 16724, 1911, 1912, 1913, 1915, 1916, 1910, 1907, 1906, 1914, 3928, 1920, 1909, 1908, 6263, 1917, 5276, 3935, 3925, 1919, 5944, 11241, 20269, 6246, 1938, 6245, 1939, 1941, 8171, 1942, 1937, 18589, 8172, 158097, 156888, 158096, 156887, 157842, 158527, 158528, 800953, 16035, 15533, 15783, 15784, 15782, 15781, 129490, 17214, 6244, 1689, 6243, 1690, 59415, 1691, 27695, 1688, 18588, 17025, 1708, 5026, 6251, 1718, 1710, 1719, 1720, 1713, 1714, 6262, 1712, 1709, 1717, 1721, 3927, 1715, 1716, 5933, 1711, 5275, 3934, 11240, 20256, 1694, 1693, 1696, 17977, 1699, 1701, 1706, 1707, 18625, 1697, 1702, 1704, 1700, 1705, 1698, 1695, 1692, 16723, 6249, 19485, 19631, 19958, 19630, 24258, 22531, 32791, 19486, 19960, 19703, 19632, 22532, 27542, 32792, 15414, 15532, 15420, 15415, 15417, 15419, 15531, 16346, 129489, 25083, 17406, 17873, 16703, 15421, 15534, 15422, 15423, 15535, 15416, 15418, 22638, 15536, 15787, 15788, 15786, 15785, 129488, 16347, 16036, 61034, 101034, 17215, 17407, 17874, 49771, 18520, 18521, 19395, 18522, 28569, 18523, 19216, 18671, 27547, 19957, 24257, 24259, 27544, 27545, 31106, 27327, 30976, 31109, 31595, 32978, 18726, 18727, 19396, 18728, 5668, 18729, 19200, 18732, 19959, 18730, 18731, 28570, 27540, 27541, 31107, 27543, 30977, 31108, 31596, 32974, 26607, 26608, 28284, 28285, 28283, 26609, 31972, 31974, 32797, 11255, 11258, 11257, 11259, 5025, 6250, 5028, 5027, 5029, 22613, 144807, 116701, 116702, 116703, 116704, 118894, 120892, 134251, 138741, 58530, 58533, 58531, 58532, 29304, 58529, 58534, 106635, 142475, 128973, 142474, 142930, 115193, 115581, 136375, 112386, 801686, 63611, 106611, 42612, 108612, 42615, 108615, 63635, 42613, 108613, 41647, 63654, 106654, 42616, 108616, 46350, 112383, 112387, 112379, 38237, 46353, 118892, 128654, 133867, 134306, 142472, 106644, 142473, 142931, 115194, 136376, 112385, 801687, 42628, 108628, 63613, 106613, 42629, 108629, 63644, 42630, 108630, 63657, 106657, 42631, 108631, 41650, 115584, 46351, 112384, 112388, 112382, 38238, 46352, 118893, 46355, 147324, 133868, 134309, 11228, 294, 296, 214, 10577, 315, 293, 269, 276, 295, 314, 7027, 12010, 56872, 59396, 57298, 356, 11233, 358, 317, 346, 326, 361, 357, 359, 10586, 327, 7033, 12011, 56871, 59387, 57348)))) AND [R].[DeelId] IN ('2580A') AND [R].[DebiteurId] IN (SELECT [DT].[DebtorId] FROM #TD [DT])) [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 dbo.fnGetOOLShippingStateExtendedTVF([R].[DebiteurId], [R].[DebiteurLocatieId], [R].[DeelNr], 616, NULL) [SHS] OUTER APPLY dbo.[fn_OOL_HasPriceInline]([R].[RecordId]) [hp] OUTER APPLY dbo.[fnGetOOLShopStateInline2]([R].[RecordId], [R].[DebiteurId], [R].[Aantal], [R].[QuantityInfinite], [R].[GreenCasionExpiresAt], [R].[Shop], [D].[ShopEnabled], ISNULL([hp].[HasPrice], 0), 1, NULL, NULL, 7, xShippingState) [ss]) [R]) [R]) [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)) [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].* 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], [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], [R].[RowId] FROM (SELECT * FROM (SELECT [R].*, [OV].[VeldId], [OV].[Waarde] FROM (SELECT [RM].[RowId], [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] WHERE [RM].[RowId] BETWEEN 1 AND 10) AS [R] LEFT JOIN dbo.[OOLVelden] [OV] WITH (INDEX(PK_OOLVelden)) ON [OV].[RecordId] = [R].[RecordId] AND [OV].[VeldId] IN (184, 190, 135, 37, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [25])) AS [R]) [R] 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,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] IF OBJECT_ID('tempdb..#RM') IS NOT NULL DROP TABLE #RM; IF OBJECT_ID('tempdb..#TD') IS NOT NULL DROP TABLE #TD;" }, "Gridview": { "Type": "Detailed", "Properties": { "Index": 1, "Size": 10, "Rows": 13, "SizeMax": 150, "SetMax": false, "GetIndexMax": 2, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "24590718": 1, "16029364": 2, "25276340": 3, "23120714": 4, "20189134": 5, "22744147": 6, "8633275": 7, "18417828": 8, "22273840": 9, "18419146": 10 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }