#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM0MDZ8fG1kZl9pZD09MF45MDA0fHxzcGFyZV9pZD09MTAwMzM3&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 = "9004" AND ( (av.SupplierID = 4654 AND av.DataSupplierArticleNumber = "330151" AND av.ProductID IN (508)) OR (av.SupplierID = 4654 AND av.DataSupplierArticleNumber = "330150" AND av.ProductID IN (508)) OR (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "321.036" AND av.ProductID IN (508)) OR (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "321.071" AND av.ProductID IN (508)) OR (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "321.015" AND av.ProductID IN (508)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "158075N" AND av.ProductID IN (508)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "158025N" AND av.ProductID IN (508)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "158066N" AND av.ProductID IN (508)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "158074N" AND av.ProductID IN (508)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "158017N" AND av.ProductID IN (508)) OR (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "GA227003" AND av.ProductID IN (508)) OR (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "GA200818" AND av.ProductID IN (508)) OR (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "GA201776" AND av.ProductID IN (508)) OR (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "GA201830" AND av.ProductID IN (508)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "OL7524" AND av.ProductID IN (508)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "OL7508" AND av.ProductID IN (508)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "OL7509" AND av.ProductID IN (508)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8EW 351 043-681" AND av.ProductID IN (508)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8EW 351 044-061" AND av.ProductID IN (508)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "LE620" AND av.ProductID IN (508)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "LE621" AND av.ProductID IN (508)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "LE074" AND av.ProductID IN (508)) OR (av.SupplierID = 11 AND av.DataSupplierArticleNumber = "LE619" AND av.ProductID IN (508)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 135 103 480" AND av.ProductID IN (1571)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 130 303 273" AND av.ProductID IN (792)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 135 103 516" AND av.ProductID IN (1571)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 130 303 275" AND av.ProductID IN (792)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 130 303 245" AND av.ProductID IN (792)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 135 103 479" AND av.ProductID IN (1571)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 130 303 246" AND av.ProductID IN (792)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-511-001" AND av.ProductID IN (508)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-511-004" AND av.ProductID IN (508)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-510-023" AND av.ProductID IN (508)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-510-028" AND av.ProductID IN (508)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-510-011" AND av.ProductID IN (792)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DER20013" AND av.ProductID IN (508)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1805001" AND av.ProductID IN (1254)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1805101" AND av.ProductID IN (508)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "DCL1146" AND av.ProductID IN (508)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "352066" AND av.ProductID IN (508)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0507.1830" AND av.ProductID IN (508)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0507.1842" AND av.ProductID IN (508)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0507.2017" AND av.ProductID IN (508)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8EW 351 044-061" AND av.ProductID IN (508)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8EW 351 043-681" AND av.ProductID IN (508)) OR (av.SupplierID = 296 AND av.DataSupplierArticleNumber = "EV200770" AND av.ProductID IN (508)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1299101000" AND av.ProductID IN (508)) OR (av.SupplierID = 469 AND av.DataSupplierArticleNumber = "418300" AND av.ProductID IN (508)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "50512601" AND av.ProductID IN (508)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "50512602" AND av.ProductID IN (508)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "037-014-0011" AND av.ProductID IN (508)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "037-014-0029" AND av.ProductID IN (508)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "037-014-0006" AND av.ProductID IN (508)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "037-014-0007" AND av.ProductID IN (508)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069422330010" AND av.ProductID IN (508)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069422334010" AND av.ProductID IN (508)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "71-0028" AND av.ProductID IN (508)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "85181" AND av.ProductID IN (508)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "85660" AND av.ProductID IN (1254)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "85185" AND av.ProductID IN (508)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "85179" AND av.ProductID IN (508)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DER20013" AND av.ProductID IN (508)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "47015" AND av.ProductID IN (508)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "47308" AND av.ProductID IN (508)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "47582" AND av.ProductID IN (508)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "47010" AND av.ProductID IN (508)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "12393" AND av.ProductID IN (508)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PFN091" AND av.ProductID IN (508)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP0173320" AND av.ProductID IN (508)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP0173310" AND av.ProductID IN (508)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "29-99266-SX" AND av.ProductID IN (508)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "29-99321-SX" AND av.ProductID IN (508)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "29-99244-SX" AND av.ProductID IN (508)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D8X009TT" AND av.ProductID IN (508)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D8X013TT" AND av.ProductID IN (508)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D8X007TT" AND av.ProductID IN (508)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "207 210" AND av.ProductID IN (508)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "825-0011" AND av.ProductID IN (508)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "825-0014" AND av.ProductID IN (508)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "696280" AND av.ProductID IN (508)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "696355" AND av.ProductID IN (508)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "696370" AND av.ProductID IN (508)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "696173" AND av.ProductID IN (508)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3742746" AND av.ProductID IN (508)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-01-1041" AND av.ProductID IN (508)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-01-1044" AND av.ProductID IN (508)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-01-1052" AND av.ProductID IN (508)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-01-1039" AND av.ProductID IN (508)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1720533" AND av.ProductID IN (508)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1720114" AND av.ProductID IN (508)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1720119" AND av.ProductID IN (508)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1720278" AND av.ProductID IN (508)) ) 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 = 4654 AND aa.DataSupplierArticleNumber = "330151") OR (aa.SupplierID = 4654 AND aa.DataSupplierArticleNumber = "330150") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.036") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.071") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.015") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158075N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158025N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158066N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158074N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158017N") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA227003") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA200818") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA201776") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA201830") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7524") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7508") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7509") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8EW 351 043-681") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8EW 351 044-061") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE620") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE621") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE074") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE619") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 480") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 273") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 516") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 275") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 245") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 479") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 246") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-511-001") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-511-004") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-023") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-028") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-011") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DER20013") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1805001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1805101") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCL1146") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "352066") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.1830") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.1842") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.2017") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EW 351 044-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EW 351 043-681") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "EV200770") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1299101000") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "418300") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "50512601") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "50512602") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0029") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0006") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0007") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069422330010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069422334010") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "71-0028") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85181") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85660") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85185") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85179") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DER20013") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47015") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47308") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47582") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47010") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "12393") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PFN091") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0173320") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0173310") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99266-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99321-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99244-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X009TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X013TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X007TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "207 210") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "825-0011") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "825-0014") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696280") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696355") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696370") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696173") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3742746") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1041") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1044") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1052") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1039") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720533") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720114") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720119") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720278") ) 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 = 4654 AND aa.DataSupplierArticleNumber = "330151") OR (aa.SupplierID = 4654 AND aa.DataSupplierArticleNumber = "330150") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.036") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.071") OR (aa.SupplierID = 422 AND aa.DataSupplierArticleNumber = "321.015") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158075N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158025N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158066N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158074N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "158017N") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA227003") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA200818") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA201776") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "GA201830") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7524") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7508") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL7509") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8EW 351 043-681") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8EW 351 044-061") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE620") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE621") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE074") OR (aa.SupplierID = 11 AND aa.DataSupplierArticleNumber = "LE619") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 480") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 273") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 516") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 275") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 245") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 135 103 479") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 130 303 246") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-511-001") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-511-004") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-023") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-028") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-510-011") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DER20013") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1805001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1805101") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCL1146") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "352066") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.1830") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.1842") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0507.2017") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EW 351 044-061") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8EW 351 043-681") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "EV200770") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1299101000") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "418300") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "50512601") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "50512602") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0029") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0006") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "037-014-0007") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069422330010") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069422334010") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "71-0028") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85181") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85660") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85185") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "85179") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DER20013") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47015") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47308") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47582") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "47010") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "12393") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PFN091") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0173320") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP0173310") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99266-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99321-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "29-99244-SX") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X009TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X013TT") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D8X007TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "207 210") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "825-0011") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "825-0014") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696280") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696355") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696370") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "696173") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3742746") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1041") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1044") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1052") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-01-1039") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720533") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720114") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720119") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1720278") ) AND aa.Language = "ru" Продажа автозапчастей типа Вентилятор для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ACR 330151 Вентилятор, охлаждение двигателя
330150 Вентилятор, охлаждение двигателя
AHE 321.036 Вентилятор, охлаждение двигателя
321.071 Вентилятор, охлаждение двигателя
321.015 Вентилятор, охлаждение двигателя
AKS DASIS 158075N Вентилятор, охлаждение двигателя
158025N Вентилятор, охлаждение двигателя
158066N Вентилятор, охлаждение двигателя
158074N Вентилятор, охлаждение двигателя
158017N Вентилятор, охлаждение двигателя
AUTOGAMMA GA227003 Вентилятор, охлаждение двигателя
GA200818 Вентилятор, охлаждение двигателя
GA201776 Вентилятор, охлаждение двигателя
GA201830 Вентилятор, охлаждение двигателя
AVA QUALITY COOLING OL7524 Вентилятор, охлаждение двигателя
OL7508 Вентилятор, охлаждение двигателя
OL7509 Вентилятор, охлаждение двигателя
BEHR HELLA SERVICE 8EW 351 043-681 Вентилятор, охлаждение двигателя
8EW 351 044-061 Вентилятор, охлаждение двигателя
BERU LE620 Вентилятор, охлаждение двигателя
LE621 Вентилятор, охлаждение двигателя
LE074 Вентилятор, охлаждение двигателя
LE619 Вентилятор, охлаждение двигателя
BOSCH 3 135 103 480 Кронштейн, вентилятор радиатора
0 130 303 273 Электродвигатель, вентилятор радиатора
3 135 103 516 Кронштейн, вентилятор радиатора
0 130 303 275 Электродвигатель, вентилятор радиатора
0 130 303 245 Электродвигатель, вентилятор радиатора
3 135 103 479 Кронштейн, вентилятор радиатора
0 130 303 246 Электродвигатель, вентилятор радиатора
BSG BSG 65-511-001 Вентилятор, охлаждение двигателя
BSG 65-511-004 Вентилятор, охлаждение двигателя
BSG 65-510-023 Вентилятор, охлаждение двигателя
BSG 65-510-028 Вентилятор, охлаждение двигателя
BSG 65-510-011 Электродвигатель, вентилятор радиатора
DENSO DER20013 Вентилятор, охлаждение двигателя
DIEDERICHS 1805001 Вентилятор, конденсатор кондиционера
1805101 Вентилятор, охлаждение двигателя
DCL1146 Вентилятор, охлаждение двигателя
ERA 352066 Вентилятор, охлаждение двигателя
FRIGAIR 0507.1830 Вентилятор, охлаждение двигателя
0507.1842 Вентилятор, охлаждение двигателя
0507.2017 Вентилятор, охлаждение двигателя
HELLA 8EW 351 044-061 Вентилятор, охлаждение двигателя
8EW 351 043-681 Вентилятор, охлаждение двигателя
JDEUS EV200770 Вентилятор, охлаждение двигателя
JP GROUP 1299101000 Вентилятор, охлаждение двигателя
KALE OTO RADYATÖR 418300 Вентилятор, охлаждение двигателя
KLOKKERHOLM 50512601 Вентилятор, охлаждение двигателя
50512602 Вентилятор, охлаждение двигателя
LORO 037-014-0011 Вентилятор, охлаждение двигателя
037-014-0029 Вентилятор, охлаждение двигателя
037-014-0006 Вентилятор, охлаждение двигателя
037-014-0007 Вентилятор, охлаждение двигателя
MAGNETI MARELLI 069422330010 Вентилятор, охлаждение двигателя
069422334010 Вентилятор, охлаждение двигателя
MAXGEAR 71-0028 Вентилятор, охлаждение двигателя
NISSENS 85181 Вентилятор, охлаждение двигателя
85660 Вентилятор, конденсатор кондиционера
85185 Вентилятор, охлаждение двигателя
85179 Вентилятор, охлаждение двигателя
NPS DER20013 Вентилятор, охлаждение двигателя
NRF 47015 Вентилятор, охлаждение двигателя
47308 Вентилятор, охлаждение двигателя
47582 Вентилятор, охлаждение двигателя
47010 Вентилятор, охлаждение двигателя
OSSCA 12393 Вентилятор, охлаждение двигателя
PATRON PFN091 Вентилятор, охлаждение двигателя
PRASCO OP0173320 Вентилятор, охлаждение двигателя
OP0173310 Вентилятор, охлаждение двигателя
STELLOX 29-99266-SX Вентилятор, охлаждение двигателя
29-99321-SX Вентилятор, охлаждение двигателя
29-99244-SX Вентилятор, охлаждение двигателя
THERMOTEC D8X009TT Вентилятор, охлаждение двигателя
D8X013TT Вентилятор, охлаждение двигателя
D8X007TT Вентилятор, охлаждение двигателя
TOPRAN 207 210 Вентилятор, охлаждение двигателя
TYC 825-0011 Вентилятор, охлаждение двигателя
825-0014 Вентилятор, охлаждение двигателя
VALEO 696280 Вентилятор, охлаждение двигателя
696355 Вентилятор, охлаждение двигателя
696370 Вентилятор, охлаждение двигателя
696173 Вентилятор, охлаждение двигателя
VAN WEZEL 3742746 Вентилятор, охлаждение двигателя
VEMO V40-01-1041 Вентилятор, охлаждение двигателя
V40-01-1044 Вентилятор, охлаждение двигателя
V40-01-1052 Вентилятор, охлаждение двигателя
V40-01-1039 Вентилятор, охлаждение двигателя
WILMINK GROUP WG1720533 Вентилятор, охлаждение двигателя
WG1720114 Вентилятор, охлаждение двигателя
WG1720119 Вентилятор, охлаждение двигателя
WG1720278 Вентилятор, охлаждение двигателя
2026 CATCAR.INFO (v 2.0)