#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTEyOTJ8fG1vZGVsX2lkPT00NjY5fHxtZGZfaWQ9PTBeMzIxMXx8c3BhcmVfaWQ9PTEwMDA3MQ%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 = "3211"
AND (
(av.SupplierID = 4533
AND av.DataSupplierArticleNumber = "214671"
AND av.ProductID IN (5))
OR
(av.SupplierID = 4631
AND av.DataSupplierArticleNumber = "LR-08A60"
AND av.ProductID IN (5))
OR
(av.SupplierID = 300
AND av.DataSupplierArticleNumber = "821918"
AND av.ProductID IN (5))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DCV830002"
AND av.ProductID IN (5))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "CVN9268"
AND av.ProductID IN (5))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "CVN9287"
AND av.ProductID IN (5))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "CVN9270"
AND av.ProductID IN (5))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "CVN9271"
AND av.ProductID IN (5))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "CVN9286"
AND av.ProductID IN (5))
OR
(av.SupplierID = 373
AND av.DataSupplierArticleNumber = "830002"
AND av.ProductID IN (5))
OR
(av.SupplierID = 56
AND av.DataSupplierArticleNumber = "301084"
AND av.ProductID IN (236))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "76950"
AND av.ProductID IN (236))
OR
(av.SupplierID = 4653
AND av.DataSupplierArticleNumber = "12-271653"
AND av.ProductID IN (5))
OR
(av.SupplierID = 4690
AND av.DataSupplierArticleNumber = "G1K023PC"
AND av.ProductID IN (236))
OR
(av.SupplierID = 492
AND av.DataSupplierArticleNumber = "LR80"
AND av.ProductID IN (5))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "78003S"
AND av.ProductID IN (5))
OR
(av.SupplierID = 431
AND av.DataSupplierArticleNumber = "21510"
AND av.ProductID IN (236))
OR
(av.SupplierID = 4607
AND av.DataSupplierArticleNumber = "CV106N"
AND av.ProductID IN (236))
OR
(av.SupplierID = 4472
AND av.DataSupplierArticleNumber = "40-0591"
AND av.ProductID IN (5))
)
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 = 4533
AND aa.DataSupplierArticleNumber = "214671")
OR
(aa.SupplierID = 4631
AND aa.DataSupplierArticleNumber = "LR-08A60")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "821918")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCV830002")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9268")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9287")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9270")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9271")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9286")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "830002")
OR
(aa.SupplierID = 56
AND aa.DataSupplierArticleNumber = "301084")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "76950")
OR
(aa.SupplierID = 4653
AND aa.DataSupplierArticleNumber = "12-271653")
OR
(aa.SupplierID = 4690
AND aa.DataSupplierArticleNumber = "G1K023PC")
OR
(aa.SupplierID = 492
AND aa.DataSupplierArticleNumber = "LR80")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "78003S")
OR
(aa.SupplierID = 431
AND aa.DataSupplierArticleNumber = "21510")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "CV106N")
OR
(aa.SupplierID = 4472
AND aa.DataSupplierArticleNumber = "40-0591")
)
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 = 4533
AND aa.DataSupplierArticleNumber = "214671")
OR
(aa.SupplierID = 4631
AND aa.DataSupplierArticleNumber = "LR-08A60")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "821918")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCV830002")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9268")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9287")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9270")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9271")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "CVN9286")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "830002")
OR
(aa.SupplierID = 56
AND aa.DataSupplierArticleNumber = "301084")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "76950")
OR
(aa.SupplierID = 4653
AND aa.DataSupplierArticleNumber = "12-271653")
OR
(aa.SupplierID = 4690
AND aa.DataSupplierArticleNumber = "G1K023PC")
OR
(aa.SupplierID = 492
AND aa.DataSupplierArticleNumber = "LR80")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "78003S")
OR
(aa.SupplierID = 431
AND aa.DataSupplierArticleNumber = "21510")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "CV106N")
OR
(aa.SupplierID = 4472
AND aa.DataSupplierArticleNumber = "40-0591")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Карданный шарнир / комплект для автомобилей