#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTgwfHxtZGZfaWQ9PTBeNjM3fHxzcGFyZV9pZD09MTAwODI2&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 = "637" AND ( (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003813" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003853" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003973" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2003733" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "55 05 95-96" AND av.ProductID IN (219)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1281200609" AND av.ProductID IN (219)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "444021" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8163421" AND av.ProductID IN (219)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719089800" AND av.ProductID IN (2454)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719089900" AND av.ProductID IN (2454)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127162" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5834" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5835" AND av.ProductID IN (219)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "ROP014" AND av.ProductID IN (219)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17184" AND av.ProductID IN (219)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17220" AND av.ProductID IN (219)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8339BK" AND av.ProductID IN (219)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8453BV" AND av.ProductID IN (219)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128295" AND av.ProductID IN (219)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128331" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0317" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "8339BK" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "8985BM" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20814-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20834-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-20839-SX" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 2413" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 2412" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0731" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0733" AND av.ProductID IN (219)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "51227" AND av.ProductID IN (219,219)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1060" AND av.ProductID IN (219)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1059" AND av.ProductID IN (219)) ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2003813") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003853") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003973") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003733") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "55 05 95-96") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1281200609") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "444021") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8163421") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089800") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089900") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127162") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5835") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "ROP014") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17184") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17220") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8339BK") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8453BV") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128295") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128331") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0317") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8339BK") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8985BM") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20814-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20834-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20839-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2413") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2412") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0731") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0733") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51227") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1060") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1059") ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2003813") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003853") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003973") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2003733") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "55 05 95-96") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1281200609") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "444021") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8163421") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089800") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719089900") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127162") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5834") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5835") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "ROP014") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17184") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17220") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8339BK") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8453BV") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128295") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128331") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0317") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8339BK") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "8985BM") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20814-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20834-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-20839-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2413") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 2412") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0731") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0733") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51227") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1060") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1059") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||