#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTU0MjV8fG1kZl9pZD09MF4yNTUwMXx8c3BhcmVfaWQ9PTEwMDU3Mg%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 = "25501" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "50415" AND av.ProductID IN (251)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "50428" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270225" AND av.ProductID IN (251)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270667" AND av.ProductID IN (251)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "1801-ASHR" AND av.ProductID IN (251)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "1801-001" AND av.ProductID IN (251)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "1801-002" AND av.ProductID IN (251)) OR (av.SupplierID = 4631 AND av.DataSupplierArticleNumber = "1801-AHB" AND av.ProductID IN (251)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1420466" AND av.ProductID IN (251)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1421058" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "047651B" AND av.ProductID IN (251)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "046509B" AND av.ProductID IN (251)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "2293" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6025" AND av.ProductID IN (251)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK6520" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-052" AND av.ProductID IN (251)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-061" AND av.ProductID IN (251)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "480512" AND av.ProductID IN (3245)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "482525" AND av.ProductID IN (251)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CRB3209" AND av.ProductID IN (251)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CRB3027" AND av.ProductID IN (251)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CRB3029" AND av.ProductID IN (251)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "21652926" AND av.ProductID IN (251)) OR (av.SupplierID = 4880 AND av.DataSupplierArticleNumber = "CBH15005" AND av.ProductID IN (251)) OR (av.SupplierID = 4880 AND av.DataSupplierArticleNumber = "CBH15012" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD332W" AND av.ProductID IN (251)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD661W" AND av.ProductID IN (251)) OR (av.SupplierID = 186 AND av.DataSupplierArticleNumber = "D300068" AND av.ProductID IN (251)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS6007" AND av.ProductID IN (251)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS7545" AND av.ProductID IN (251)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS1186" AND av.ProductID IN (251)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT18362" AND av.ProductID IN (251)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "OPAB-ASHB" AND av.ProductID IN (251)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "OPAB-ASHS" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "11662" AND av.ProductID IN (251)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23762" AND av.ProductID IN (251)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "CAB10064" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6520" AND av.ProductID IN (251)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FSK6025" AND av.ProductID IN (251)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "2000010" AND av.ProductID IN (251)) OR (av.SupplierID = 4727 AND av.DataSupplierArticleNumber = "2000035" AND av.ProductID IN (251)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ9440" AND av.ProductID IN (251)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90573" AND av.ProductID IN (251)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "SB1988" AND av.ProductID IN (251)) OR (av.SupplierID = 486 AND av.DataSupplierArticleNumber = "SB21988" AND av.ProductID IN (251)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "512786" AND av.ProductID IN (251)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "510926" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240202109" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240200409" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240201400" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240202100" AND av.ProductID IN (251)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1240200400" AND av.ProductID IN (251)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800272" AND av.ProductID IN (251)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 24840" AND av.ProductID IN (251)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 24834" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231535" AND av.ProductID IN (251)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231536" AND av.ProductID IN (251)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "37688 01" AND av.ProductID IN (251)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "35363 01" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8207" AND av.ProductID IN (251)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8534" AND av.ProductID IN (251)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "33788" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "35936-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "9838F-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "2824M-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "35363-PCS-MS" AND av.ProductID IN (251)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-2271" AND av.ProductID IN (251)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52002908" AND av.ProductID IN (251)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52002208" AND av.ProductID IN (251)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 610 0001" AND av.ProductID IN (3245)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 035 0018" AND av.ProductID IN (3245)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24834" AND av.ProductID IN (251)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24840" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-1384" AND av.ProductID IN (251)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-2824" AND av.ProductID IN (251)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5103646" AND av.ProductID IN (251)) OR (av.SupplierID = 127 AND av.DataSupplierArticleNumber = "5103611" AND av.ProductID IN (251)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "SSS1022.11" AND av.ProductID IN (251)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "SSS1067.11" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-6451" AND av.ProductID IN (251)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-7946" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0076" AND av.ProductID IN (251)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0548" AND av.ProductID IN (251)) OR (av.SupplierID = 4368 AND av.DataSupplierArticleNumber = "SB7771" AND av.ProductID IN (251)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMS2698" AND av.ProductID IN (251)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMS8306" AND av.ProductID IN (251)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "OP11039" AND av.ProductID IN (251)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "OP11003" AND av.ProductID IN (251)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "017-00363" AND av.ProductID IN (251)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19125103611" AND av.ProductID IN (251)) OR (av.SupplierID = 297 AND av.DataSupplierArticleNumber = "19125103646" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809637" AND av.ProductID IN (251)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "809605" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 92 3762" AND av.ProductID IN (251)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 60 0018" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "49-01821" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-00447" AND av.ProductID IN (251)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "57-02592" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "205 473" AND av.ProductID IN (251)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "206 973" AND av.ProductID IN (251)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "788462" AND av.ProductID IN (251)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "788463" AND av.ProductID IN (251)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "788461" AND av.ProductID IN (251)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24834" AND av.ProductID IN (251)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24840" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JBU137" AND av.ProductID IN (251)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JBU733" AND av.ProductID IN (251)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "391574" AND av.ProductID IN (251)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0498" AND av.ProductID IN (251)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "20854" AND av.ProductID IN (251,251)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "21108" AND av.ProductID IN (251)) ) 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 = "50415") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "50428") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270225") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270667") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-ASHR") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-001") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-002") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-AHB") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420466") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1421058") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047651B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "046509B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2293") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6025") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6520") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-052") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-061") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480512") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "482525") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3209") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3027") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3029") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652926") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15005") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15012") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD332W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD661W") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300068") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS6007") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7545") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1186") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT18362") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "OPAB-ASHB") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "OPAB-ASHS") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "11662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23762") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "CAB10064") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6520") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6025") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000010") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000035") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9440") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90573") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "SB1988") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "SB21988") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "512786") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510926") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240200409") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240200400") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800272") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24840") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24834") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231535") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231536") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37688 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35363 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8207") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8534") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33788") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "35936-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "9838F-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "2824M-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "35363-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-2271") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52002908") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52002208") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 610 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0018") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24840") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1384") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-2824") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103646") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103611") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "SSS1022.11") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "SSS1067.11") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6451") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7946") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0076") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0548") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7771") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS2698") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8306") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11039") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "017-00363") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103611") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103646") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809637") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809605") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 92 3762") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0018") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "49-01821") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-00447") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02592") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "205 473") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "206 973") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788462") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788463") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788461") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24834") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24840") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU137") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU733") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391574") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0498") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20854") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "21108") ) 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 = "50415") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "50428") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270225") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270667") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-ASHR") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-001") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-002") OR (aa.SupplierID = 4631 AND aa.DataSupplierArticleNumber = "1801-AHB") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1420466") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1421058") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047651B") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "046509B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2293") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6025") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK6520") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-052") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-061") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480512") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "482525") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3209") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3027") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRB3029") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "21652926") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15005") OR (aa.SupplierID = 4880 AND aa.DataSupplierArticleNumber = "CBH15012") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD332W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD661W") OR (aa.SupplierID = 186 AND aa.DataSupplierArticleNumber = "D300068") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS6007") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7545") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1186") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT18362") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "OPAB-ASHB") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "OPAB-ASHS") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "11662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23762") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "CAB10064") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6520") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FSK6025") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000010") OR (aa.SupplierID = 4727 AND aa.DataSupplierArticleNumber = "2000035") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9440") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90573") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "SB1988") OR (aa.SupplierID = 486 AND aa.DataSupplierArticleNumber = "SB21988") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "512786") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "510926") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202109") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240200409") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240201400") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240202100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1240200400") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800272") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24840") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24834") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231535") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231536") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "37688 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35363 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8207") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8534") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "33788") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "35936-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "9838F-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "2824M-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "35363-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-2271") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52002908") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52002208") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 610 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 035 0018") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24840") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-1384") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-2824") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103646") OR (aa.SupplierID = 127 AND aa.DataSupplierArticleNumber = "5103611") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "SSS1022.11") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "SSS1067.11") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6451") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7946") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0076") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0548") OR (aa.SupplierID = 4368 AND aa.DataSupplierArticleNumber = "SB7771") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS2698") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMS8306") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11039") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "OP11003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "017-00363") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103611") OR (aa.SupplierID = 297 AND aa.DataSupplierArticleNumber = "19125103646") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809637") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "809605") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 92 3762") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 60 0018") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "49-01821") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-00447") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "57-02592") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "205 473") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "206 973") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788462") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788463") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788461") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24834") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24840") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU137") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JBU733") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391574") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0498") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "20854") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "21108") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска / крепление ходовой части для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 50415 Подвеска, рычаг независимой подвески колеса
50428 Подвеска, рычаг независимой подвески колеса
A.B.S. 270225 Подвеска, рычаг независимой подвески колеса
270667 Подвеска, рычаг независимой подвески колеса
ASVA 1801-ASHR Подвеска, рычаг независимой подвески колеса
1801-001 Подвеска, рычаг независимой подвески колеса
1801-002 Подвеска, рычаг независимой подвески колеса
1801-AHB Подвеска, рычаг независимой подвески колеса
AYWIPARTS AW1420466 Подвеска, рычаг независимой подвески колеса
AW1421058 Подвеска, рычаг независимой подвески колеса
BENDIX 047651B Подвеска, рычаг независимой подвески колеса
046509B Подвеска, рычаг независимой подвески колеса
BIRTH 2293 Подвеска, рычаг независимой подвески колеса
BORG & BECK BSK6025 Подвеска, рычаг независимой подвески колеса
BSK6520 Подвеска, рычаг независимой подвески колеса
BSG BSG 65-700-052 Подвеска, рычаг независимой подвески колеса
BSG 65-700-061 Подвеска, рычаг независимой подвески колеса
CAUTEX 480512 Втулка, рычаг колесной подвески
482525 Подвеска, рычаг независимой подвески колеса
COMLINE CRB3209 Подвеска, рычаг независимой подвески колеса
CRB3027 Подвеска, рычаг независимой подвески колеса
CRB3029 Подвеска, рычаг независимой подвески колеса
CORTECO 21652926 Подвеска, рычаг независимой подвески колеса
CTE CBH15005 Подвеска, рычаг независимой подвески колеса
CBH15012 Подвеска, рычаг независимой подвески колеса
DELPHI TD332W Подвеска, рычаг независимой подвески колеса
TD661W Подвеска, рычаг независимой подвески колеса
DENCKERMANN D300068 Подвеска, рычаг независимой подвески колеса
FAI AutoParts SS6007 Подвеска, рычаг независимой подвески колеса
SS7545 Подвеска, рычаг независимой подвески колеса
SS1186 Подвеска, рычаг независимой подвески колеса
FAST FT18362 Подвеска, рычаг независимой подвески колеса
FEBEST OPAB-ASHB Подвеска, рычаг независимой подвески колеса
OPAB-ASHS Подвеска, рычаг независимой подвески колеса
FEBI BILSTEIN 11662 Подвеска, рычаг независимой подвески колеса
23762 Подвеска, рычаг независимой подвески колеса
FENOX CAB10064 Подвеска, рычаг независимой подвески колеса
FIRST LINE FSK6520 Подвеска, рычаг независимой подвески колеса
FSK6025 Подвеска, рычаг независимой подвески колеса
FORMPART 2000010 Подвеска, рычаг независимой подвески колеса
2000035 Подвеска, рычаг независимой подвески колеса
FORTUNE LINE FZ9440 Подвеска, рычаг независимой подвески колеса
FZ90573 Подвеска, рычаг независимой подвески колеса
FRAP SB1988 Подвеска, рычаг независимой подвески колеса
SB21988 Подвеска, рычаг независимой подвески колеса
GSP 512786 Подвеска, рычаг независимой подвески колеса
510926 Подвеска, рычаг независимой подвески колеса
JP GROUP 1240202109 Подвеска, рычаг независимой подвески колеса
1240200409 Подвеска, рычаг независимой подвески колеса
1240201400 Подвеска, рычаг независимой подвески колеса
1240202100 Подвеска, рычаг независимой подвески колеса
1240200400 Подвеска, рычаг независимой подвески колеса
KAMOKA 8800272 Подвеска, рычаг независимой подвески колеса
KAWE 8500 24840 Подвеска, рычаг независимой подвески колеса
8500 24834 Подвеска, рычаг независимой подвески колеса
KRAFT AUTOMOTIVE 4231535 Подвеска, рычаг независимой подвески колеса
4231536 Подвеска, рычаг независимой подвески колеса
LEMFÖRDER 37688 01 Подвеска, рычаг независимой подвески колеса
35363 01 Подвеска, рычаг независимой подвески колеса
LYNXauto C8207 Подвеска, рычаг независимой подвески колеса
C8534 Подвеска, рычаг независимой подвески колеса
MAPCO 33788 Подвеска, рычаг независимой подвески колеса
MASTER-SPORT 35936-PCS-MS Подвеска, рычаг независимой подвески колеса
9838F-PCS-MS Подвеска, рычаг независимой подвески колеса
2824M-PCS-MS Подвеска, рычаг независимой подвески колеса
35363-PCS-MS Подвеска, рычаг независимой подвески колеса
MAXGEAR 72-2271 Подвеска, рычаг независимой подвески колеса
METZGER 52002908 Подвеска, рычаг независимой подвески колеса
52002208 Подвеска, рычаг независимой подвески колеса
MEYLE 614 610 0001 Втулка, рычаг колесной подвески
614 035 0018 Втулка, рычаг колесной подвески
MONROE L24834 Подвеска, рычаг независимой подвески колеса
L24840 Подвеска, рычаг независимой подвески колеса
MOOG OP-SB-1384 Подвеска, рычаг независимой подвески колеса
OP-SB-2824 Подвеска, рычаг независимой подвески колеса
NK 5103646 Подвеска, рычаг независимой подвески колеса
5103611 Подвеска, рычаг независимой подвески колеса
OPEN PARTS SSS1022.11 Подвеска, рычаг независимой подвески колеса
SSS1067.11 Подвеска, рычаг независимой подвески колеса
OPTIMAL F8-6451 Подвеска, рычаг независимой подвески колеса
F8-7946 Подвеска, рычаг независимой подвески колеса
PROFIT 2307-0076 Подвеска, рычаг независимой подвески колеса
2307-0548 Подвеска, рычаг независимой подвески колеса
QUICK STEER SB7771 Подвеска, рычаг независимой подвески колеса
QUINTON HAZELL EMS2698 Подвеска, рычаг независимой подвески колеса
EMS8306 Подвеска, рычаг независимой подвески колеса
RIW OP11039 Подвеска, рычаг независимой подвески колеса
OP11003 Подвеска, рычаг независимой подвески колеса
RTS 017-00363 Подвеска, рычаг независимой подвески колеса
sbs 19125103611 Подвеска, рычаг независимой подвески колеса
19125103646 Подвеска, рычаг независимой подвески колеса
SIDEM 809637 Подвеска, рычаг независимой подвески колеса
809605 Подвеска, рычаг независимой подвески колеса
SWAG 40 92 3762 Подвеска, рычаг независимой подвески колеса
40 60 0018 Подвеска, рычаг независимой подвески колеса
TALOSA 49-01821 Подвеска, рычаг независимой подвески колеса
57-00447 Подвеска, рычаг независимой подвески колеса
57-02592 Подвеска, рычаг независимой подвески колеса
TOPRAN 205 473 Подвеска, рычаг независимой подвески колеса
206 973 Подвеска, рычаг независимой подвески колеса
TRICLO 788462 Подвеска, рычаг независимой подвески колеса
788463 Подвеска, рычаг независимой подвески колеса
788461 Подвеска, рычаг независимой подвески колеса
TRISCAN 8500 24834 Подвеска, рычаг независимой подвески колеса
8500 24840 Подвеска, рычаг независимой подвески колеса
TRW JBU137 Подвеска, рычаг независимой подвески колеса
JBU733 Подвеска, рычаг независимой подвески колеса
UNIGOM 391574 Подвеска, рычаг независимой подвески колеса
VAICO V40-0498 Подвеска, рычаг независимой подвески колеса
VEMA 20854 Подвеска, рычаг независимой подвески колеса
21108 Подвеска, рычаг независимой подвески колеса
2026 CATCAR.INFO (v 2.0)