#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTc1Nzh8fG1kZl9pZD09MF41NjI2M3x8c3BhcmVfaWQ9PTEwNDMzMA%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 = "56263" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654601" AND av.ProductID IN (1390)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654693" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81479" AND av.ProductID IN (1390)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81619" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A07944" AND av.ProductID IN (1390)) OR (av.SupplierID = 4464 AND av.DataSupplierArticleNumber = "A08144" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA4069" AND av.ProductID IN (1390)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "RLA3839" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88206" AND av.ProductID IN (1390)) OR (av.SupplierID = 4463 AND av.DataSupplierArticleNumber = "88106" AND av.ProductID IN (1390)) OR (av.SupplierID = 31 AND av.DataSupplierArticleNumber = "AP9018" AND av.ProductID IN (1390)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "219136" AND av.ProductID IN (1390)) OR (av.SupplierID = 33 AND av.DataSupplierArticleNumber = "OAP7115" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5419 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "3 5416 1" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-761" AND av.ProductID IN (1390)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XU 358 038-901" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1133" AND av.ProductID IN (1390)) OR (av.SupplierID = 4862 AND av.DataSupplierArticleNumber = "30-1069" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0178 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "535 0193 10" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3596" AND av.ProductID IN (1390)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3688" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI19860" AND av.ProductID IN (1390)) OR (av.SupplierID = 4462 AND av.DataSupplierArticleNumber = "FI20360" AND av.ProductID IN (1390)) OR (av.SupplierID = 424 AND av.DataSupplierArticleNumber = "LOPA0137" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1125" AND av.ProductID IN (1390)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "PA-1136" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1113" AND av.ProductID IN (1390)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "F5-1132" AND av.ProductID IN (1390)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P5017810" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3195" AND av.ProductID IN (1390)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3335" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "56650" AND av.ProductID IN (1390)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "59955" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03304" AND av.ProductID IN (1390)) OR (av.SupplierID = 50 AND av.DataSupplierArticleNumber = "VKM 03881" AND av.ProductID IN (1390)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 284006" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253752" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253765" AND av.ProductID IN (1390)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1152073" AND av.ProductID IN (1390)) ) 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 = "654601") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654693") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81479") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81619") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07944") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08144") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4069") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3839") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88206") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88106") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9018") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219136") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7115") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5419 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5416 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-761") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-901") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1133") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1069") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0178 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0193 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3596") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3688") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI19860") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20360") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0137") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1125") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1136") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1113") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1132") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5017810") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3195") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56650") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59955") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03304") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03881") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253752") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253765") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152073") ) 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 = "654601") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654693") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81479") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81619") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A07944") OR (aa.SupplierID = 4464 AND aa.DataSupplierArticleNumber = "A08144") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA4069") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "RLA3839") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88206") OR (aa.SupplierID = 4463 AND aa.DataSupplierArticleNumber = "88106") OR (aa.SupplierID = 31 AND aa.DataSupplierArticleNumber = "AP9018") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "219136") OR (aa.SupplierID = 33 AND aa.DataSupplierArticleNumber = "OAP7115") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5419 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "3 5416 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-761") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XU 358 038-901") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1133") OR (aa.SupplierID = 4862 AND aa.DataSupplierArticleNumber = "30-1069") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0178 10") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "535 0193 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3596") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3688") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI19860") OR (aa.SupplierID = 4462 AND aa.DataSupplierArticleNumber = "FI20360") OR (aa.SupplierID = 424 AND aa.DataSupplierArticleNumber = "LOPA0137") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1125") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "PA-1136") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1113") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "F5-1132") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P5017810") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3195") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3335") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "56650") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "59955") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03304") OR (aa.SupplierID = 50 AND aa.DataSupplierArticleNumber = "VKM 03881") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 284006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253752") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253765") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1152073") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||