Например,  подшлемник
Например,  подшлемник
+7 (717) 272-73-27
Обратный звонок
профессиональная консультация
Казахстан, Алматы, ул. Шевченко, 118
без выходных пн-вс 11:00-21:00

Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT MIN(catalog_fast_models.Price), MAX(catalog_fast_models.Price) FROM catalog_fast_models WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_fast_models.Price > 0
Params:
Array
(
    [0] => 
)

Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT catalog_cats.ID,catalog_cats.Parent,catalog_cats.Name,catalog_cats.Code,catalog_cats.Image,catalog_cats.Image2,catalog_cats.FontIcon,catalog_cats.SingleName,catalog_cats.AllName,catalog_cats.FilterName,catalog_cats.H,catalog_cats.SortIndex,catalog_cats.Hide,catalog_cats.DiscountID,catalog_cats.PseudoID,catalog_cats.NameShort,catalog_cats.Title,catalog_cats.Keywords,catalog_cats.Description,catalog_cats.NoIndex,catalog_cats.ModelTitleTemplate,catalog_cats.ModelDescriptionTemplate,catalog_cats.ModelH1Template,catalog_cats.OfferType,catalog_cats.SalesNotes,catalog_cats.BrandWarranty,catalog_cats.YmlPriceTypeID,catalog_cats.Domains,catalog_cats.ImportID,catalog_cats.DisablePaymentSystems,catalog_cats.DisableDeliveries,catalog_cats.NumModels,catalog_cats.NumModelsRaw,catalog_cats.NumModelsCp,catalog_cats.ModifiedDate,catalog_cats.SearchSyn,catalog_cats.NumBindings,catalog_cats.ClassName,catalog_cats.NumGifts,catalog_cats.NaToStatus,catalog_cats.NaToStatusDiscountID,catalog_cats.NameLocative,catalog_cats.BaseUnit,catalog_cats.Weight,catalog_cats.WeightBrutto,catalog_cats.Volume,catalog_cats.Length,catalog_cats.Width,catalog_cats.Height,catalog_cats.ReviewsBlockHeader,catalog_cats.Source,catalog_cats.LocalDeliveryCost,catalog_cats.SortByProp,catalog_cats.PriceTypeID,catalog_cats.WearType,catalog_cats.Tnved,catalog_cats.MandatoryMark FROM catalog_cats INNER JOIN catalog_fast_models ON catalog_fast_models.CatID = catalog_cats.ID LEFT JOIN catalog_num_models ON catalog_num_models.Resource = 'iCatalogCategory' AND catalog_num_models.ResourceID = catalog_cats.ID AND catalog_num_models.Domain = 75 WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_cats.Code NOT REGEXP '\/|\:' AND (catalog_cats.Domains = '' OR FIND_IN_SET('75', catalog_cats.Domains)) AND catalog_cats.Hide = ? AND (catalog_num_models.NumModels IS NULL OR catalog_num_models.NumModels > 0)
Params:
Array
(
    [0] => 
    [1] => 
)

Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT catalog_brands.ID,catalog_brands.Parent,catalog_brands.Name,catalog_brands.Code,catalog_brands.LocationID,catalog_brands.CountryOriginID,catalog_brands.Image,catalog_brands.H,catalog_brands.SortIndex,catalog_brands.Hide,catalog_brands.DiscountID,catalog_brands.Title,catalog_brands.Keywords,catalog_brands.Description,catalog_brands.NoIndex,catalog_brands.ModelTitleTemplate,catalog_brands.ModelDescriptionTemplate,catalog_brands.ModelH1Template,catalog_brands.Domains,catalog_brands.ImportID,catalog_brands.SalesNotes,catalog_brands.BrandWarranty,catalog_brands.NumModels,catalog_brands.NumModelsRaw,catalog_brands.NumModelsCp,catalog_brands.ModifiedDate,catalog_brands.SearchSyn,catalog_brands.PriceList,catalog_brands.PresentationID,catalog_brands.Images,catalog_brands.NumBindings,catalog_brands.NumGifts,catalog_brands.NaToStatus,catalog_brands.NaToStatusDiscountID,catalog_brands.Source,catalog_brands.LocalDeliveryCost FROM catalog_brands INNER JOIN catalog_fast_models ON catalog_fast_models.BrandID = catalog_brands.ID WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND (catalog_brands.Domains = '' OR FIND_IN_SET('75', catalog_brands.Domains)) AND catalog_brands.Hide = ?
Params:
Array
(
    [0] => 
    [1] => 
)

Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.PropID, 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 WHERE catalog_props_values.PropID IN (190,181,184,191,226,227,231,236,237,240,967,1034,1069,1164,1165,1166,1167) AND catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 
)

Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT catalog_mods_params.PropID, catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID WHERE catalog_mods_params.PropID IN (954) AND catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_mods.Q > 0 AND catalog_mods.Status != 200 GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC
Params:
Array
(
    [0] => 
)

Фильтр товаров

Экипировка на случай дождя

Что нужно мотоциклисту в дождливую погоду?
Фильтр товаров
Экипировка на случай дождливой погоды обязана обладать особым уровнем влагозащиты. Производители тщательно выбирают материалы, прорабатывают швы и молнии. На многих моделях встречается специфический крой, а так же резинки/кнопки/ремни, фиксирующие рукава, воротник, дабы ветер не задувал под одежду. Ветрозащита у данных моделей на уровне. Дополнительным бонусом следует считать светоотражающие вставки, так как во время дождя видимость на дороге резко падает. Производитель старается сделать экипировку максимально полезной для мотоциклистов. Визоры Pinlock существенно облегчают жизнь мотоциклистам, потому что во время дождя из-за перепадов температур визор запотевает чаще всего.
без выходных пн-вс 11:00-21:00