#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTI3M3x8bWRmX2lkPT0wXjg0MDB8fHNwYXJlX2lkPT0xMDI2OTE%3D&st=50 SELECT CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id, d.`Description` AS crit_designation, dv.`DisplayValue` AS crit_value, "" crit_unit, 2 criteria_art, "articletypes" as source FROM articlepassengercars av JOIN passengercarlinkageattributes_ru vla ON av.Idx = vla.Idx JOIN linkageattributedescriptions d ON vla.DescriptionIdx = d.Idx JOIN linkageattributedisplayvalues dv ON vla.DisplayValueIdx = dv.Idx WHERE av.VehicleID = "8400" AND ( (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "A1.4415" AND av.ProductID IN (1561,1561)) OR (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "A1.4414" AND av.ProductID IN (1561,1561)) OR (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "AV862" AND av.ProductID IN (1561)) OR (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "AV863" AND av.ProductID IN (1561)) OR (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "AV864" AND av.ProductID IN (1561)) OR (av.SupplierID = 4528 AND av.DataSupplierArticleNumber = "AV861" AND av.ProductID IN (1561)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6060-00-PE4414" AND av.ProductID IN (1561)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6060-00-PE4415" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037632" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037304" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037301" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037058" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037633" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037305" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037302" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037059" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037634" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037631" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037303" AND av.ProductID IN (1561)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "037300" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110084" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110081" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100534" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100015" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110085" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110082" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100535" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100016" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110086" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "110083" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100536" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "100533" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0380" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0379" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG20 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "AL5083" AND av.ProductID IN (2063)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG19 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG22 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG19 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG22 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR PG20 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1120L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1118R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1120R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1119L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1119R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL1118L" AND av.ProductID IN (1561)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "490301" AND av.ProductID IN (1561)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "490300" AND av.ProductID IN (1561)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "55131801" AND av.ProductID IN (1561)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "55131802" AND av.ProductID IN (1561)) OR (av.SupplierID = 4572 AND av.DataSupplierArticleNumber = "WPG111-R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4572 AND av.DataSupplierArticleNumber = "WPG111-L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG22 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG20 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "AL5083" AND av.ProductID IN (2063)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG20 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG19 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG22 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT PG19 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103134000" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103121100" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103135000" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103121200" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103136000" AND av.ProductID IN (1561)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350103133000" AND av.ProductID IN (1561)) OR (av.SupplierID = 4721 AND av.DataSupplierArticleNumber = "30/864" AND av.ProductID IN (1561)) OR (av.SupplierID = 4721 AND av.DataSupplierArticleNumber = "30/861" AND av.ProductID IN (1561)) OR (av.SupplierID = 4721 AND av.DataSupplierArticleNumber = "30/862" AND av.ProductID IN (1561)) OR (av.SupplierID = 4721 AND av.DataSupplierArticleNumber = "30/863" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62096 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62094 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62094 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62092 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "AL5083" AND av.ProductID IN (2063)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62096 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "62092 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "PG039W025" AND av.ProductID IN (1561)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "PG039W026" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "960011" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "960008" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "960009" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "960010" AND av.ProductID IN (1561)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "118306" AND av.ProductID IN (1561)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "118307" AND av.ProductID IN (1561)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "118304" AND av.ProductID IN (1561)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "118557" AND av.ProductID IN (1561)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "118305" AND av.ProductID IN (1561)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V42-0340" AND av.ProductID IN (1561)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V42-0341" AND av.ProductID IN (1561)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "850318" AND av.ProductID IN (1561)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "850319" AND av.ProductID IN (1561)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "4036264" AND av.ProductID IN (1561)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "4036263" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2361RM" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2360LM" AND av.ProductID IN (1561)) ) UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes" as source FROM articleattributes aa WHERE ( (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "A1.4415") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "A1.4414") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV862") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV863") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV864") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV861") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6060-00-PE4414") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6060-00-PE4415") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037632") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037304") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037301") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037058") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037633") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037305") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037302") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037059") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037634") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037631") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037303") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037300") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110084") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110081") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100534") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100015") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110085") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110082") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100535") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100016") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110086") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110083") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100536") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100533") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0380") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0379") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG20 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG19 L") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG22 L") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG19 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG22 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG20 L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1120L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1118R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1120R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1119L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1119R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1118L") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490301") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490300") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "55131801") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "55131802") OR (aa.SupplierID = 4572 AND aa.DataSupplierArticleNumber = "WPG111-R") OR (aa.SupplierID = 4572 AND aa.DataSupplierArticleNumber = "WPG111-L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG22 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG20 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG20 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG19 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG22 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG19 R") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103134000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103121100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103135000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103121200") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103136000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103133000") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/864") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/861") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/862") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/863") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62096 R") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62094 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62094 R") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62092 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62096 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62092 R") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "PG039W025") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "PG039W026") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960011") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960008") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960009") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960010") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118306") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118307") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118304") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118557") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118305") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V42-0340") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V42-0341") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "850318") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "850319") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4036264") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4036263") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2361RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2360LM") ) AND aa.Language = "ru" UNION ALL SELECT CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber) as article_id, if (aa.Description = "", aa.DisplayTitle, aa.Description) as crit_designation, aa.DisplayValue as crit_value, "" crit_unit, 1 criteria_art, "articleattributes_2018_2" as source FROM articleattributes_2018_2 aa WHERE ( (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "A1.4415") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "A1.4414") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV862") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV863") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV864") OR (aa.SupplierID = 4528 AND aa.DataSupplierArticleNumber = "AV861") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6060-00-PE4414") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6060-00-PE4415") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037632") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037304") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037301") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037058") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037633") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037305") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037302") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037059") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037634") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037631") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037303") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "037300") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110084") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110081") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100534") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100015") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110085") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110082") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100535") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100016") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110086") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "110083") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100536") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "100533") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0380") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0379") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG20 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG19 L") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG22 L") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG19 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG22 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR PG20 L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1120L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1118R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1120R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1119L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1119R") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL1118L") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490301") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490300") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "55131801") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "55131802") OR (aa.SupplierID = 4572 AND aa.DataSupplierArticleNumber = "WPG111-R") OR (aa.SupplierID = 4572 AND aa.DataSupplierArticleNumber = "WPG111-L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG22 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG20 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG20 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG19 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG22 L") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT PG19 R") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103134000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103121100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103135000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103121200") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103136000") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350103133000") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/864") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/861") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/862") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "30/863") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62096 R") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62094 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62094 R") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62092 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "AL5083") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62096 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "62092 R") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "PG039W025") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "PG039W026") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960011") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960008") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960009") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "960010") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118306") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118307") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118304") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118557") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "118305") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V42-0340") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V42-0341") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "850318") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "850319") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4036264") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4036263") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2361RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2360LM") ) AND aa.Language = "ru" Продажа автозапчастей типа Подъемное устройство для окон для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Ac Rolcar A1.4415 Подъемное устройство для окон
A1.4414 Подъемное устройство для окон
AD KÜHNER AV862 Подъемное устройство для окон
AV863 Подъемное устройство для окон
AV864 Подъемное устройство для окон
AV861 Подъемное устройство для окон
BLIC 6060-00-PE4414 Подъемное устройство для окон
6060-00-PE4415 Подъемное устройство для окон
CAUTEX 037632 Подъемное устройство для окон
037304 Подъемное устройство для окон
037301 Подъемное устройство для окон
037058 Подъемное устройство для окон
037633 Подъемное устройство для окон
037305 Подъемное устройство для окон
037302 Подъемное устройство для окон
037059 Подъемное устройство для окон
037634 Подъемное устройство для окон
037631 Подъемное устройство для окон
037303 Подъемное устройство для окон
037300 Подъемное устройство для окон
DOGA 110084 Подъемное устройство для окон
110081 Подъемное устройство для окон
100534 Подъемное устройство для окон
100015 Подъемное устройство для окон
110085 Подъемное устройство для окон
110082 Подъемное устройство для окон
100535 Подъемное устройство для окон
100016 Подъемное устройство для окон
110086 Подъемное устройство для окон
110083 Подъемное устройство для окон
100536 Подъемное устройство для окон
100533 Подъемное устройство для окон
Dr!ve+ DP3210.10.0380 Подъемное устройство для окон
DP3210.10.0379 Подъемное устройство для окон
ELECTRIC LIFE ZR PG20 R Подъемное устройство для окон
AL5083 Ручка стеклоподъемника
ZR PG19 L Подъемное устройство для окон
ZR PG22 L Подъемное устройство для окон
ZR PG19 R Подъемное устройство для окон
ZR PG22 R Подъемное устройство для окон
ZR PG20 L Подъемное устройство для окон
ELTA AUTOMOTIVE WRL1120L Подъемное устройство для окон
WRL1118R Подъемное устройство для окон
WRL1120R Подъемное устройство для окон
WRL1119L Подъемное устройство для окон
WRL1119R Подъемное устройство для окон
WRL1118L Подъемное устройство для окон
ERA 490301 Подъемное устройство для окон
490300 Подъемное устройство для окон
KLOKKERHOLM 55131801 Подъемное устройство для окон
55131802 Подъемное устройство для окон
LECOY WPG111-R Подъемное устройство для окон
WPG111-L Подъемное устройство для окон
LIFT-TEK LT PG22 R Подъемное устройство для окон
LT PG20 L Подъемное устройство для окон
AL5083 Ручка стеклоподъемника
LT PG20 R Подъемное устройство для окон
LT PG19 L Подъемное устройство для окон
LT PG22 L Подъемное устройство для окон
LT PG19 R Подъемное устройство для окон
MAGNETI MARELLI 350103134000 Подъемное устройство для окон
350103121100 Подъемное устройство для окон
350103135000 Подъемное устройство для окон
350103121200 Подъемное устройство для окон
350103136000 Подъемное устройство для окон
350103133000 Подъемное устройство для окон
MIRAGLIO 30/864 Подъемное устройство для окон
30/861 Подъемное устройство для окон
30/862 Подъемное устройство для окон
30/863 Подъемное устройство для окон
PMM 62096 R Подъемное устройство для окон
62094 L Подъемное устройство для окон
62094 R Подъемное устройство для окон
62092 L Подъемное устройство для окон
AL5083 Ручка стеклоподъемника
62096 L Подъемное устройство для окон
62092 R Подъемное устройство для окон
PRASCO PG039W025 Подъемное устройство для окон
PG039W026 Подъемное устройство для окон
SEIM 960011 Подъемное устройство для окон
960008 Подъемное устройство для окон
960009 Подъемное устройство для окон
960010 Подъемное устройство для окон
TRICLO 118306 Подъемное устройство для окон
118307 Подъемное устройство для окон
118304 Подъемное устройство для окон
118557 Подъемное устройство для окон
118305 Подъемное устройство для окон
VAICO V42-0340 Подъемное устройство для окон
V42-0341 Подъемное устройство для окон
VALEO 850318 Подъемное устройство для окон
850319 Подъемное устройство для окон
VAN WEZEL 4036264 Подъемное устройство для окон
4036263 Подъемное устройство для окон
WAI WPR2361RM Подъемное устройство для окон
WPR2360LM Подъемное устройство для окон
2026 CATCAR.INFO (v 2.0)