#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTg1fHxtZGZfaWQ9PTBeNzE2OHx8c3BhcmVfaWQ9PTEwMTcxMA%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 = "7168"
AND (
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6505-04-5049387P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-5049551P"
AND av.ProductID IN (755))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6505-04-5049388P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-5049541P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-5049552P"
AND av.ProductID IN (755))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6505-04-5049547P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-5049542P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6505-04-5049548P"
AND av.ProductID IN (1560))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9316431"
AND av.ProductID IN (755))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9316432"
AND av.ProductID IN (755))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "5049542"
AND av.ProductID IN (755))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "5049551"
AND av.ProductID IN (755))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "5049552"
AND av.ProductID IN (755))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "5049541"
AND av.ProductID IN (755))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "168530136"
AND av.ProductID IN (1184))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "168530047"
AND av.ProductID IN (1184))
OR
(av.SupplierID = 340
AND av.DataSupplierArticleNumber = "OP0090552"
AND av.ProductID IN (755))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "3730346"
AND av.ProductID IN (755))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "3730347"
AND av.ProductID IN (755))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "3730348"
AND av.ProductID IN (755))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "3730345"
AND av.ProductID IN (755))
)
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 = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049387P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049551P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049388P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049541P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049552P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049547P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049542P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049548P")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9316431")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9316432")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049542")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049551")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049552")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049541")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "168530136")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "168530047")
OR
(aa.SupplierID = 340
AND aa.DataSupplierArticleNumber = "OP0090552")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730346")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730347")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730348")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730345")
)
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 = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049387P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049551P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049388P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049541P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049552P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049547P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-5049542P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6505-04-5049548P")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9316431")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9316432")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049542")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049551")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049552")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "5049541")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "168530136")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "168530047")
OR
(aa.SupplierID = 340
AND aa.DataSupplierArticleNumber = "OP0090552")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730346")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730347")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730348")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "3730345")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Колесная ниша для автомобилей