#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1Mzd8fG1kZl9pZD09MV41NTU2fHxzcGFyZV9pZD09MjAwMTU5&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 articlecommercialvehicles av
JOIN commercialvehiclelinkageattributes_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 = "5556"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "D20145"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "D20703"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "D21450"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "G08"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "G100"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 457 434 105"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 457 434 154"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS04-111"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS04-001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CFF100519"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "L519/606"
AND av.ProductID IN (9))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "DN 256"
AND av.ProductID IN (9))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "DN 301"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P553004"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P550345"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P550588"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 05 EF"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 526 F"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PP845/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 313
AND av.DataSupplierArticleNumber = "FL04.401"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H60WK08"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H70WK"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4130"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4110"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4112"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KC 24"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KC 17D"
AND av.ProductID IN (9))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50013001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50013079"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFDS108"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LF-1822"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "152071758006"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760539"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KC 17D"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KC 24"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "WK 723/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "WK 842"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4112"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4130"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4110"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5506"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5214"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "034 009 0003"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "114 323 0001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "DF 326"
AND av.ProductID IN (9))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "DF 694"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "M323"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "M351A"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FN703"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FN145"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FN1450"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ST 302"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ST 350"
AND av.ProductID IN (9))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 4323 NR"
AND av.ProductID IN (9))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 8501 NR"
AND av.ProductID IN (9))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FT1508"
AND av.ProductID IN (9))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FT2480"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00528-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-10024-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00068-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "24.351.01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "24.323.00"
AND av.ProductID IN (9))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V47-0003"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214760"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1018150"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1018219"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1146109"
AND av.ProductID IN (9))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WF8181"
AND av.ProductID IN (9))
)
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 = 4814
AND aa.DataSupplierArticleNumber = "D20145")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20703")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D21450")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G08")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G100")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 434 105")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 434 154")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-111")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-001")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100519")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L519/606")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DN 256")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DN 301")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P553004")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550345")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550588")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 05 EF")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 526 F")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP845/1")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.401")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H60WK08")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H70WK")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4130")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4110")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4112")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 24")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 17D")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013001")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013079")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDS108")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1822")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071758006")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760539")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 17D")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 24")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 723/1")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 842")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4112")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4130")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4110")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5506")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5214")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "034 009 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 323 0001")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 326")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 694")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M323")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M351A")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN703")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN145")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN1450")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 302")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 350")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4323 NR")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 8501 NR")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT1508")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT2480")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00528-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-10024-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00068-SX")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.351.01")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.323.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V47-0003")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214760")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018150")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018219")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1146109")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8181")
)
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 = 4814
AND aa.DataSupplierArticleNumber = "D20145")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20703")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D21450")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G08")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G100")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 434 105")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 434 154")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-111")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-001")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100519")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L519/606")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DN 256")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DN 301")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P553004")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550345")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550588")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 05 EF")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 526 F")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP845/1")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.401")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H60WK08")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H70WK")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4130")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4110")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4112")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 24")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 17D")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013001")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013079")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDS108")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1822")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071758006")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760539")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 17D")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 24")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 723/1")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 842")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4112")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4130")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4110")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5506")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5214")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "034 009 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "114 323 0001")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 326")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 694")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M323")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M351A")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN703")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN145")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN1450")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 302")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 350")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4323 NR")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 8501 NR")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT1508")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT2480")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00528-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-10024-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00068-SX")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.351.01")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.323.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V47-0003")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214760")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018150")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018219")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1146109")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8181")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Топливный фильтр для автомобилей