#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTE4MDZ8fG1kZl9pZD09MF4xODg3MXx8c3BhcmVfaWQ9PTEwMDc4OQ%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 = "18871" AND ( (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS3304" 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 = "OS6306" AND av.ProductID IN (572)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "N10002BTA" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12013882B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20011244B" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12013858B" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS697" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS698" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76200-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-305272-00" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "33-131120-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1151580" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NB628" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NB691" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00028-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00065-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00002-SX" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10029" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10021" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10028" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1803" AND av.ProductID IN (757)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1803-1" AND av.ProductID IN (757)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1802" AND av.ProductID IN (757)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-21343-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1249930" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004517" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177371" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1226435" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177373" 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 = 478 AND aa.DataSupplierArticleNumber = "OS3304") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS6306") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013882B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20011244B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013858B") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS697") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS698") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76200-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-305272-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "33-131120-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1151580") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB628") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB691") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00028-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00065-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00002-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10029") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10021") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803-1") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-21343-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004517") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177371") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177373") ) 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 = 478 AND aa.DataSupplierArticleNumber = "OS3304") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS6306") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013882B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20011244B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013858B") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS697") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS698") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76200-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-305272-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "33-131120-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1151580") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB628") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB691") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00028-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00065-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00002-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10029") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10021") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803-1") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-21343-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004517") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177371") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177373") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||