#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTg2MDl8fG1kZl9pZD09MF4zMzMyOHx8c3BhcmVfaWQ9PTEwMDQ3OA%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 = "33328"
AND (
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BOP1004"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4815
AND av.DataSupplierArticleNumber = "B13138"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4815
AND av.DataSupplierArticleNumber = "B13137"
AND av.ProductID IN (805))
OR
(av.SupplierID = 215
AND av.DataSupplierArticleNumber = "OS3572"
AND av.ProductID IN (805))
OR
(av.SupplierID = 215
AND av.DataSupplierArticleNumber = "OS3606"
AND av.ProductID IN (805))
OR
(av.SupplierID = 215
AND av.DataSupplierArticleNumber = "OS3636"
AND av.ProductID IN (805))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "SW90024"
AND av.ProductID IN (805))
OR
(av.SupplierID = 10
AND av.DataSupplierArticleNumber = "351.210"
AND av.ProductID IN (4176))
OR
(av.SupplierID = 4005
AND av.DataSupplierArticleNumber = "1.800.139"
AND av.ProductID IN (805))
OR
(av.SupplierID = 159
AND av.DataSupplierArticleNumber = "7.0139"
AND av.ProductID IN (805))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FOP1004"
AND av.ProductID IN (805))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "6ZL 008 280-051"
AND av.ProductID IN (805))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "6ZL 003 259-971"
AND av.ProductID IN (805))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "6ZL 008 280-001"
AND av.ProductID IN (805))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "70684001"
AND av.ProductID IN (1289))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1193500600"
AND av.ProductID IN (805))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1193500800"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4006
AND av.DataSupplierArticleNumber = "500 139"
AND av.ProductID IN (805))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "510050010500"
AND av.ProductID IN (805))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "114 820 0003"
AND av.ProductID IN (805))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "114 820 0001"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVRP105"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVRP296"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PE70055"
AND av.ProductID IN (805))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "XOPS121"
AND av.ProductID IN (805))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "XOPS225"
AND av.ProductID IN (805))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "3706001"
AND av.ProductID IN (805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "OPS2116"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "LOPS094"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "LOPS053"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "51120"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "SOP104"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "OPS2112"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "51166"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 269
AND av.DataSupplierArticleNumber = "SOP015"
AND av.ProductID IN (805,805))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "108 891"
AND av.ProductID IN (805))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V15-99-1999"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4346
AND av.DataSupplierArticleNumber = "99190071201"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4346
AND av.DataSupplierArticleNumber = "19070731001"
AND av.ProductID IN (1289))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1499706"
AND av.ProductID IN (805))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1380171"
AND av.ProductID IN (4176))
)
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 = 475
AND aa.DataSupplierArticleNumber = "BOP1004")
OR
(aa.SupplierID = 4815
AND aa.DataSupplierArticleNumber = "B13138")
OR
(aa.SupplierID = 4815
AND aa.DataSupplierArticleNumber = "B13137")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3572")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3606")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3636")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "SW90024")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "351.210")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.800.139")
OR
(aa.SupplierID = 159
AND aa.DataSupplierArticleNumber = "7.0139")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FOP1004")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 008 280-051")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 003 259-971")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 008 280-001")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "70684001")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1193500600")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1193500800")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "500 139")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "510050010500")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 820 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 820 0001")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVRP105")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVRP296")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PE70055")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "XOPS121")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "XOPS225")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "3706001")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "OPS2116")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "LOPS094")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "LOPS053")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "51120")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "SOP104")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "OPS2112")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "51166")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "SOP015")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "108 891")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V15-99-1999")
OR
(aa.SupplierID = 4346
AND aa.DataSupplierArticleNumber = "99190071201")
OR
(aa.SupplierID = 4346
AND aa.DataSupplierArticleNumber = "19070731001")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1499706")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1380171")
)
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 = 475
AND aa.DataSupplierArticleNumber = "BOP1004")
OR
(aa.SupplierID = 4815
AND aa.DataSupplierArticleNumber = "B13138")
OR
(aa.SupplierID = 4815
AND aa.DataSupplierArticleNumber = "B13137")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3572")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3606")
OR
(aa.SupplierID = 215
AND aa.DataSupplierArticleNumber = "OS3636")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "SW90024")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "351.210")
OR
(aa.SupplierID = 4005
AND aa.DataSupplierArticleNumber = "1.800.139")
OR
(aa.SupplierID = 159
AND aa.DataSupplierArticleNumber = "7.0139")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FOP1004")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 008 280-051")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 003 259-971")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "6ZL 008 280-001")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "70684001")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1193500600")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1193500800")
OR
(aa.SupplierID = 4006
AND aa.DataSupplierArticleNumber = "500 139")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "510050010500")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 820 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 820 0001")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVRP105")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVRP296")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PE70055")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "XOPS121")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "XOPS225")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "3706001")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "OPS2116")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "LOPS094")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "LOPS053")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "51120")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "SOP104")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "OPS2112")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "51166")
OR
(aa.SupplierID = 269
AND aa.DataSupplierArticleNumber = "SOP015")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "108 891")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V15-99-1999")
OR
(aa.SupplierID = 4346
AND aa.DataSupplierArticleNumber = "99190071201")
OR
(aa.SupplierID = 4346
AND aa.DataSupplierArticleNumber = "19070731001")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1499706")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1380171")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Датчик давления масла / клапан для автомобилей