Opel Astra J GTC (PD2/PF2) 2.0 CDTI 16V ecoFLEX
Używane Element grzewczy
Marża € 40,00
Można zamówić bezpośrednio
Rok produkcji12-2011 |KlimatyzacjaTak |Marka czesciBEHR |Numer artykuluR0319001Gwarancja 3 mnd
Dostawca Westerhof autodemontage
Opel Astra J Sports Tourer (PD8/PE8/PF8) 1.7 CDTi 16V
Używane Element grzewczy
Marża € 51,70
Można zamówić bezpośrednio
Rok produkcji2011 |Kod klasyfikacjiA1 |KlimatyzacjaKlimatyzacja |Marka czesciBEHR |Numer artykulu13276271Szczegół GEBRUIKT GETEST, KACHEL VERWARMINGSELEMENT BEHR, ZIE FOTO BTW-factuur met 10% korting mogelijk, montage is ook mogelijk.
Gwarancja 3 mnd
Dostawca Gerrits Automotive BV
Opel Astra H (L48) 1.8 16V
Używane Element grzewczy
Marża € 20,00
Można zamówić bezpośrednio
Rok produkcji03-2008 |Kod klasyfikacjiA2 |KlimatyzacjaKlimatyzacja |Numer artykulu52421335Szczegół zobacz zdjęcie
Gwarancja 3 mnd
Dostawca Autorec. Gebr. Prins b.v.
Opel Astra L Sports Tourer (F4/FC/FN/FR) 1.5 Diesel 16V
Używane Element grzewczy
Marża € 50,00
Można zamówić bezpośrednio
Rok produkcji08-2023 |Kod klasyfikacjiB2 |KlimatyzacjaTak |Marka czesciVALEO |Numer artykuluT79743COFGwarancja 3 mnd
Dostawca Autobedrijf Broekhuis B.V.
Opel Astra K 1.4 Turbo 16V
Używane Element grzewczy
Marża € 75,00
Można zamówić bezpośrednio
Rok produkcji2020 |Kod klasyfikacjiA1 |KlimatyzacjaTak |Marka czesciMAHLE |Numer artykulu13537150Szczegół Zobacz obrazki
Gwarancja 3 mnd
Dostawca Carparts Heesch
Opel Astra K 1.4 Turbo 16V
Używane Element grzewczy
€ 60,50 Z VAT
Można zamówić bezpośrednio
Rok produkcji05-2016 |Kod klasyfikacjiB2 |KlimatyzacjaTak |Numer artykulu13598154Szczegół REMOTE CONTROLLER (FOR DUAL ZONE CLIMATE CONTROL,RPO CJ2)
Gwarancja 3 mnd
Dostawca SP Parts
Opel Astra H GTC (L08) 1.7 CDTi 16V
Używane Element grzewczy
Marża € 35,00
Można zamówić bezpośrednio
Rok produkcji2009 |Kod klasyfikacjiB2 |KlimatyzacjaTak(pusty) |Marka czesciBEHR |Numer artykulu082880534Gwarancja 3 mnd
Dostawca Autobedrijf Broekhuis B.V.
Opel Astra J Sports Tourer (PD8/PE8/PF8) 1.6 CDTI 16V
Używane Element grzewczy
Marża € 15,00
Można zamówić bezpośrednio
Rok produkcji2015 |KlimatyzacjaKlimatyzacja |Numer artykulu13435154Szczegół zobacz zdjęcie
Gwarancja 3 mnd
Dostawca Van Leeuwen Auto Onderdelen
Opel Astra H GTC (L08) 2.0 16V Turbo
Używane Element grzewczy
Marża € 40,00
Można zamówić bezpośrednio
Rok produkcji2006 |KlimatyzacjaTak |Marka czesciBEHR |Numer artykulu13204091Szczegół MET REGELEENHEID (VOOR QUICKHEAT-SYSTEEM)
Gwarancja 12 mnd
Dostawca Auto Demontage Elferink B.V.
Opel Astra H GTC (L08) 1.7 CDTi 16V
Używane Element grzewczy
Marża € 50,00
Można zamówić bezpośrednio
Rok produkcji2009 |KlimatyzacjaKlimatyzacja |Numer artykulu83540153Gwarancja 12 mnd
Dostawca Auto Demontage Elferink B.V.
PreLoad
{ "Data": { "SessionId": 1, "Match": null, "Timestamp": "0001-01-01T00:00:00", "UrlRawCurrent": "/magazyn-czesci/magazyn/marka/opel/model/astra/czesc/element-grzewczy/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/opel/model/astra/czesc/element-grzewczy/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/opel/model/astra/czesc/element-grzewczy/" ], "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/opel/model/astra/czesc/element-grzewczy/", "UrlAbsoluteCurrent": "/url_voorraad/magazyn-czesci/magazyn/marka/opel/model/astra/czesc/element-grzewczy/", "UrlAbsoluteReferer": "", "UrlReferers": [ "/magazyn-czesci/magazyn/marka/opel/model/astra/czesc/element-grzewczy/" ], "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] = '05A20A' OR ([R].[AldocModelCode] IN (34336, 33991, 33992, 33993, 34234, 33191, 33192, 33215, 33304, 33490, 32595, 32596, 32597, 57692, 54914, 55690, 46125, 48986, 44155, 46173, 42825, 42953, 10452, 31802, 13967, 15737, 5076, 6109, 2205) OR [R].[RecordId] IN (SELECT K.RecordId FROM dbo.OOLKTyp K WITH (NOLOCK) WHERE K.KTyp IN (10725, 10727, 10882, 10726, 10723, 10724, 59269, 59270, 18295, 18296, 18298, 32003, 18297, 18299, 18301, 19988, 18300, 19331, 18294, 19287, 19428, 19464, 22680, 22679, 22687, 22690, 9948, 17844, 17845, 17846, 17899, 17847, 17848, 18072, 18244, 19116, 19113, 18064, 19119, 9956, 19427, 19117, 22682, 22676, 22686, 22689, 28009, 9949, 18073, 18074, 18075, 18078, 18079, 18080, 18076, 18245, 19115, 18077, 19120, 9156, 19118, 20010, 22683, 22678, 22688, 22691, 28508, 6044, 5573, 18951, 18950, 18949, 18948, 18947, 19362, 22684, 22677, 8994, 8995, 8996, 8997, 8999, 8993, 8998, 10163, 13742, 13365, 13860, 15776, 15337, 15338, 15339, 17247, 16973, 17245, 17246, 16830, 23659, 23658, 55912, 132619, 132648, 9001, 9002, 9003, 9004, 9006, 9005, 10166, 14181, 14182, 9000, 15343, 15344, 15345, 15778, 17252, 16975, 17250, 17099, 17251, 16736, 23660, 132620, 132649, 132652, 145341, 9983, 9984, 9985, 9986, 9987, 10167, 13743, 10164, 13861, 10165, 15340, 15341, 15342, 15777, 16974, 17248, 17249, 23685, 55911, 132644, 12319, 17095, 14685, 14684, 16972, 9695, 18559, 17253, 14158, 15758, 15756, 15757, 16371, 16971, 17712, 17254, 3879, 1798, 1803, 1810, 1807, 8899, 1812, 1814, 1815, 1818, 1796, 1792, 3868, 5534, 4652, 9350, 16118, 15238, 16127, 16121, 1794, 15239, 15240, 3880, 4995, 1806, 1816, 5537, 5538, 4653, 3878, 1823, 1824, 1826, 1825, 8901, 1827, 1828, 1829, 1830, 1822, 1820, 4093, 5536, 1831, 16119, 15241, 16128, 16122, 1821, 15242, 15243, 119555, 119554, 119557, 119559, 119558, 115671, 115672, 117717, 128043, 115673, 41738, 41742, 115676, 115675, 115686, 41737, 115669, 115674, 117726, 41741, 128802, 133203, 132193, 137731, 137730, 137729, 137735, 137734, 137733, 117720, 117724, 117723, 40875, 117721, 40879, 117725, 40881, 117727, 117718, 117722, 117719, 40874, 40877, 128814, 133204, 132194, 137739, 137738, 137737, 137736, 137741, 137740, 9248, 9243, 9249, 9250, 9246, 9247, 9244, 56007, 144388, 55379, 55382, 55380, 55385, 55384, 57435, 55381, 55383, 56774, 60492, 100492, 62581, 105581, 64481, 107481, 132555, 125949, 850, 908, 853, 927, 986, 992, 1021, 1026, 884, 9697, 12033, 12088, 13949, 57395, 57436, 56864, 60493, 100493, 60855, 100855, 117858, 13951, 10474, 10458, 10475, 10457, 13953, 55089, 13954, 13952, 57391, 57434, 53385, 64480, 107480, 64479, 107479, 30474, 30933, 30934, 30935, 33843, 59258, 132595, 132594, 32093, 32087, 32089, 32092, 32091, 32090, 32086, 32085, 32088, 9160, 10445, 13950, 12087, 57392, 57432, 60491, 100491, 60854, 100854, 14471, 14472, 14470, 15855, 107604, 132001, 60905, 100905, 64604, 1797, 1819, 1817, 1791, 1805, 1809, 1813, 1793, 1811, 4743, 1808, 8900, 4654, 3877, 3869, 5533, 16117, 15230, 16126, 16120, 1795, 15236, 15237, 146516, 146536, 146535, 146537, 154846, 156251, 157953, 801818, 802246, 145829, 145815, 145817, 145814, 146515, 145813, 151778, 154645, 157952, 801817, 802247)))) AND [R].[DeelId] IN ('4385B') 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, 101444, 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)) [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 [123] = 'C' THEN 'Klimatyzacja' WHEN [123] = 'N' THEN 'Nie' WHEN [123] = 'H' THEN 'Ster. reczne' WHEN [123] = 'J' THEN 'Tak' WHEN [123] = 'L' THEN 'Tak(pusty)' WHEN ISNULL([123], '') = '' THEN NULL ELSE [123] END AS [123], [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, 123, 25)) [R] PIVOT (MAX([Waarde]) FOR [VeldId] IN ([184], [190], [135], [37], [123], [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,123,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": 18, "SizeMax": 150, "SetMax": false, "GetIndexMax": 2, "GetSizeValid": true, "GetIndex": 1, "GetQuery": { "Min": 1, "Max": 10, "Rows": 10, "Offset": 0 } }, "Rows": { "19151179": 1, "13938748": 1, "21867336": 1, "23174102": 1, "17063258": 1, "25724644": 1, "23952862": 2, "23612979": 1, "12764388": 1, "10572335": 1 }, "Sort": "", "SortDirection": "Ascending", "CountryName": "Polska", "CountryId": 616, "Remarks": true, "Images": true, "Distance": false, "Zipcode": "", "UseSortPartitioning": true } }