#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwMnx8bW9kZWxfaWQ9PTU0NTJ8fG1kZl9pZD09MF4xODkzMHx8c3BhcmVfaWQ9PTEwMDM4NA%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 = "18930"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "A63132"
AND av.ProductID IN (8))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-5312"
AND av.ProductID IN (8))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADL142227"
AND av.ProductID IN (8))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFA2205"
AND av.ProductID IN (8))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "F 026 400 039"
AND av.ProductID IN (8))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CAF100450C"
AND av.ProductID IN (8))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "V450/606"
AND av.ProductID IN (8))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "MA1387"
AND av.ProductID IN (8))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EAF635"
AND av.ProductID IN (8))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "FL9086"
AND av.ProductID IN (8))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A146890"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DAF2790"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT37101"
AND av.ProductID IN (8))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "39752"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FA-8804"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "HPU 4431"
AND av.ProductID IN (8))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "AE348/3"
AND av.ProductID IN (8))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "CA10046"
AND av.ProductID IN (8))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "18531"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B2F071PR"
AND av.ProductID IN (8))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "3318601909"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4378
AND av.DataSupplierArticleNumber = "A0535"
AND av.ProductID IN (8))
OR
(av.SupplierID = 305
AND av.DataSupplierArticleNumber = "E-9281"
AND av.ProductID IN (8))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F213901"
AND av.ProductID IN (8))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LX 2790"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1713065"
AND av.ProductID IN (8))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760191"
AND av.ProductID IN (8))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LX 2790"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "C 18 003"
AND av.ProductID IN (8))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "60100"
AND av.ProductID IN (8))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "2790K-LF-PCS-MS"
AND av.ProductID IN (8))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0486"
AND av.ProductID IN (8))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "18531"
AND av.ProductID IN (8))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "EL9172"
AND av.ProductID IN (8))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "15-12 321 0000"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFA1225"
AND av.ProductID IN (8))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "PA3132"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2133736"
AND av.ProductID IN (8))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EAF3053.30"
AND av.ProductID IN (8))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "FA-00313"
AND av.ProductID IN (8))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "A1211"
AND av.ProductID IN (8))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFA0229"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "S10017"
AND av.ProductID IN (8))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 7606 A"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "71-01504-SX"
AND av.ProductID IN (8))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 93 9752"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "AR10046-OV"
AND av.ProductID IN (8))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "A2171"
AND av.ProductID IN (8))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "27.606.00"
AND av.ProductID IN (8))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V24-0766"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1216308"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431688"
AND av.ProductID IN (8))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WA9566"
AND av.ProductID IN (8))
)
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 = "A63132")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-5312")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADL142227")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2205")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 400 039")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100450C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "V450/606")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA1387")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF635")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FL9086")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A146890")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DAF2790")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT37101")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "39752")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FA-8804")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HPU 4431")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AE348/3")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CA10046")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "18531")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2F071PR")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3318601909")
OR
(aa.SupplierID = 4378
AND aa.DataSupplierArticleNumber = "A0535")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "E-9281")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F213901")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LX 2790")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1713065")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760191")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LX 2790")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 18 003")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "60100")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "2790K-LF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0486")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "18531")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EL9172")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "15-12 321 0000")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1225")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3132")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2133736")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EAF3053.30")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FA-00313")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "A1211")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFA0229")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S10017")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 7606 A")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-01504-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 93 9752")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR10046-OV")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "A2171")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "27.606.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0766")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1216308")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431688")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9566")
)
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 = "A63132")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-5312")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADL142227")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2205")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 400 039")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100450C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "V450/606")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA1387")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF635")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FL9086")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A146890")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DAF2790")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT37101")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "39752")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FA-8804")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HPU 4431")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AE348/3")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CA10046")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "18531")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2F071PR")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3318601909")
OR
(aa.SupplierID = 4378
AND aa.DataSupplierArticleNumber = "A0535")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "E-9281")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F213901")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LX 2790")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1713065")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760191")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LX 2790")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 18 003")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "60100")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "2790K-LF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0486")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "18531")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EL9172")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "15-12 321 0000")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1225")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3132")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2133736")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EAF3053.30")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FA-00313")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "A1211")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFA0229")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S10017")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 7606 A")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-01504-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 93 9752")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR10046-OV")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "A2171")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "27.606.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0766")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1216308")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431688")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9566")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Воздушный фильтр/корпус воздушного фильтра для автомобилей