#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTYyMjR8fG1kZl9pZD09MF4yMzEzOHx8c3BhcmVfaWQ9PTEwMDc0MA%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 = "23138" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518970P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518922P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518971P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518923P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518972P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518924P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518921P" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672162" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672069" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8301672" AND av.ProductID IN (1249)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672163" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672146" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672066" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672147" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672068" AND av.ProductID IN (1002)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44739" AND av.ProductID IN (3881)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "3518922" AND av.ProductID IN (1002)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "3518921" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME0291244" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME4401253" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME4401254" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME0291243" AND av.ProductID IN (1002)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 4739" AND av.ProductID IN (3881)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3097481" AND av.ProductID IN (1002)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3097482" AND av.ProductID IN (1002)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518970P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518922P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518971P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518923P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518972P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518924P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518921P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672162") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672069") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8301672") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672163") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672147") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672068") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44739") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518922") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518921") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291244") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401253") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401254") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291243") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 4739") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097481") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097482") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518970P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518922P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518971P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518923P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518972P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518924P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518921P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672162") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672069") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8301672") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672163") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672147") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672068") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44739") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518922") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518921") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291244") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401253") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401254") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291243") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 4739") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097481") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097482") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||