#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTE4OTF8fG1kZl9pZD09MF4xNTY2Mnx8c3BhcmVfaWQ9PTEwMTc3Nw%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 = "15662" AND ( (av.SupplierID = 4576 AND av.DataSupplierArticleNumber = "56363" AND av.ProductID IN (514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100040910" AND av.ProductID IN (514,514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100016110" AND av.ProductID IN (514,514)) OR (av.SupplierID = 323 AND av.DataSupplierArticleNumber = "100040610" AND av.ProductID IN (514,514)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B14187" AND av.ProductID IN (514)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "GS10249" AND av.ProductID IN (514)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "9102400" AND av.ProductID IN (514)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1010260003" AND av.ProductID IN (514)) OR (av.SupplierID = 4345 AND av.DataSupplierArticleNumber = "1010260020" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2002993" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2000233" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "27693" AND av.ProductID IN (514)) OR (av.SupplierID = 271 AND av.DataSupplierArticleNumber = "A908019" AND av.ProductID IN (514)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "13 18 03-91" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "312014" AND av.ProductID IN (514)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00142800" AND av.ProductID IN (514)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "8500047" AND av.ProductID IN (514)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8004214" AND av.ProductID IN (514)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8004212" AND av.ProductID IN (514)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "101-00-006" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719026500" AND av.ProductID IN (514)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127266" AND av.ProductID IN (514)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "20968" AND av.ProductID IN (514)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "12-0039" AND av.ProductID IN (514)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "140 161 0062" AND av.ProductID IN (514)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5678" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RAU022" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RVW021" AND av.ProductID IN (514)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "AG-17089" AND av.ProductID IN (514)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS9968GI" AND av.ProductID IN (514)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PGS8945NP" AND av.ProductID IN (514)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTS128347" AND av.ProductID IN (514)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0673" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "9968GI" AND av.ProductID IN (514)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-10232-SX" AND av.ProductID IN (514)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "11-40159-SX" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 7693" AND av.ProductID IN (514)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 054" AND av.ProductID IN (514)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 29107" AND av.ProductID IN (514)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1947" AND av.ProductID IN (514)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "GF-1064" AND av.ProductID IN (514)) ) 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 = 4576 AND aa.DataSupplierArticleNumber = "56363") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040910") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100016110") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040610") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B14187") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "GS10249") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9102400") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260003") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260020") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002993") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2000233") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27693") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "A908019") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 18 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "312014") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00142800") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "8500047") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004214") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004212") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-006") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719026500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127266") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "20968") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "12-0039") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "140 161 0062") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5678") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RAU022") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RVW021") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17089") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS9968GI") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8945NP") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128347") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0673") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "9968GI") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-10232-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-40159-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7693") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 054") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 29107") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1947") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1064") ) 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 = 4576 AND aa.DataSupplierArticleNumber = "56363") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040910") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100016110") OR (aa.SupplierID = 323 AND aa.DataSupplierArticleNumber = "100040610") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B14187") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "GS10249") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "9102400") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260003") OR (aa.SupplierID = 4345 AND aa.DataSupplierArticleNumber = "1010260020") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002993") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2000233") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "27693") OR (aa.SupplierID = 271 AND aa.DataSupplierArticleNumber = "A908019") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "13 18 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "312014") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00142800") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "8500047") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004214") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8004212") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-006") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719026500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127266") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "20968") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "12-0039") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "140 161 0062") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5678") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RAU022") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RVW021") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "AG-17089") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS9968GI") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PGS8945NP") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTS128347") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0673") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "9968GI") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-10232-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "11-40159-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 7693") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 054") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 29107") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1947") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "GF-1064") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||