#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM1MHx8bWRmX2lkPT0wXjkyMjV8fHNwYXJlX2lkPT0xMDE2NjM%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 = "9225" AND ( (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10017" AND av.ProductID IN (108)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10015" AND av.ProductID IN (108)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10016" AND av.ProductID IN (108)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17464" AND av.ProductID IN (108)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "20729" AND av.ProductID IN (108)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17117" AND av.ProductID IN (108)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0804850" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355B-02" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355-02" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355Y" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355B" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355B-01" AND av.ProductID IN (108)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10355-01" AND av.ProductID IN (108)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "78-0007" AND av.ProductID IN (108)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "78-0087" AND av.ProductID IN (108)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "48335" AND av.ProductID IN (108)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "48633" AND av.ProductID IN (108)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "48321" AND av.ProductID IN (108)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N453" AND av.ProductID IN (108)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N453-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64151NBU-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64151-01B" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64151CBI" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64151NBU" AND av.ProductID IN (108)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64151" AND av.ProductID IN (108)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PLH3-12/55" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12336PRC1" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12336WHVB1" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12336LLECOC1" AND av.ProductID IN (108)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12336PRB1" AND av.ProductID IN (108)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "202723" AND av.ProductID IN (108)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "202020" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "53185" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "53186" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "53100" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL53162" AND av.ProductID IN (108)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "53162" AND av.ProductID IN (108)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032005" AND av.ProductID IN (108)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032004" AND av.ProductID IN (108)) ) 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 = 253 AND aa.DataSupplierArticleNumber = "LID10017") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10015") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10016") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17464") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "20729") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17117") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0804850") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355Y") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355-01") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0007") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0087") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48335") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48633") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48321") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N453") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N453-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLH3-12/55") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336LLECOC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336PRB1") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "202723") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "202020") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53100") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL53162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53162") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032005") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032004") ) 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 = 253 AND aa.DataSupplierArticleNumber = "LID10017") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10015") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10016") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17464") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "20729") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17117") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0804850") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355Y") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355B-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10355-01") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0007") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0087") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48335") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48633") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "48321") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N453") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N453-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64151") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLH3-12/55") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336LLECOC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12336PRB1") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "202723") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "202020") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53100") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL53162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "53162") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032005") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032004") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||