#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ2ODh8fG1kZl9pZD09MF4xNTEyN3x8c3BhcmVfaWQ9PTEwMDUyMQ%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 = "15127" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15012600" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15033800" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5317" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5376" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS3371" AND av.ProductID IN (572)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "N10002BTA" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19027853B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12016300B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "289128" AND av.ProductID IN (3874)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "702.269" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "034.530" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS2188" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS006" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1205" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319161-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NJ006" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NF678" AND av.ProductID IN (572)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "820 222" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183532" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085457" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1755322" AND av.ProductID IN (3874)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183601" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163050" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190104" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163208" AND av.ProductID IN (572)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "15012600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15033800") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5376") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS3371") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19027853B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12016300B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "289128") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "702.269") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "034.530") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS2188") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS006") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1205") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319161-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NF678") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "820 222") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183532") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085457") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755322") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183601") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163050") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163208") ) 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 = 139 AND aa.DataSupplierArticleNumber = "15012600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15033800") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5376") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS3371") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19027853B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12016300B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "289128") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "702.269") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "034.530") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS2188") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS006") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1205") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319161-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NF678") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "820 222") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183532") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085457") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1755322") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183601") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163050") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163208") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||