#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTUzOTB8fG1kZl9pZD09MF4xODQ1NHx8c3BhcmVfaWQ9PTEwMDA1MQ%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 = "18454"
AND (
(av.SupplierID = 487
AND av.DataSupplierArticleNumber = "KT90044"
AND av.ProductID IN (479))
OR
(av.SupplierID = 487
AND av.DataSupplierArticleNumber = "KT90453"
AND av.ProductID IN (479))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "HK7625"
AND av.ProductID IN (479))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "ECK081"
AND av.ProductID IN (479))
OR
(av.SupplierID = 399
AND av.DataSupplierArticleNumber = "PGK2069"
AND av.ProductID IN (479))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "CK63041"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4461
AND av.DataSupplierArticleNumber = "EC025"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4461
AND av.DataSupplierArticleNumber = "KS121-K"
AND av.ProductID IN (479))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "KC003"
AND av.ProductID IN (479))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "962248"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4879
AND av.DataSupplierArticleNumber = "KC7625"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4428
AND av.DataSupplierArticleNumber = "069 2224"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4718
AND av.DataSupplierArticleNumber = "W00228J"
AND av.ProductID IN (479))
OR
(av.SupplierID = 6
AND av.DataSupplierArticleNumber = "623 3043 21"
AND av.ProductID IN (479))
OR
(av.SupplierID = 6
AND av.DataSupplierArticleNumber = "623 3141 00"
AND av.ProductID IN (479))
OR
(av.SupplierID = 6
AND av.DataSupplierArticleNumber = "623 3043 00"
AND av.ProductID IN (479))
OR
(av.SupplierID = 470
AND av.DataSupplierArticleNumber = "000228900"
AND av.ProductID IN (479))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "10314"
AND av.ProductID IN (479))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "61-5129"
AND av.ProductID IN (479))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "61-5182"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4559
AND av.DataSupplierArticleNumber = "MK9674"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4559
AND av.DataSupplierArticleNumber = "MK9648"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VCU314"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VCU459"
AND av.ProductID IN (479))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "CK9549"
AND av.ProductID IN (479))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "CK9549T"
AND av.ProductID IN (479))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "131938"
AND av.ProductID IN (479))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "S200I70"
AND av.ProductID IN (479))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "CLK9004.03"
AND av.ProductID IN (479))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QKT4181AF"
AND av.ProductID IN (479))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RC90453"
AND av.ProductID IN (479))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RC90044"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4828
AND av.DataSupplierArticleNumber = "JT7625"
AND av.ProductID IN (479))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "3000 950 061"
AND av.ProductID IN (479))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "3000 951 288"
AND av.ProductID IN (479))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "SCL0526"
AND av.ProductID IN (479))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1201131938"
AND av.ProductID IN (479))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "07-01102-SX"
AND av.ProductID IN (479))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "832066"
AND av.ProductID IN (479))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "826345"
AND av.ProductID IN (479))
)
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 = 487
AND aa.DataSupplierArticleNumber = "KT90044")
OR
(aa.SupplierID = 487
AND aa.DataSupplierArticleNumber = "KT90453")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "HK7625")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ECK081")
OR
(aa.SupplierID = 399
AND aa.DataSupplierArticleNumber = "PGK2069")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "CK63041")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "EC025")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "KS121-K")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "KC003")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "962248")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KC7625")
OR
(aa.SupplierID = 4428
AND aa.DataSupplierArticleNumber = "069 2224")
OR
(aa.SupplierID = 4718
AND aa.DataSupplierArticleNumber = "W00228J")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3043 21")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3141 00")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3043 00")
OR
(aa.SupplierID = 470
AND aa.DataSupplierArticleNumber = "000228900")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "10314")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "61-5129")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "61-5182")
OR
(aa.SupplierID = 4559
AND aa.DataSupplierArticleNumber = "MK9674")
OR
(aa.SupplierID = 4559
AND aa.DataSupplierArticleNumber = "MK9648")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCU314")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCU459")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "CK9549")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "CK9549T")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "131938")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S200I70")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CLK9004.03")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QKT4181AF")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RC90453")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RC90044")
OR
(aa.SupplierID = 4828
AND aa.DataSupplierArticleNumber = "JT7625")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "3000 950 061")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "3000 951 288")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "SCL0526")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1201131938")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "07-01102-SX")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "832066")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "826345")
)
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 = 487
AND aa.DataSupplierArticleNumber = "KT90044")
OR
(aa.SupplierID = 487
AND aa.DataSupplierArticleNumber = "KT90453")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "HK7625")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ECK081")
OR
(aa.SupplierID = 399
AND aa.DataSupplierArticleNumber = "PGK2069")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "CK63041")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "EC025")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "KS121-K")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "KC003")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "962248")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KC7625")
OR
(aa.SupplierID = 4428
AND aa.DataSupplierArticleNumber = "069 2224")
OR
(aa.SupplierID = 4718
AND aa.DataSupplierArticleNumber = "W00228J")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3043 21")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3141 00")
OR
(aa.SupplierID = 6
AND aa.DataSupplierArticleNumber = "623 3043 00")
OR
(aa.SupplierID = 470
AND aa.DataSupplierArticleNumber = "000228900")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "10314")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "61-5129")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "61-5182")
OR
(aa.SupplierID = 4559
AND aa.DataSupplierArticleNumber = "MK9674")
OR
(aa.SupplierID = 4559
AND aa.DataSupplierArticleNumber = "MK9648")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCU314")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCU459")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "CK9549")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "CK9549T")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "131938")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S200I70")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CLK9004.03")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QKT4181AF")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RC90453")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RC90044")
OR
(aa.SupplierID = 4828
AND aa.DataSupplierArticleNumber = "JT7625")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "3000 950 061")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "3000 951 288")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "SCL0526")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1201131938")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "07-01102-SX")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "832066")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "826345")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Комплект сцепления для автомобилей