#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTM2fHxtZGZfaWQ9PTBeMTQ2OXx8c3BhcmVfaWQ9PTEwMDEzMw%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 = "1469"
AND (
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-X55S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-X45C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-X53S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-F45"
AND av.ProductID IN (298))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-X55C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-F55"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WAF22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA022H"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA018H"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA022S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WAF18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBC550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBX600"
AND av.ProductID IN (299))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBH450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBC450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW2010055"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW2020055"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW2040055"
AND av.ProductID IN (298))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "WB17"
AND av.ProductID IN (298))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "WB5"
AND av.ProductID IN (298))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "WB108"
AND av.ProductID IN (298))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "WB9"
AND av.ProductID IN (298))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "WB117"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW21C"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW22F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW21F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW18C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW22H"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW21H"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW22S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW22C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 118 906"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 537"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 004 763"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 118 420"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 007 045"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 004 668"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 118 421"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 536"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 004 672"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 15-992-004"
AND av.ProductID IN (298))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79040056"
AND av.ProductID IN (299))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79041056"
AND av.ProductID IN (299))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AS55/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "RD55/C01"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "E55/B02"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AS5555/B02"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "A45/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "RD45/C01"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "E45/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "A55/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "E55/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CCWB450"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CFWB550"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CCWB550"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DUR-045R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DM-555"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DUR-055L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DMS-555"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DUR-055R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DUR-045L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DM-045"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "OF55A"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "B550S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "B450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "DVF55"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "B550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "OF45A"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "550DC"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "500DF"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "550DF"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "525DC"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "550DH"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "525DF"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "500DC"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "EWFB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWFB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "EWCB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWDF22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWCB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWF22-S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWCS22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "EWCB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWDF22-S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWCB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWFB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWEB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "EWFB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWFB18"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWCS22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWFB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LLWEB22"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93229"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93236"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93249"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93211"
AND av.ProductID IN (298))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FW550M"
AND av.ProductID IN (298))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FW450E"
AND av.ProductID IN (298))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FW450M"
AND av.ProductID IN (298))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FW550E"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 190 680-221"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 177 810-801"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 864 080-801"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 358 061-221"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 358 053-211"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-211"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 178 878-181"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 358 053-221"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-221"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 178 878-221"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 860 655-001"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-X53S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-F45"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-X55C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-F55"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-X55S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-X45C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJX53S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJF45"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJX55C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJF55"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJX55S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJX45C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27E05"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27525U"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27500"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "26500"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27500U"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "26525"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27550U"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27525"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "26550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K58"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K56HYB"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K53P"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "KS56"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K56"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K45HYB"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K56P"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K5656"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LX550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "550L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "XF550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "550LS"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LW550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "000723135500"
AND av.ProductID IN (298))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "104550/2HPS"
AND av.ProductID IN (298))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "104550HPS"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MWL-8550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MWL-8450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MWL-8525"
AND av.ProductID IN (298))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 550 2200"
AND av.ProductID IN (298))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 530 2100"
AND av.ProductID IN (298))
OR
(av.SupplierID = 145
AND av.DataSupplierArticleNumber = "EU-521"
AND av.ProductID IN (298))
OR
(av.SupplierID = 145
AND av.DataSupplierArticleNumber = "EU-621"
AND av.ProductID IN (298))
OR
(av.SupplierID = 145
AND av.DataSupplierArticleNumber = "27-018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 145
AND av.DataSupplierArticleNumber = "EUS-521"
AND av.ProductID IN (298))
OR
(av.SupplierID = 145
AND av.DataSupplierArticleNumber = "27-018V"
AND av.ProductID IN (298))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "WBR7005.00"
AND av.ProductID IN (298))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "WBS0022.00"
AND av.ProductID IN (298))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "WBH0022.00"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "86010550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "86010525"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55H"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55S"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9468-9467"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9413-9413"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ESTOCADA 9413"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9445"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9414-9414"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ESTOCADA 9414"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9446"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9446-9445"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ESTOCADA 9405"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "118 450-SX"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "102 550-SX"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "122 550-SX"
AND av.ProductID IN (298,298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "103 550-SX"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "101 450-SX"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "101 550-SX"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "116109"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "119855"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "116166"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "116222"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "116606"
AND av.ProductID IN (298))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "115 284"
AND av.ProductID IN (299))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF550R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "T450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "ES550R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EF450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "T550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "FX550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EF550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF550L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "NF550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "ES550L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "35-220"
AND av.ProductID IN (298))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "4910 610"
AND av.ProductID IN (299))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.58.426"
AND av.ProductID IN (298))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.58.428"
AND av.ProductID IN (298))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V99-0112"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "576004"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575556"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575545"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574168"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "675555"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "576010"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575787"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575546"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574173"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574112"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "576078"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575797"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575555"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574190"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574118"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "675545"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-3018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-1018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-5022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-3022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-1022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-6022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-4018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-2022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-4022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1482025"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1482018"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1482023"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "FW-550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "HW-550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "BW-450"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "BW-550"
AND av.ProductID IN (298))
)
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 = 257
AND aa.DataSupplierArticleNumber = "SA-X55S")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X45C")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X53S")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-F45")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X55C")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-F55")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAF22")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022H")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA018H")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022S")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA018")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAF18")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBC550")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBX600")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBH450")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBC450")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2010055")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2020055")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2040055")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB17")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB5")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB108")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB9")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB117")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW18C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22H")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21H")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22S")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22C")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 906")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 537")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 763")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 420")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 045")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 668")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 421")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 536")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 672")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 15-992-004")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79040056")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79041056")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AS55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "RD55/C01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E55/B02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AS5555/B02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A45/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "RD45/C01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E45/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E55/B01")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CCWB450")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB550")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CCWB550")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-045R")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DM-555")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-055L")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DMS-555")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-055R")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-045L")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DM-045")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "OF55A")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B550S")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B450")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF55")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B550")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "OF45A")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DC")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "500DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "525DC")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DH")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "525DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "500DC")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWCB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWDF22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWF22-S")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWCS22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWCB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWDF22-S")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWEB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCS22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWEB22")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93229")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93236")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93249")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93211")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW550M")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW450E")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW450M")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW550E")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 177 810-801")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 864 080-801")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 061-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 053-211")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-211")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 178 878-181")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 053-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 178 878-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 860 655-001")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X53S")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-F45")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X55C")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-F55")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X55S")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X45C")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX53S")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJF45")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX55C")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJF55")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX55S")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX45C")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27E05")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27525U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27550")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27500U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26525")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27550U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27525")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26550")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56HYB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K53P")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "KS56")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K45HYB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56P")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K5656")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LX550")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "550L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "XF550")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "550LS")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LW550")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "000723135500")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104550/2HPS")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104550HPS")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8550")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8450")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8525")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 550 2200")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 530 2100")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EU-521")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EU-621")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "27-018")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EUS-521")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "27-018V")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBR7005.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBS0022.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBH0022.00")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010550")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010525")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55H")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55S")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55F")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9468-9467")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9413-9413")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9413")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9445")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9414-9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9446")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9446-9445")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9405")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "118 450-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "102 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "122 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "103 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "101 450-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "101 550-SX")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116109")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119855")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116166")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116222")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116606")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "115 284")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "T450")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "ES550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EF450")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "T550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EF550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "ES550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-220")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "4910 610")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.426")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.428")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V99-0112")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576004")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575556")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575545")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574168")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "675555")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576010")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575787")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575546")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574173")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574112")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576078")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575797")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575555")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574190")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "675545")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-3018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-1018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-5022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-3022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-1022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-6022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-2022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4022")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482025")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482018")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482023")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BW-450")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BW-550")
)
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 = 257
AND aa.DataSupplierArticleNumber = "SA-X55S")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X45C")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X53S")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-F45")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X55C")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-F55")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAF22")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022H")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA018H")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022S")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA022")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA018")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAF18")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBC550")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBX600")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBH450")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBC450")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2010055")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2020055")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW2040055")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB17")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB5")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB108")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB9")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "WB117")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW18C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22H")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW21H")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22S")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW22C")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 906")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 537")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 763")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 420")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 045")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 668")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 421")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 536")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 672")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 15-992-004")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79040056")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79041056")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AS55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "RD55/C01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E55/B02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AS5555/B02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A45/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "RD45/C01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E45/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "E55/B01")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CCWB450")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB550")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CCWB550")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-045R")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DM-555")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-055L")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DMS-555")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-055R")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DUR-045L")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DM-045")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "OF55A")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B550S")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B450")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF55")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "B550")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "OF45A")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DC")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "500DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "525DC")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "550DH")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "525DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "500DC")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWCB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWDF22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWF22-S")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWCS22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWCB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWDF22-S")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWEB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "EWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWFB18")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCS22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWFB22")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LLWEB22")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93229")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93236")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93249")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93211")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW550M")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW450E")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW450M")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW550E")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 177 810-801")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 864 080-801")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 061-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 053-211")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-211")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 178 878-181")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 358 053-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 178 878-221")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 860 655-001")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X53S")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-F45")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X55C")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-F55")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X55S")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X45C")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX53S")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJF45")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX55C")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJF55")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX55S")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX45C")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27E05")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27525U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27550")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27500U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26525")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27550U")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27525")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "26550")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56HYB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K53P")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "KS56")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K45HYB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K56P")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K5656")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LX550")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "550L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "XF550")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "550LS")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LW550")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "000723135500")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104550/2HPS")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104550HPS")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8550")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8450")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MWL-8525")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 550 2200")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 530 2100")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EU-521")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EU-621")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "27-018")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "EUS-521")
OR
(aa.SupplierID = 145
AND aa.DataSupplierArticleNumber = "27-018V")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBR7005.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBS0022.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBH0022.00")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010550")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010525")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55H")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55S")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55F")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9468-9467")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9413-9413")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9413")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9445")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9414-9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9446")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9446-9445")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9405")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "118 450-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "102 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "122 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "103 550-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "101 450-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "101 550-SX")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116109")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119855")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116166")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116222")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "116606")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "115 284")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "T450")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "ES550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EF450")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "T550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EF550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "ES550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-220")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "4910 610")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.426")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.428")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V99-0112")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576004")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575556")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575545")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574168")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "675555")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576010")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575787")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575546")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574173")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574112")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "576078")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575797")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575555")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574190")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "675545")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-3018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-1018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-5022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-3022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-1022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-6022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4018")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-2022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4022")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482025")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482018")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1482023")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BW-450")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BW-550")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Стеклоочиститель / резина для автомобилей
