#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTQ5ODh8fG1kZl9pZD09MF4yNDM2N3x8c3BhcmVfaWQ9PTEwMDU5Ng%3D%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 = "24367" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "60769" AND av.ProductID IN (1334)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270649" AND av.ProductID IN (331)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "271055" AND av.ProductID IN (331)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "271056" AND av.ProductID IN (331)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "N565-01" AND av.ProductID IN (1334)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "047476B" AND av.ProductID IN (1334)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "048526B" AND av.ProductID IN (331)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "047609B" AND av.ProductID IN (1334)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADN18022" AND av.ProductID IN (1334)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-024" AND av.ProductID IN (331)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-019" AND av.ProductID IN (1334)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-020" AND av.ProductID IN (1334)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-025" AND av.ProductID IN (1334)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "462465" AND av.ProductID IN (1334)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CSRM3076" AND av.ProductID IN (1334)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CSRM3079" AND av.ProductID IN (1334)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "80005456" AND av.ProductID IN (1334)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1085W" AND av.ProductID IN (1334)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1144W" AND av.ProductID IN (1334)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS7919K" AND av.ProductID IN (1334)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS7502K" AND av.ProductID IN (1334)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10810" AND av.ProductID IN (1334)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10829" AND av.ProductID IN (1334)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-T5R" AND av.ProductID IN (1334,331)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-T5D23R-KIT" AND av.ProductID IN (331)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-003" AND av.ProductID IN (331,1334)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-T5OUTR" AND av.ProductID IN (331)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-004" AND av.ProductID IN (331,1334)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-005" AND av.ProductID IN (331)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "31346" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "101230" AND av.ProductID IN (2069)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "31347" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "42511" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26541" AND av.ProductID IN (1334)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "BS10032" AND av.ProductID IN (331)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90651" AND av.ProductID IN (1334)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90881" AND av.ProductID IN (1334)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90930" AND av.ProductID IN (1334)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "517171" AND av.ProductID IN (1334)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "518051" AND av.ProductID IN (331)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1140603500" AND av.ProductID IN (331)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1150451600" AND av.ProductID IN (1334)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1140606700" AND av.ProductID IN (331)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1150450700" AND av.ProductID IN (331)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 298027" AND av.ProductID IN (331)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4230027" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "37811/2" AND av.ProductID IN (1097)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "37811" AND av.ProductID IN (1334)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "31346B-PCS-MS" AND av.ProductID IN (1334)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1489" AND av.ProductID IN (1334)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1490" AND av.ProductID IN (1334)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1488" AND av.ProductID IN (1334)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "05981" AND av.ProductID IN (1334)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "06001" AND av.ProductID IN (1334)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52067708" AND av.ProductID IN (1334)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52072208" AND av.ProductID IN (1334)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52043908" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 715 0000" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 715 0001" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 615 0008" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 715 0002" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "114 615 0009" AND av.ProductID IN (1334)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-10550" AND av.ProductID IN (1334)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-13288" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-13583" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-10877" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-2320" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-10878" AND av.ProductID IN (331)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVSK1063K" AND av.ProductID IN (1334)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVSK1094K" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214275" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214271" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214272" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214274" AND av.ProductID IN (1334)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-7387" AND av.ProductID IN (1334)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-8216" AND av.ProductID IN (331)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-7904" AND av.ProductID IN (1334)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "37641" AND av.ProductID IN (1334)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2305-0493" AND av.ProductID IN (2069)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2305-0500" AND av.ProductID IN (2069)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMB7239" AND av.ProductID IN (1334)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMB7240" AND av.ProductID IN (1334)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMB7241" AND av.ProductID IN (1334)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMB7286" AND av.ProductID IN (1334)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "VW12063" AND av.ProductID IN (331)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "035-00185" AND av.ProductID IN (1334)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985478" AND av.ProductID IN (1334)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985471" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "2306203" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "2306204" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "2306114" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "2306201" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864905" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864807" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864907" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864808" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864908" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "864904" AND av.ProductID IN (1334)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T405981" AND av.ProductID IN (1334)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T406001" AND av.ProductID IN (1334)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "79-00448-SX" AND av.ProductID IN (1334)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "79-00455-SX" AND av.ProductID IN (1334)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "79-00766-SX" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "82 94 2511" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 6541" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 1346" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 10 1230" AND av.ProductID IN (2069)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 1347" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 867" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "114 626" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "113 697" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "114 623" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "111 470" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "113 414" AND av.ProductID IN (2069)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "114 624" AND av.ProductID IN (1334)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "782104" AND av.ProductID IN (331)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 298027" AND av.ProductID IN (331)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "392882" AND av.ProductID IN (331)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "392884" AND av.ProductID IN (331)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1028" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-2966" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3842" AND av.ProductID IN (1334)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "60769") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270649") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "271055") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "271056") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "N565-01") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047476B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "048526B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047609B") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18022") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-024") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-019") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-020") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-025") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "462465") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3076") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3079") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80005456") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1085W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1144W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7919K") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7502K") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10810") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10829") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5R") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5D23R-KIT") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-003") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5OUTR") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-004") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31346") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101230") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31347") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "42511") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26541") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "BS10032") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90651") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90881") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90930") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "517171") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "518051") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1140603500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1140606700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150450700") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 298027") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230027") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37811/2") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37811") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "31346B-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1489") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1490") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1488") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05981") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52067708") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52072208") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52043908") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0000") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 615 0008") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 615 0009") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10550") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-13288") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-13583") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10877") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-2320") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10878") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1063K") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1094K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214275") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214271") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214272") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214274") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7387") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-8216") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7904") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37641") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0493") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0500") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7239") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7240") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7241") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7286") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "VW12063") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "035-00185") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985478") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985471") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306203") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306204") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306114") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306201") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864905") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864807") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864907") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864808") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864908") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864904") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405981") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406001") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00448-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00455-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00766-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "82 94 2511") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6541") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 1346") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 10 1230") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 1347") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 867") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 626") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 697") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 623") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 470") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 414") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 624") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "782104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 298027") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392882") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392884") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-2966") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3842") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "60769") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270649") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "271055") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "271056") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "N565-01") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047476B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "048526B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047609B") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADN18022") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-024") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-019") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-020") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-025") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "462465") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3076") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3079") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80005456") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1085W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1144W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7919K") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7502K") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10810") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10829") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5R") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5D23R-KIT") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-003") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-T5OUTR") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-004") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31346") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101230") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31347") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "42511") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26541") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "BS10032") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90651") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90881") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90930") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "517171") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "518051") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1140603500") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451600") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1140606700") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150450700") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 298027") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230027") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37811/2") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37811") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "31346B-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1489") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1490") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1488") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05981") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "06001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52067708") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52072208") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52043908") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0000") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 615 0008") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 715 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "114 615 0009") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10550") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-13288") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-13583") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10877") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-2320") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-10878") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1063K") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1094K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214275") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214271") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214272") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214274") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7387") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-8216") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7904") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37641") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0493") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0500") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7239") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7240") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7241") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7286") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "VW12063") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "035-00185") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985478") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985471") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306203") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306204") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306114") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306201") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864905") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864807") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864907") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864808") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864908") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "864904") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405981") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T406001") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00448-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00455-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00766-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "82 94 2511") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6541") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 1346") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 10 1230") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 1347") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 867") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 626") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 697") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 623") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 470") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 414") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 624") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "782104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 298027") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392882") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392884") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-2966") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3842") ) AND aa.Language = "ru" Продажа автозапчастей типа Детали крепежа для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 60769 Опора, стабилизатор
A.B.S. 270649 Втулка, стабилизатор
271055 Втулка, стабилизатор
271056 Втулка, стабилизатор
ASHUKI N565-01 Опора, стабилизатор
BENDIX 047476B Опора, стабилизатор
048526B Втулка, стабилизатор
047609B Опора, стабилизатор
BLUE PRINT ADN18022 Опора, стабилизатор
BSG BSG 90-700-024 Втулка, стабилизатор
BSG 90-700-019 Опора, стабилизатор
BSG 90-700-020 Опора, стабилизатор
BSG 90-700-025 Опора, стабилизатор
CAUTEX 462465 Опора, стабилизатор
COMLINE CSRM3076 Опора, стабилизатор
CSRM3079 Опора, стабилизатор
CORTECO 80005456 Опора, стабилизатор
DELPHI TD1085W Опора, стабилизатор
TD1144W Опора, стабилизатор
FAI AutoParts SS7919K Опора, стабилизатор
SS7502K Опора, стабилизатор
FARE SA 10810 Опора, стабилизатор
10829 Опора, стабилизатор
FEBEST VWSB-T5R Втулка, стабилизатор
VWSB-T5D23R-KIT Втулка, стабилизатор
VWSB-003 Опора, стабилизатор
VWSB-T5OUTR Втулка, стабилизатор
VWSB-004 Опора, стабилизатор
VWSB-005 Втулка, стабилизатор
FEBI BILSTEIN 31346 Опора, стабилизатор
101230 Кронштейн, подвеска стабилизато
31347 Опора, стабилизатор
42511 Опора, стабилизатор
26541 Опора, стабилизатор
FENOX BS10032 Втулка, стабилизатор
FORTUNE LINE FZ90651 Опора, стабилизатор
FZ90881 Опора, стабилизатор
FZ90930 Опора, стабилизатор
GSP 517171 Опора, стабилизатор
518051 Втулка, стабилизатор
JP GROUP 1140603500 Втулка, стабилизатор
1150451600 Опора, стабилизатор
1140606700 Втулка, стабилизатор
1150450700 Втулка, стабилизатор
KAWE 8500 298027 Втулка, стабилизатор
KRAFT AUTOMOTIVE 4230027 Опора, стабилизатор
MAPCO 37811/2 Ремкомплект, подшипник стабилизатора
37811 Опора, стабилизатор
MASTER-SPORT 31346B-PCS-MS Опора, стабилизатор
MAXGEAR 72-1489 Опора, стабилизатор
72-1490 Опора, стабилизатор
72-1488 Опора, стабилизатор
Metalcaucho 05981 Опора, стабилизатор
06001 Опора, стабилизатор
METZGER 52067708 Опора, стабилизатор
52072208 Опора, стабилизатор
52043908 Опора, стабилизатор
MEYLE 114 715 0000 Опора, стабилизатор
114 715 0001 Опора, стабилизатор
114 615 0008 Опора, стабилизатор
114 715 0002 Опора, стабилизатор
114 615 0009 Опора, стабилизатор
MOOG VO-SB-10550 Опора, стабилизатор
VO-SB-13288 Втулка, стабилизатор
VO-SB-13583 Втулка, стабилизатор
VO-SB-10877 Втулка, стабилизатор
VO-SB-2320 Втулка, стабилизатор
VO-SB-10878 Втулка, стабилизатор
MOTAQUIP LVSK1063K Опора, стабилизатор
LVSK1094K Опора, стабилизатор
OCAP 1214275 Опора, стабилизатор
1214271 Опора, стабилизатор
1214272 Опора, стабилизатор
1214274 Опора, стабилизатор
OPTIMAL F8-7387 Опора, стабилизатор
F8-8216 Втулка, стабилизатор
F8-7904 Опора, стабилизатор
ORIGINAL IMPERIUM 37641 Опора, стабилизатор
PROFIT 2305-0493 Кронштейн, подвеска стабилизато
2305-0500 Кронштейн, подвеска стабилизато
QUINTON HAZELL EMB7239 Опора, стабилизатор
EMB7240 Опора, стабилизатор
EMB7241 Опора, стабилизатор
EMB7286 Опора, стабилизатор
RIW VW12063 Втулка, стабилизатор
RTS 035-00185 Опора, стабилизатор
RUVILLE 985478 Опора, стабилизатор
985471 Опора, стабилизатор
SASIC 2306203 Опора, стабилизатор
2306204 Опора, стабилизатор
2306114 Опора, стабилизатор
2306201 Опора, стабилизатор
SIDEM 864905 Опора, стабилизатор
864807 Опора, стабилизатор
864907 Опора, стабилизатор
864808 Опора, стабилизатор
864908 Опора, стабилизатор
864904 Опора, стабилизатор
STC T405981 Опора, стабилизатор
T406001 Опора, стабилизатор
STELLOX 79-00448-SX Опора, стабилизатор
79-00455-SX Опора, стабилизатор
79-00766-SX Опора, стабилизатор
SWAG 82 94 2511 Опора, стабилизатор
30 92 6541 Опора, стабилизатор
30 93 1346 Опора, стабилизатор
30 10 1230 Кронштейн, подвеска стабилизато
30 93 1347 Опора, стабилизатор
TOPRAN 112 867 Опора, стабилизатор
114 626 Опора, стабилизатор
113 697 Опора, стабилизатор
114 623 Опора, стабилизатор
111 470 Опора, стабилизатор
113 414 Кронштейн, подвеска стабилизато
114 624 Опора, стабилизатор
TRICLO 782104 Втулка, стабилизатор
TRISCAN 8500 298027 Втулка, стабилизатор
UNIGOM 392882 Втулка, стабилизатор
392884 Втулка, стабилизатор
VAICO V10-1028 Опора, стабилизатор
V10-2966 Опора, стабилизатор
V10-3842 Опора, стабилизатор
2026 CATCAR.INFO (v 2.0)