0
Êèåâ каталог товаров
Êèåâ
�дре�а магазинов
Личный кабинет
Блокнот0

Применить
Ïðèìåíèòü

Ôèëüòðû
Ñîðòèðîâàòü

Öåíà

—
 ãðí.
0 0.1

Íàëè÷èå

Áðåíä

Ñåçîí

Array ( [1643548] => Array ( [name] => Êàòåãîðèÿ çàùèòû [type] => dict [vals] => Array ( [1643801] => 0 [1643802] => 1 [1643803] => 2 [1643804] => 3 [1643805] => 4 ) [real_vals] => Array ( [1643803] => 2 [1643804] => 3 ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643548 and ( pdi_podgr2_id in (1076028,1071626) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287)order by pdi_int_value asc ) [1643569] => Array ( [name] => Êîíñòðóêöèÿ øëåìà [type] => dict [vals] => Array ( [1643854] => in-mould [1643855] => hard shell [1643856] => hybrid ) [real_vals] => Array ( [1643854] => in-mould ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643569 and ( pdi_podgr2_id in (1076028,1071626) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287)order by pdi_int_value asc ) [1643614] => Array ( [name] => Íàçíà÷åíèå [type] => dict [vals] => Array ( [1644032] => ñëàëîì [1644033] => äàóíõèë [1644034] => ôðèðàéä ) [real_vals] => Array ( [1644033] => äàóíõèë ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643614 and ( pdi_podgr2_id in (1076028,1071626) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287)order by pdi_int_value asc ) [1643634] => Array ( [name] => Ïîãîäíûå óñëîâèÿ [type] => dict [vals] => Array ( [1644121] => ÿñíî [1644122] => ïåðåìåííàÿ îáëà÷íîñòü [1644123] => ïàñìóðíî [1644124] => òóìàí ) [real_vals] => Array ( [1644121] => ÿñíî [1644122] => ïåðåìåííàÿ îáëà÷íîñòü ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643634 and ( pdi_podgr2_id in (1076028,1071626) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287)order by pdi_int_value asc ) [1643644] => Array ( [name] => Ïîëÿðèçàöèÿ [type] => check [vals] => Array ( [0] => 0 [1] => 1 ) [real_vals] => Array ( [0] => 0 ) [_sql] => select distinct(gpv.gpv_int_value) from cat_goods_paramvalues gpv left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and gpv.gpv_param_id = 1643644 and g.lastyrs_or_present = 1 and s.`sport_id` = 51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287) order by gpv_int_value asc ) [1643690] => Array ( [name] => Ñîâìåñòèìîñòü ñ î÷êàìè [type] => check [vals] => Array ( [0] => 0 [1] => 1 ) [real_vals] => Array ( [0] => 0 [1] => 1 ) [_sql] => select distinct(gpv.gpv_int_value) from cat_goods_paramvalues gpv left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and gpv.gpv_param_id = 1643690 and g.lastyrs_or_present = 1 and s.`sport_id` = 51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287) order by gpv_int_value asc ) [1643730] => Array ( [name] => Ôîðìà ëèíçû [type] => dict [vals] => Array ( [1644243] => ñôåðè÷åñêàÿ [1644244] => öèëèíäðè÷åñêàÿ [1644245] => òîðè÷åñêàÿ ) [real_vals] => Array ( [1644244] => öèëèíäðè÷åñêàÿ [1644243] => ñôåðè÷åñêàÿ ) [_sql] => select pdi.pdi_id, pdi.pdi_value from cat_param_dict as pdi join cat_goods_paramvalues as gpv on (gpv.gpv_param_id = pdi.pdi_param_id and gpv.gpv_dict_id = pdi.pdi_id) left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id and g.lastyrs_or_present = 1) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and pdi_param_id = 1643730 and ( pdi_podgr2_id in (1076028,1071626) or pdi_podgr2_id = 0) and pdi.pdi_sysstatus = 1 and s.`sport_id`=51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287)order by pdi_int_value asc ) [1643731] => Array ( [name] => Ôîòîõðîì [type] => check [vals] => Array ( [0] => 0 [1] => 1 ) [real_vals] => Array ( [0] => 0 [1] => 1 ) [_sql] => select distinct(gpv.gpv_int_value) from cat_goods_paramvalues gpv left join cat_goods as g on (g.gds_id = gpv.gpv_goods_id) left join goods_sport as s on (g.gds_id = s.gds_id) where 1 and gpv.gpv_param_id = 1643731 and g.lastyrs_or_present = 1 and s.`sport_id` = 51526 and g.`gds_podgr2_id` in (1076028,1071626) and g.`gds_brand_id` in (2287) order by gpv_int_value asc ) ) 1

Êàòåãîðèÿ çàùèòû

Êîíñòðóêöèÿ øëåìà

Íàçíà÷åíèå

Ïîãîäíûå óñëîâèÿ

Ïîëÿðèçàöèÿ

Ñîâìåñòèìîñòü ñ î÷êàìè

Ôîðìà ëèíçû

Ôîòîõðîì

Íàéäåíî N òîâàðîâÏîêàçàòü
Ïîãîäà:   Êèåâ +19°Ñ
Ñïèñîê  \  Ïëèòêà
  íåò â íàëè÷èè



Ïî äàííûì ïàðàìåòðàì òîâàðû íå íàéäåíû.

Ïåðåéòè â êàòàëîã.



Ñïîðòèâíûå ìàãàçèíû «Äðàéâ-Ñïîðò» â Âèííèöå, Êèåâå, Äíåïðå, Õàðüêîâå, Îäåññå, Êðèâîì Ðîãå, Çàïîðîæüå è Ëüâîâå. Ñíàðÿæåíèå, îäåæäà è àêñåññóàðû äëÿ àêòèâíîãî îòäûõà è ñïîðòà! Âåëîñèïåäû ãîðíûå è bmx, ðîëèêîâûå êîíüêè è ñêåéòáîðäû, ãîðíûå ëûæè, ñíîóáîðäû, ëåäîâûå êîíüêè, òóðèñòè÷åñêîå ñíàðÿæåíèå, ïàëàòêè, ñïàëüíûå ìåøêè. Èçâåñòíûå ìàðêè è îòëè÷íûå öåíû!