#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTk2ODV8fG1kZl9pZD09MF4xMDg3N3x8c3BhcmVfaWQ9PTEwMDc5Mw%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 = "10877"
AND (
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49138"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-48456"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49462"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49268"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-48490"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49680"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49380"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-48814"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-48260"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49842"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "9200-49414"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADB117004"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 258 010 081"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 258 986 602"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 215
AND av.DataSupplierArticleNumber = "LS140194"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "ES20413-12B1"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DOX-0150"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DOX-2005"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "XLS1014"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4005
AND av.DataSupplierArticleNumber = "1.998.078"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4005
AND av.DataSupplierArticleNumber = "1.998.246"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4969
AND av.DataSupplierArticleNumber = "09SKV696"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4969
AND av.DataSupplierArticleNumber = "09SKV703"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4969
AND av.DataSupplierArticleNumber = "09SKV909"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 159
AND av.DataSupplierArticleNumber = "10.8078"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 240
AND av.DataSupplierArticleNumber = "77433"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 240
AND av.DataSupplierArticleNumber = "77494"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26172"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "90344"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "7481091"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "7481744"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4006
AND av.DataSupplierArticleNumber = "498 246"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4006
AND av.DataSupplierArticleNumber = "498 078"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "81744"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "81091"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "0893334"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "0893473"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 15
AND av.DataSupplierArticleNumber = "1579"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 15
AND av.DataSupplierArticleNumber = "96375"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "DOX-0240"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 5
AND av.DataSupplierArticleNumber = "7.05271.74.0"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "90344"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "20-00022-SX"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "62 92 6172"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8845 28009"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8845 28046"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V22-76-0001"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V45-76-0006"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V99-76-0002"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V20-76-0041"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 303
AND av.DataSupplierArticleNumber = "250-24546"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 303
AND av.DataSupplierArticleNumber = "250-24841"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1013872"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1014019"
AND av.ProductID IN (3922))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431135"
AND av.ProductID IN (3922))
)
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 = 442
AND aa.DataSupplierArticleNumber = "9200-49138")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48456")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49462")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49268")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48490")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49680")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49380")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48814")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48260")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49842")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49414")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADB117004")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 258 010 081")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 258 986 602")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "LS140194")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "ES20413-12B1")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DOX-0150")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DOX-2005")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "XLS1014")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.998.078")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.998.246")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV696")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV703")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV909")
OR
(aa.SupplierID = 159
AND aa.DataSupplierArticleNumber = "10.8078")
OR
(aa.SupplierID = 240
AND aa.DataSupplierArticleNumber = "77433")
OR
(aa.SupplierID = 240
AND aa.DataSupplierArticleNumber = "77494")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26172")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "90344")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "7481091")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "7481744")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "498 246")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "498 078")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "81744")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "81091")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "0893334")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "0893473")
OR
(aa.SupplierID = 15
AND aa.DataSupplierArticleNumber = "1579")
OR
(aa.SupplierID = 15
AND aa.DataSupplierArticleNumber = "96375")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "DOX-0240")
OR
(aa.SupplierID = 5
AND aa.DataSupplierArticleNumber = "7.05271.74.0")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "90344")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-00022-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "62 92 6172")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8845 28009")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8845 28046")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-76-0001")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V45-76-0006")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-76-0002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V20-76-0041")
OR
(aa.SupplierID = 303
AND aa.DataSupplierArticleNumber = "250-24546")
OR
(aa.SupplierID = 303
AND aa.DataSupplierArticleNumber = "250-24841")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1013872")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1014019")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431135")
)
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 = 442
AND aa.DataSupplierArticleNumber = "9200-49138")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48456")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49462")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49268")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48490")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49680")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49380")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48814")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-48260")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49842")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "9200-49414")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADB117004")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 258 010 081")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 258 986 602")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "LS140194")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "ES20413-12B1")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DOX-0150")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DOX-2005")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "XLS1014")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.998.078")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.998.246")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV696")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV703")
OR
(aa.SupplierID = 4969
AND aa.DataSupplierArticleNumber = "09SKV909")
OR
(aa.SupplierID = 159
AND aa.DataSupplierArticleNumber = "10.8078")
OR
(aa.SupplierID = 240
AND aa.DataSupplierArticleNumber = "77433")
OR
(aa.SupplierID = 240
AND aa.DataSupplierArticleNumber = "77494")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26172")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "90344")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "7481091")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "7481744")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "498 246")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "498 078")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "81744")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "81091")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "0893334")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "0893473")
OR
(aa.SupplierID = 15
AND aa.DataSupplierArticleNumber = "1579")
OR
(aa.SupplierID = 15
AND aa.DataSupplierArticleNumber = "96375")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "DOX-0240")
OR
(aa.SupplierID = 5
AND aa.DataSupplierArticleNumber = "7.05271.74.0")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "90344")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-00022-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "62 92 6172")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8845 28009")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8845 28046")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-76-0001")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V45-76-0006")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-76-0002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V20-76-0041")
OR
(aa.SupplierID = 303
AND aa.DataSupplierArticleNumber = "250-24546")
OR
(aa.SupplierID = 303
AND aa.DataSupplierArticleNumber = "250-24841")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1013872")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1014019")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431135")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Лямбда-регулирование для автомобилей