#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2OHx8bW9kZWxfaWQ9PTk0fHxtZGZfaWQ9PTBeMTM4NTN8fHNwYXJlX2lkPT0xMDA0MDY%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 = "13853" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "641209" AND av.ProductID IN (308)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.134" AND av.ProductID IN (308)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TDI3319" AND av.ProductID IN (308)) OR (av.SupplierID = 42 AND av.DataSupplierArticleNumber = "ATB2156" AND av.ProductID IN (308)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DT17310" AND av.ProductID IN (308)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "T3558" AND av.ProductID IN (308)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08467" AND av.ProductID IN (308)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FS06209" AND av.ProductID IN (308)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "T41169" AND av.ProductID IN (308)) OR (av.SupplierID = 239 AND av.DataSupplierArticleNumber = "HTG 122" AND av.ProductID IN (308)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "531 0075 10" AND av.ProductID IN (308)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "14-0204" AND av.ProductID IN (308)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "4412200109" AND av.ProductID IN (308)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1228340" AND av.ProductID IN (308)) OR (av.SupplierID = 197 AND av.DataSupplierArticleNumber = "AA10132" AND av.ProductID IN (308)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "23664" AND av.ProductID IN (308)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "45-51 902 1001" AND av.ProductID IN (308)) OR (av.SupplierID = 64 AND av.DataSupplierArticleNumber = "258ST" AND av.ProductID IN (308)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N894" AND av.ProductID IN (308)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT436FK" AND av.ProductID IN (4644)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTT436" AND av.ProductID IN (308)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1140" AND av.ProductID IN (308)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56104" AND av.ProductID IN (308)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 17310" AND av.ProductID IN (308)) OR (av.SupplierID = 110 AND av.DataSupplierArticleNumber = "GT361.05" AND av.ProductID IN (308)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "22 03 0001" AND av.ProductID IN (308)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8646 17103" AND av.ProductID IN (308)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V49-0007" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1097431" AND av.ProductID IN (308)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428182" AND av.ProductID IN (308)) ) 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 = "641209") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.134") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3319") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2156") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT17310") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T3558") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08467") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS06209") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T41169") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 122") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0075 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0204") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4412200109") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228340") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10132") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23664") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "45-51 902 1001") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "258ST") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N894") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436FK") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1140") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56104") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 17310") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT361.05") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "22 03 0001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 17103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V49-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1097431") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428182") ) 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 = "641209") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.134") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TDI3319") OR (aa.SupplierID = 42 AND aa.DataSupplierArticleNumber = "ATB2156") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DT17310") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "T3558") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08467") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FS06209") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "T41169") OR (aa.SupplierID = 239 AND aa.DataSupplierArticleNumber = "HTG 122") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "531 0075 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "14-0204") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "4412200109") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1228340") OR (aa.SupplierID = 197 AND aa.DataSupplierArticleNumber = "AA10132") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "23664") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "45-51 902 1001") OR (aa.SupplierID = 64 AND aa.DataSupplierArticleNumber = "258ST") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N894") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436FK") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTT436") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1140") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56104") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 17310") OR (aa.SupplierID = 110 AND aa.DataSupplierArticleNumber = "GT361.05") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "22 03 0001") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8646 17103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V49-0007") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1097431") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428182") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||