#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTUxMTF8fG1kZl9pZD09MF4yMjUwNXx8c3BhcmVfaWQ9PTEwMDU5Ng%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 = "22505" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "60780" AND av.ProductID IN (1334)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "60761" AND av.ProductID IN (1334)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "60762" AND av.ProductID IN (1334)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270639" AND av.ProductID IN (331)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270845" AND av.ProductID IN (331)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "270846" AND av.ProductID IN (331)) OR (av.SupplierID = 4737 AND av.DataSupplierArticleNumber = "FT2141" AND av.ProductID IN (1334)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "047628B" AND av.ProductID IN (1334)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "4812" AND av.ProductID IN (1334)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "4816" AND av.ProductID IN (1334)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "4947" AND av.ProductID IN (1334)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADV188003" AND av.ProductID IN (1334)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-700-012" AND av.ProductID IN (1334)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461194" AND av.ProductID IN (1334)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461195" AND av.ProductID IN (1334)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461032" AND av.ProductID IN (1334)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CSRM3096" AND av.ProductID IN (1334)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1043W" AND av.ProductID IN (1334)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TD1044W" AND av.ProductID IN (1334)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS7522K" AND av.ProductID IN (1334)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "10276" AND av.ProductID IN (1334)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-B6R" AND av.ProductID IN (1334,331)) OR (av.SupplierID = 4674 AND av.DataSupplierArticleNumber = "VWSB-GVF" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23356" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39648" AND av.ProductID IN (1097)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23358" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39649" AND av.ProductID IN (1097)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23604" AND av.ProductID IN (2069)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32073" AND av.ProductID IN (1334)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39650" AND av.ProductID IN (1097)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "23606" AND av.ProductID IN (1097)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32625" AND av.ProductID IN (1334)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "BS10180" AND av.ProductID IN (331)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90403" AND av.ProductID IN (1334)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90460" AND av.ProductID IN (1334)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90461" AND av.ProductID IN (1334)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ91045" AND av.ProductID IN (1334)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "516447" AND av.ProductID IN (1334)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1150451200" AND av.ProductID IN (331)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1150451100" AND av.ProductID IN (331)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800450" AND av.ProductID IN (331)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800451" AND av.ProductID IN (331)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800452" AND av.ProductID IN (331)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "8800449" AND av.ProductID IN (331)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 29898" AND av.ProductID IN (331)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 29896" AND av.ProductID IN (331)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4230255" AND av.ProductID IN (1334)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4230265" AND av.ProductID IN (1334)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4230267" AND av.ProductID IN (1334)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "C8703" AND av.ProductID IN (331)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "17426" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "53829/1HPS" AND av.ProductID IN (1097)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "37898" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "53829/2HPS" AND av.ProductID IN (1097)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "37899" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "53898" AND av.ProductID IN (1097)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "53899" AND av.ProductID IN (1097)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "34717-PCS-MS" AND av.ProductID IN (1334)) OR (av.SupplierID = 358 AND av.DataSupplierArticleNumber = "7897M-PCS-MS" AND av.ProductID IN (1334)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "72-1343" AND av.ProductID IN (1334)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "05356" AND av.ProductID IN (1334)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52062709" AND av.ProductID IN (2069)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "52062609" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 511 0011" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 511 0013" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 511 0016" AND av.ProductID IN (2069)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-7897" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-8444" AND av.ProductID IN (331)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "VO-SB-7171" AND av.ProductID IN (331)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVSK1029K" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214130" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214131" AND av.ProductID IN (1334)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "1214144" AND av.ProductID IN (1334)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-6770" AND av.ProductID IN (1334)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F8-7923" AND av.ProductID IN (1334)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "35156" AND av.ProductID IN (1334)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE2071" AND av.ProductID IN (1334)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE2685" AND av.ProductID IN (2069)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2305-0499" AND av.ProductID IN (2069)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EMB7264" AND av.ProductID IN (1334)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985454" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "2306013" AND av.ProductID IN (1334)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7966004" AND av.ProductID IN (1097)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7966005" AND av.ProductID IN (1097)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863902" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863903" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863904" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "863901" AND av.ProductID IN (1334)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T405356" AND av.ProductID IN (1334)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "79-00574-SX" AND av.ProductID IN (1334)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "79-00056-SX" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 2625" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3604" AND av.ProductID IN (2069)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3606" AND av.ProductID IN (1097)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9648" AND av.ProductID IN (1097)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3356" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9649" AND av.ProductID IN (1097)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 3358" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 2073" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9650" AND av.ProductID IN (1097)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 308" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "113 761" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "110 146" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "113 412" AND av.ProductID IN (2069)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29897" AND av.ProductID IN (331)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 298045" AND av.ProductID IN (1334)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29898" AND av.ProductID IN (331)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29895" AND av.ProductID IN (331)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 29896" AND av.ProductID IN (331)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "391197" AND av.ProductID IN (331)) OR (av.SupplierID = 4730 AND av.DataSupplierArticleNumber = "392832" AND av.ProductID IN (331)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-0794" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3067" AND av.ProductID IN (2069)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1555" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1556" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-0788" AND av.ProductID IN (1334)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "55110975701" AND av.ProductID IN (1334)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "55111088301" AND av.ProductID IN (2069)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "55110975801" 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 = "60780") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "60761") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "60762") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270639") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270845") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270846") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT2141") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047628B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4812") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4816") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4947") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADV188003") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-012") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461194") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461195") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461032") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3096") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1043W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1044W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7522K") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10276") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-B6R") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-GVF") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23356") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39648") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23358") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39649") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23604") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32073") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39650") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23606") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32625") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "BS10180") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90403") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90460") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90461") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ91045") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "516447") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800450") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800451") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800452") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800449") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 29898") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 29896") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230255") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230265") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230267") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8703") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17426") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53829/1HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37898") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53829/2HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37899") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53898") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53899") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "34717-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "7897M-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1343") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05356") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52062709") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52062609") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0011") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0013") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0016") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-7897") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-8444") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-7171") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1029K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214130") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214131") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214144") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6770") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7923") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35156") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE2071") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE2685") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0499") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7264") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985454") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306013") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7966004") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7966005") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863902") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863903") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863904") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863901") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405356") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00574-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00056-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2625") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3604") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3606") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9648") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3356") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9649") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3358") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2073") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9650") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 308") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 761") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 146") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 412") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29897") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 298045") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29898") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29895") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29896") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391197") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392832") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0794") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3067") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1555") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1556") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0788") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55110975701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55111088301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55110975801") ) 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 = "60780") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "60761") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "60762") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270639") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270845") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "270846") OR (aa.SupplierID = 4737 AND aa.DataSupplierArticleNumber = "FT2141") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "047628B") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4812") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4816") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "4947") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADV188003") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-700-012") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461194") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461195") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461032") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CSRM3096") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1043W") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TD1044W") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS7522K") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "10276") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-B6R") OR (aa.SupplierID = 4674 AND aa.DataSupplierArticleNumber = "VWSB-GVF") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23356") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39648") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23358") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39649") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23604") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32073") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39650") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "23606") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32625") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "BS10180") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90403") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90460") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90461") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ91045") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "516447") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1150451100") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800450") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800451") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800452") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "8800449") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 29898") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 29896") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230255") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230265") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4230267") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "C8703") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "17426") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53829/1HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37898") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53829/2HPS") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "37899") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53898") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "53899") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "34717-PCS-MS") OR (aa.SupplierID = 358 AND aa.DataSupplierArticleNumber = "7897M-PCS-MS") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "72-1343") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "05356") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52062709") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "52062609") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0011") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0013") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 511 0016") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-7897") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-8444") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "VO-SB-7171") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVSK1029K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214130") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214131") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "1214144") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-6770") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F8-7923") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35156") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE2071") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE2685") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2305-0499") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EMB7264") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985454") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "2306013") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7966004") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7966005") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863902") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863903") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863904") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "863901") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T405356") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00574-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "79-00056-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2625") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3604") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3606") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9648") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3356") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9649") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 3358") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2073") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9650") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 308") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 761") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 146") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "113 412") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29897") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 298045") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29898") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29895") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 29896") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "391197") OR (aa.SupplierID = 4730 AND aa.DataSupplierArticleNumber = "392832") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0794") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3067") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1555") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1556") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0788") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55110975701") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55111088301") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "55110975801") ) AND aa.Language = "ru" Продажа автозапчастей типа Детали крепежа для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 60780 Опора, стабилизатор
60761 Опора, стабилизатор
60762 Опора, стабилизатор
A.B.S. 270639 Втулка, стабилизатор
270845 Втулка, стабилизатор
270846 Втулка, стабилизатор
AUTLOG FT2141 Опора, стабилизатор
BENDIX 047628B Опора, стабилизатор
BIRTH 4812 Опора, стабилизатор
4816 Опора, стабилизатор
4947 Опора, стабилизатор
BLUE PRINT ADV188003 Опора, стабилизатор
BSG BSG 90-700-012 Опора, стабилизатор
CAUTEX 461194 Опора, стабилизатор
461195 Опора, стабилизатор
461032 Опора, стабилизатор
COMLINE CSRM3096 Опора, стабилизатор
DELPHI TD1043W Опора, стабилизатор
TD1044W Опора, стабилизатор
FAI AutoParts SS7522K Опора, стабилизатор
FARE SA 10276 Опора, стабилизатор
FEBEST VWSB-B6R Втулка, стабилизатор
VWSB-GVF Опора, стабилизатор
FEBI BILSTEIN 23356 Опора, стабилизатор
39648 Ремкомплект, подшипник стабилизатора
23358 Опора, стабилизатор
39649 Ремкомплект, подшипник стабилизатора
23604 Кронштейн, подвеска стабилизато
32073 Опора, стабилизатор
39650 Ремкомплект, подшипник стабилизатора
23606 Ремкомплект, подшипник стабилизатора
32625 Опора, стабилизатор
FENOX BS10180 Втулка, стабилизатор
FORTUNE LINE FZ90403 Опора, стабилизатор
FZ90460 Опора, стабилизатор
FZ90461 Опора, стабилизатор
FZ91045 Опора, стабилизатор
GSP 516447 Опора, стабилизатор
JP GROUP 1150451200 Втулка, стабилизатор
1150451100 Втулка, стабилизатор
KAMOKA 8800450 Втулка, стабилизатор
8800451 Втулка, стабилизатор
8800452 Втулка, стабилизатор
8800449 Втулка, стабилизатор
KAWE 8500 29898 Втулка, стабилизатор
8500 29896 Втулка, стабилизатор
KRAFT AUTOMOTIVE 4230255 Опора, стабилизатор
4230265 Опора, стабилизатор
4230267 Опора, стабилизатор
LYNXauto C8703 Втулка, стабилизатор
MALÒ 17426 Опора, стабилизатор
MAPCO 53829/1HPS Ремкомплект, подшипник стабилизатора
37898 Опора, стабилизатор
53829/2HPS Ремкомплект, подшипник стабилизатора
37899 Опора, стабилизатор
53898 Ремкомплект, подшипник стабилизатора
53899 Ремкомплект, подшипник стабилизатора
MASTER-SPORT 34717-PCS-MS Опора, стабилизатор
7897M-PCS-MS Опора, стабилизатор
MAXGEAR 72-1343 Опора, стабилизатор
Metalcaucho 05356 Опора, стабилизатор
METZGER 52062709 Кронштейн, подвеска стабилизато
52062609 Опора, стабилизатор
MEYLE 100 511 0011 Опора, стабилизатор
100 511 0013 Опора, стабилизатор
100 511 0016 Кронштейн, подвеска стабилизато
MOOG VO-SB-7897 Втулка, стабилизатор
VO-SB-8444 Втулка, стабилизатор
VO-SB-7171 Втулка, стабилизатор
MOTAQUIP LVSK1029K Опора, стабилизатор
OCAP 1214130 Опора, стабилизатор
1214131 Опора, стабилизатор
1214144 Опора, стабилизатор
OPTIMAL F8-6770 Опора, стабилизатор
F8-7923 Опора, стабилизатор
ORIGINAL IMPERIUM 35156 Опора, стабилизатор
PATRON PSE2071 Опора, стабилизатор
PSE2685 Кронштейн, подвеска стабилизато
PROFIT 2305-0499 Кронштейн, подвеска стабилизато
QUINTON HAZELL EMB7264 Опора, стабилизатор
RUVILLE 985454 Опора, стабилизатор
SASIC 2306013 Опора, стабилизатор
7966004 Ремкомплект, подшипник стабилизатора
7966005 Ремкомплект, подшипник стабилизатора
SIDEM 863902 Опора, стабилизатор
863903 Опора, стабилизатор
863904 Опора, стабилизатор
863901 Опора, стабилизатор
STC T405356 Опора, стабилизатор
STELLOX 79-00574-SX Опора, стабилизатор
79-00056-SX Опора, стабилизатор
SWAG 30 93 2625 Опора, стабилизатор
32 92 3604 Кронштейн, подвеска стабилизато
32 92 3606 Ремкомплект, подшипник стабилизатора
30 93 9648 Ремкомплект, подшипник стабилизатора
32 92 3356 Опора, стабилизатор
30 93 9649 Ремкомплект, подшипник стабилизатора
32 92 3358 Опора, стабилизатор
30 93 2073 Опора, стабилизатор
30 93 9650 Ремкомплект, подшипник стабилизатора
TOPRAN 112 308 Опора, стабилизатор
113 761 Опора, стабилизатор
110 146 Опора, стабилизатор
113 412 Кронштейн, подвеска стабилизато
TRISCAN 8500 29897 Втулка, стабилизатор
8500 298045 Опора, стабилизатор
8500 29898 Втулка, стабилизатор
8500 29895 Втулка, стабилизатор
8500 29896 Втулка, стабилизатор
UNIGOM 391197 Втулка, стабилизатор
392832 Втулка, стабилизатор
VAICO V10-0794 Опора, стабилизатор
V10-3067 Кронштейн, подвеска стабилизато
V10-1555 Опора, стабилизатор
V10-1556 Опора, стабилизатор
V10-0788 Опора, стабилизатор
vika 55110975701 Опора, стабилизатор
55111088301 Кронштейн, подвеска стабилизато
55110975801 Опора, стабилизатор
2026 CATCAR.INFO (v 2.0)