#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTU0MjV8fG1kZl9pZD09MF4xOTI2MXx8c3BhcmVfaWQ9PTEwMDE5OQ%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 = "19261" AND ( (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2203" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2201L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1324" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2203L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2202" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1324L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "PUM1134" AND av.ProductID IN (12)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1310" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2202L" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS2201" AND av.ProductID IN (286)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "PUM1200" AND av.ProductID IN (12)) OR (av.SupplierID = 4534 AND av.DataSupplierArticleNumber = "TS1310L" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 001" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 153" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 002" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 121" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 807" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 151" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 777" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 122" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 001 979" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S00 000 152" AND av.ProductID IN (12)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 001 811" AND av.ProductID IN (286)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "K S01 000 123" AND av.ProductID IN (12)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSB77101RS" AND av.ProductID IN (286)) OR (av.SupplierID = 484 AND av.DataSupplierArticleNumber = "CSP77300GS" AND av.ProductID IN (12)) OR (av.SupplierID = 4882 AND av.DataSupplierArticleNumber = "IDRO008N" AND av.ProductID IN (12)) OR (av.SupplierID = 4882 AND av.DataSupplierArticleNumber = "IDRO134N" AND av.ProductID IN (12)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521136" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521381" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "719520356" AND av.ProductID IN (12)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521382" AND av.ProductID IN (286)) OR (av.SupplierID = 460 AND av.DataSupplierArticleNumber = "711521383" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1381" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1382" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "19-0356" AND av.ProductID IN (12)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1383" AND av.ProductID IN (286)) OR (av.SupplierID = 226 AND av.DataSupplierArticleNumber = "11-1136" AND av.ProductID IN (286)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SP85187" AND av.ProductID IN (12)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SR22154" AND av.ProductID IN (286)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SP85188" AND av.ProductID IN (12)) OR (av.SupplierID = 224 AND av.DataSupplierArticleNumber = "SR23037" AND av.ProductID IN (286)) OR (av.SupplierID = 316 AND av.DataSupplierArticleNumber = "PEI002" AND av.ProductID IN (12)) OR (av.SupplierID = 316 AND av.DataSupplierArticleNumber = "PEI031" AND av.ProductID IN (12)) OR (av.SupplierID = 4496 AND av.DataSupplierArticleNumber = "56.0014" AND av.ProductID IN (12)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "EP5010" AND av.ProductID IN (12)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "SGA133L" AND av.ProductID IN (286)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "SGA162L" AND av.ProductID IN (286)) OR (av.SupplierID = 293 AND av.DataSupplierArticleNumber = "EP5009" AND av.ProductID IN (12)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "04.55.1400" AND av.ProductID IN (12)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "01.62.7802" AND av.ProductID IN (286)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "01.62.7830" AND av.ProductID IN (286)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "29859" AND av.ProductID IN (286)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "29990" AND av.ProductID IN (417)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0602138-K" AND av.ProductID IN (3080)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0602139-K" AND av.ProductID IN (3080)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1570" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1567" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRPA737" AND av.ProductID IN (12)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1568" AND av.ProductID IN (286)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QSRP1569" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR1706L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR2140L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSP1638" AND av.ProductID IN (12)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR731L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR1705L" AND av.ProductID IN (286)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSP1639" AND av.ProductID IN (12)) OR (av.SupplierID = 214 AND av.DataSupplierArticleNumber = "DSR776L" AND av.ProductID IN (286)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7076080" AND av.ProductID IN (12)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "7176033" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "51662" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "54459" AND av.ProductID IN (12)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "51633" AND av.ProductID IN (286)) OR (av.SupplierID = 1 AND av.DataSupplierArticleNumber = "54458" AND av.ProductID IN (12)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8510 24416" AND av.ProductID IN (286)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8515 24626" AND av.ProductID IN (12)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8510 24417" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRP866" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JER142" AND av.ProductID IN (12)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRP867" AND av.ProductID IN (286)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JER107" AND av.ProductID IN (12)) OR (av.SupplierID = 155 AND av.DataSupplierArticleNumber = "30-79029" AND av.ProductID IN (286)) OR (av.SupplierID = 155 AND av.DataSupplierArticleNumber = "30-79030" AND av.ProductID IN (286)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "BEGM94" AND av.ProductID IN (12)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "GM65" AND av.ProductID IN (286)) OR (av.SupplierID = 429 AND av.DataSupplierArticleNumber = "BEGM93" AND av.ProductID IN (12)) ) 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 = 4534 AND aa.DataSupplierArticleNumber = "TS2203") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2203L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1134") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1200") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310L") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 001") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 153") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 002") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 121") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 807") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 151") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 777") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 001 979") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 152") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 811") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 123") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSB77101RS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP77300GS") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO008N") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO134N") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521136") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521381") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "719520356") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521382") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1381") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1382") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "19-0356") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1136") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85187") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR22154") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85188") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR23037") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI002") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI031") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "56.0014") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5010") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA133L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA162L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5009") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "04.55.1400") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7802") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7830") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29859") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29990") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602138-K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602139-K") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1570") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1567") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRPA737") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1568") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1569") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1706L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR2140L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1638") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR731L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1705L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1639") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR776L") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7076080") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7176033") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51662") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54459") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51633") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54458") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24416") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8515 24626") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24417") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP866") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER142") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP867") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER107") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79029") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79030") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM94") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "GM65") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM93") ) 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 = 4534 AND aa.DataSupplierArticleNumber = "TS2203") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2203L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1324L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1134") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2202L") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS2201") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "PUM1200") OR (aa.SupplierID = 4534 AND aa.DataSupplierArticleNumber = "TS1310L") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 001") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 153") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 002") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 121") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 807") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 151") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 777") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 001 979") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S00 000 152") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 001 811") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "K S01 000 123") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSB77101RS") OR (aa.SupplierID = 484 AND aa.DataSupplierArticleNumber = "CSP77300GS") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO008N") OR (aa.SupplierID = 4882 AND aa.DataSupplierArticleNumber = "IDRO134N") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521136") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521381") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "719520356") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521382") OR (aa.SupplierID = 460 AND aa.DataSupplierArticleNumber = "711521383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1381") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1382") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "19-0356") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1383") OR (aa.SupplierID = 226 AND aa.DataSupplierArticleNumber = "11-1136") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85187") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR22154") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SP85188") OR (aa.SupplierID = 224 AND aa.DataSupplierArticleNumber = "SR23037") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI002") OR (aa.SupplierID = 316 AND aa.DataSupplierArticleNumber = "PEI031") OR (aa.SupplierID = 4496 AND aa.DataSupplierArticleNumber = "56.0014") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5010") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA133L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "SGA162L") OR (aa.SupplierID = 293 AND aa.DataSupplierArticleNumber = "EP5009") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "04.55.1400") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7802") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "01.62.7830") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29859") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "29990") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602138-K") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0602139-K") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1570") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1567") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRPA737") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1568") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QSRP1569") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1706L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR2140L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1638") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR731L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR1705L") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSP1639") OR (aa.SupplierID = 214 AND aa.DataSupplierArticleNumber = "DSR776L") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7076080") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "7176033") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51662") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54459") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "51633") OR (aa.SupplierID = 1 AND aa.DataSupplierArticleNumber = "54458") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24416") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8515 24626") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8510 24417") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP866") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER142") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRP867") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JER107") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79029") OR (aa.SupplierID = 155 AND aa.DataSupplierArticleNumber = "30-79030") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM94") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "GM65") OR (aa.SupplierID = 429 AND aa.DataSupplierArticleNumber = "BEGM93") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||