#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTgwMzN8fG1kZl9pZD09MF4xMTg5MHx8c3BhcmVfaWQ9PTEwMDM5OA%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 = "11890" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955212" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955216" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955213" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955214" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955211" AND av.ProductID IN (561)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955215" AND av.ProductID IN (561)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "RA0900" AND av.ProductID IN (432)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "R973S" AND av.ProductID IN (432)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "31268" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0225 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0222 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0226 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0223 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0224 10" AND av.ProductID IN (561)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "422 0221 10" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4210" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4207" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4211" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4208" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4209" AND av.ProductID IN (561)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4206" AND av.ProductID IN (561)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50006129" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235012" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235008" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235009" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235006" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235010" AND av.ProductID IN (561)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "235007" AND av.ProductID IN (561)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 93 1268" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428003" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250959" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1490846" AND av.ProductID IN (432,561,561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250956" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250960" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250957" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250961" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250958" AND av.ProductID IN (561)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1017523" AND av.ProductID IN (561)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "955212") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955216") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955213") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955214") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955211") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955215") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RA0900") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "R973S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31268") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0225 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0222 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0226 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0223 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0224 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0221 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4210") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4207") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4211") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4208") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4209") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4206") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006129") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235012") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235008") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235009") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235006") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235007") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 93 1268") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250959") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1490846") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250956") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250957") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250958") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017523") ) 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 = 300 AND aa.DataSupplierArticleNumber = "955212") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955216") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955213") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955214") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955211") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955215") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "RA0900") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "R973S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "31268") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0225 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0222 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0226 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0223 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0224 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "422 0221 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4210") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4207") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4211") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4208") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4209") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4206") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006129") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235012") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235008") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235009") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235006") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235010") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "235007") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 93 1268") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250959") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1490846") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250956") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250960") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250957") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250961") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250958") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017523") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||