#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTQ5OTF8fG1kZl9pZD09MF4xNzg3Mnx8c3BhcmVfaWQ9PTEwMDExMg%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 = "17872" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "81728" AND av.ProductID IN (56)) OR (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "81739" AND av.ProductID IN (397)) OR (av.SupplierID = 4533 AND av.DataSupplierArticleNumber = "341329" AND av.ProductID IN (397,397)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "750046N" AND av.ProductID IN (56)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "043022N" AND av.ProductID IN (397)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8MA 376 702-434" AND av.ProductID IN (397)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "CC3009" AND av.ProductID IN (56)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "8684" AND av.ProductID IN (56)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BRC112" AND av.ProductID IN (56)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-551-005" AND av.ProductID IN (56)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-550-006" AND av.ProductID IN (397)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP20155" AND av.ProductID IN (397)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP21798" AND av.ProductID IN (397)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP20392" AND av.ProductID IN (56)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "RC0011" AND av.ProductID IN (56)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "954260" AND av.ProductID IN (397)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "461056" AND av.ProductID IN (56)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "2428" AND av.ProductID IN (56)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "46748" AND av.ProductID IN (397)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40722" AND av.ProductID IN (56)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FRC112" AND av.ProductID IN (56)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "RC228" AND av.ProductID IN (56)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8MA 376 702-434" AND av.ProductID IN (397)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1114800300" AND av.ProductID IN (56)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1114700500" AND av.ProductID IN (397)) OR (av.SupplierID = 469 AND av.DataSupplierArticleNumber = "343640" AND av.ProductID IN (397)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00263001" AND av.ProductID IN (397)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "95333001" AND av.ProductID IN (397)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1540015" AND av.ProductID IN (397)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "28-0315" AND av.ProductID IN (56)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "03677" AND av.ProductID IN (56)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2140017" AND av.ProductID IN (397)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2140060" AND av.ProductID IN (56)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 238 0002" AND av.ProductID IN (56)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 223 0009" AND av.ProductID IN (397)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "44107" AND av.ProductID IN (397)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "44107/I" AND av.ProductID IN (397)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "43016" AND av.ProductID IN (56)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "01414" AND av.ProductID IN (397)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "01686" AND av.ProductID IN (56)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P10-0016" AND av.ProductID IN (397)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "FC520" AND av.ProductID IN (56)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QVE543" AND av.ProductID IN (397)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T403677" AND av.ProductID IN (56)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 94 6748" AND av.ProductID IN (397)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 94 0722" AND av.ProductID IN (56)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "DBW009TT" AND av.ProductID IN (397)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "110 055" AND av.ProductID IN (397)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "111 023" AND av.ProductID IN (56)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "313403" AND av.ProductID IN (56)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "313326" AND av.ProductID IN (56)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "313327" AND av.ProductID IN (56)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "483599" AND av.ProductID IN (397)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8610 23" AND av.ProductID IN (56)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.19.191" AND av.ProductID IN (397)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-0433" AND av.ProductID IN (397)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-0490" AND av.ProductID IN (56)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "11210088401" AND av.ProductID IN (56)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "11210083401" AND av.ProductID IN (397)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795461" AND av.ProductID IN (397)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1769178" AND av.ProductID IN (56)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795658" AND av.ProductID IN (56)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "81728") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "81739") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "341329") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "750046N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "043022N") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8MA 376 702-434") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CC3009") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "8684") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BRC112") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-551-005") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-550-006") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20155") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21798") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20392") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "RC0011") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954260") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461056") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2428") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46748") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40722") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FRC112") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "RC228") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MA 376 702-434") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1114800300") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1114700500") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "343640") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00263001") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95333001") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1540015") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0315") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03677") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2140017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2140060") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 238 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 223 0009") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "44107") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "44107/I") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "43016") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "01414") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "01686") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P10-0016") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "FC520") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QVE543") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403677") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 94 6748") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 94 0722") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DBW009TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 055") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 023") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313403") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313326") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313327") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "483599") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8610 23") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.19.191") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0433") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0490") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11210088401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11210083401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795461") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1769178") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795658") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "81728") OR (aa.SupplierID = 4598 AND aa.DataSupplierArticleNumber = "81739") OR (aa.SupplierID = 4533 AND aa.DataSupplierArticleNumber = "341329") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "750046N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "043022N") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8MA 376 702-434") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "CC3009") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "8684") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BRC112") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-551-005") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-550-006") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20155") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21798") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP20392") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "RC0011") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954260") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "461056") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "2428") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "46748") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40722") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FRC112") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "RC228") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8MA 376 702-434") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1114800300") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1114700500") OR (aa.SupplierID = 469 AND aa.DataSupplierArticleNumber = "343640") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00263001") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95333001") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1540015") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0315") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03677") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2140017") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2140060") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 238 0002") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 223 0009") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "44107") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "44107/I") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "43016") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "01414") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "01686") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P10-0016") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "FC520") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QVE543") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403677") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 94 6748") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 94 0722") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "DBW009TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 055") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "111 023") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313403") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313326") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "313327") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "483599") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8610 23") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.19.191") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0433") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-0490") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11210088401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "11210083401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795461") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1769178") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795658") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||