#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV4xMTIwM3x8c3BhcmVfaWQ9PTIwMDU1Ng%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "11203" AND ( (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 434 AND av.DataSupplierArticleNumber = "DE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 4881 AND av.DataSupplierArticleNumber = "610619" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "ED1803" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "ED2303" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 24 AND av.DataSupplierArticleNumber = "EE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 4452 AND av.DataSupplierArticleNumber = "GS-629SHD" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069225115034" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069180100033" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "065220115020" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069185110034" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "067100039690" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "069225110033" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "067100039700" AND av.ProductID IN (1)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "065160100020" AND av.ProductID IN (1)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0167" AND av.ProductID IN (4063)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1820 0127" AND av.ProductID IN (4063)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TF2353" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TE1853" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TE2253" AND av.ProductID IN (1)) OR (av.SupplierID = 212 AND av.DataSupplierArticleNumber = "TF1853" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "680500100E652" AND av.ProductID IN (1)) OR (av.SupplierID = 26 AND av.DataSupplierArticleNumber = "690500105E652" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "66514" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "96351" AND av.ProductID IN (1)) OR (av.SupplierID = 4963 AND av.DataSupplierArticleNumber = "64317" AND av.ProductID IN (1)) OR (av.SupplierID = 4451 AND av.DataSupplierArticleNumber = "629SHD" AND av.ProductID IN (1)) ) 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 = 434 AND aa.DataSupplierArticleNumber = "DF1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DF2353") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE2253") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610619") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE2253") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED1803") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF1853") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED2303") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF2353") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE1853") OR (aa.SupplierID = 4452 AND aa.DataSupplierArticleNumber = "GS-629SHD") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225115034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069180100033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065220115020") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069185110034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039690") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225110033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039700") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065160100020") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0167") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0127") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF2353") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE1853") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE2253") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF1853") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "680500100E652") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "690500105E652") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "66514") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "96351") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "64317") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "629SHD") ) 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 = 434 AND aa.DataSupplierArticleNumber = "DF1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DF2353") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE1853") OR (aa.SupplierID = 434 AND aa.DataSupplierArticleNumber = "DE2253") OR (aa.SupplierID = 4881 AND aa.DataSupplierArticleNumber = "610619") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE2253") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED1803") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF1853") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "ED2303") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EF2353") OR (aa.SupplierID = 24 AND aa.DataSupplierArticleNumber = "EE1853") OR (aa.SupplierID = 4452 AND aa.DataSupplierArticleNumber = "GS-629SHD") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225115034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069180100033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065220115020") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069185110034") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039690") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "069225110033") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "067100039700") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "065160100020") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0167") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1820 0127") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF2353") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE1853") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TE2253") OR (aa.SupplierID = 212 AND aa.DataSupplierArticleNumber = "TF1853") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "680500100E652") OR (aa.SupplierID = 26 AND aa.DataSupplierArticleNumber = "690500105E652") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "66514") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "96351") OR (aa.SupplierID = 4963 AND aa.DataSupplierArticleNumber = "64317") OR (aa.SupplierID = 4451 AND aa.DataSupplierArticleNumber = "629SHD") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||