Например,  утепленные муфты
Например,  утепленные муфты
+7(931)105-07-97
Обратный звонок
профессиональная консультация
Адрес магазина
г. Москва, ул. Кантемировская 64с3
Время работы
без выходных пн-вс 11:00-21:00

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT BrandID, catalog_brands.Parent, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_fast_models INNER JOIN catalog_brands ON catalog_brands.ID = catalog_fast_models.BrandID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('30', catalog_brands.Domains)) AND catalog_brands.Hide = ? GROUP BY BrandID ORDER BY BrandID DESC
Params: 
Array
(
    [0] => 
    [1] => 827
    [2] => 
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 190
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID WHERE catalog_mods_params.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 954
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 181
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 184
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 191
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 226
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 227
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 228
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 967
    [1] => 
    [2] => 827
)

Db error: Unknown column 'catalog_models.Created' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID LEFT JOIN catalog_models_to_groups ON catalog_models_to_groups.ModelID = catalog_fast_models.ID INNER JOIN catalog_fast_mods ON catalog_fast_mods.ModelID = catalog_fast_models.ID WHERE catalog_props_values.PropID = ? AND catalog_fast_models.Domains = ? AND catalog_fast_models.CatID = ? AND (GroupID IN (184) OR (DATEDIFF(CURRENT_DATE, DATE(catalog_models.Created)) <= 30)) AND catalog_fast_models.ID IN (583114,557332,583115,557333,724000,583093,593099,720509,723999,705081,594368,738321,593393,593394,593863,752844,695064,723998,725262,593100,727448,758891,594442,582859,593682,594454,593870,721045,593582,738322,593685,593395,707601,593388,594365,707597,593583,593096,594451,720419,594069,593871,593865,582860,593687,592822,657479,593094,725319,652905) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_mods_params.ModelID FROM catalog_mods_params INNER JOIN catalog_fast_mods ON catalog_fast_mods.ID = catalog_mods_params.ModID WHERE catalog_mods_params.PropID = 954 AND catalog_mods_params.ValID IN (2408) AND catalog_fast_mods.Q > 0) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 184 AND catalog_props_values.ValID IN (2321)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params: 
Array
(
    [0] => 1034
    [1] => 
    [2] => 827
)

Фильтр товаров
  • Цена
  • Группа
  • Бренд
  • Цвет
  • Размер
  • Материал
  • Пол
  • Вид шлема
  • Сезон
  • Стандарты сертификации
  • Встроенные солнцезащитные очки
  • Особенности
  • Модель

Мотошлемы L унисекс похожие на Icon Airframe Pro Construct мотошлем черный

Фильтр товаров
Не найдено товаров
Часто задаваемые вопросы по теме Мотошлемы
Как выбрать размер шлема?

Первое и единственное правило по которому можно сразу понять ваш размер или нет – мотоциклетный шлем должен плотно прилегать во всех точках на голове (лоб, затылок, щеки). Плотно прилегать, но не давить. Откройте визор, постойте в шлеме 2-3 минуты, если сидит плотно и не создает давлением болевого ощущения – это ваш размер. Учитывайте, что в процессе использования подушки немного примнутся и он будет чуть свободнее. Если выбираете шлем дистанционно, на странице с любым мотошлемом, нажмите "Узнать свой размер" и следуйте мастеру подбора размера. Для интернет заказов так же действует возврат и обмен.

Насколько шлемы, которые вы продаете надежны?
Абсолютно все шлемы, которые мы продаем прошли обязательную жесткую европейскую сертификацию по стандарту ECE22.05R, а шлемы ICON соответствуют одновременно 4-м стандартам безопасности (DOT FMVSS 218 – США, ECE 22-05 – Европа, SAI AS1698 – Австралия и PSC – Япония), что говорит об их исключительной надежности. Сертифицированный шлем, не расколется пополам и максимально эффективно рассеет удар и защитит.
Почему у меня размер один, а все шлемы сидят по разному?
Дело в том, что эталонные лекала у всех производителей разные. Один и тот же индекс размера, например M, от разных производителей может иметь разную посадку. Более того, разные производители производят шлемы для разных рынков и разную форму головы. Поэтому при покупке нового шлема, не стоит руководствоваться только размером предыдущего шлема другой марки. Всегда замеряйте голову в сантиметрах и подбирайте по таблице размеров производителя. Мастер подбора размера на нашем сайте поможет.
Какой тип застежки шлема лучше?
Есть два типа застежек: трещетка и 2D кольцо. 2D кольцо считается самым надежным, потому что она не может расстегнуться сама в экстренной ситуации, только такой тип застежек на мотошлемах имеет допуск на профессиональные соревнования и чемпионаты.
+79311050797
Обратный звонок
профессиональная консультация
Время работы
без выходных пн-вс 11:00-21:00