8 (495) 120-33-23
8 (925) 645-65-56
select distinct filters.filterid, filters.filtername, filters.filtertypeid from filters, filters_in_products where filters_in_products.product_id in (1099, 1157, 1158, 1159, 1160, 1161, 1616, 1617, 1643, 1644, 2264, 2613, 2848, 2849, 2883, 2909, 2949, 3142, 3143, 3240, 3337, 3343, 3344, 3346, 3347, 3348, 3349, 3362, 3419, 3434, 3435, 3440, 3441, 3442, 3443, 3444, 3445, 3726, 3727, 3728, 3730, 3731, 3732, 3996, 4118, 4119, 4192, 4193, 4195, 4196, 4231, 4232, 4233, 4234, 4235, 4236, 4237, 4359, 4378, 4379, 4380, 4381, 4382, 4449, 4459, 4566, 4567, 4568, 4604, 4624, 4625, 4683, 4684, 4748, 4749, 4751, 4853, 4854, 4873, 4893, 4894, 4895, 5090, 5230, 5231, 5629, 5723, 5724, 5842, 5844, 5845, 5846, 5850, 5851, 5852, 6021, 6022, 6024, 6026, 6031, 6099, 6101, 6305, 7142, 7380, 7648, 7650, 8318, 8320, 8322) and filters.filtertypeid = filters_in_products.fitertype_id and filters.filterid = filters_in_products.filter_id order by filters.filtername
До минимальной суммы заказа {{format(needForMinSum())}}₽