Например,  Variant Pro
Например,  Variant Pro
Обратный звонок
профессиональная консультация
Кыргызстан, Бишкек, ул. Ахматбека Суюнбая, 16, 2
без выходных пн-вс 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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (7)) AND BrandID > 0 AND (catalog_brands.Domains = '' OR FIND_IN_SET('74', catalog_brands.Domains)) AND catalog_brands.Hide = ? GROUP BY BrandID ORDER BY BrandID DESC
Params:
Array
(
    [0] => 
    [1] => 1228
    [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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (7)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 190
    [1] => 
    [2] => 1228
)

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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 181
    [1] => 
    [2] => 1228
)

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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (7)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 184
    [1] => 
    [2] => 1228
)

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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (7)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 226
    [1] => 
    [2] => 1228
)

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 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 (594153,594154,594171,594417,594161,594522,594166,594167,594168,594164,594163,594416,594436,594420,594165,594160,594159,594435,594415,594162,594418,594419,594172,594421,723107,594158,723104,583506,583505,723103,723102,723098,593854,594143,723096,586973,560348,586657,584590,586972,594169,586658,594157,593856,723100,718780,592203,594434,587082,594155) AND catalog_fast_models.ID IN (SELECT DISTINCT catalog_props_values.ModelID FROM catalog_props_values WHERE catalog_props_values.PropID = 181 AND catalog_props_values.ValID IN (7)) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 1034
    [1] => 
    [2] => 1228
)

Фильтр товаров
  • Цена
  • Группа
  • Бренд
  • Цвет
  • Материал
  • Пол
  • Сезон
  • Модель

Визоры и пинлоки из поликарбоната похожие на Визор AXXIS Iridium Max Vision MT-V-14 иридиевый (Cobra)

Корпус изготавливается с помощью полуавтомата по технологии литья пластика под высоким давлением. Специальный состав пластика не трескается и не откалывается при ударе. Так же надежно защищает как композитный шлем. Основные особенности: незначительно (100-200 грамм) тяжелее композитных и дешевле из-за большей автоматизации работ при изготовлении корпуса.
без выходных пн-вс 11:00-21:00