Kappa Italian Team Spike FISI Beanie - Blue Nights

Product Code: 302MS30 966 05 W16
Kappa Italian Team Spike FISI Beanie - Blue Nights

Be the first to review this product

Excl. Tax: €24.17 Incl. Tax: €29.00
Kappa

Kappa size information: Men | Women | Kids

Description

Details

FISI Ski Italian Team Beanie

  • Mixed wool and acylic
  • Polyester polar inner band
  • Embroidered Omini logo and FISI logo.
Additional Information

Additional Information

SKU 302MS30 966 05 W16
Manufacturer Kappa
Reviews
Tags

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.

teamskiwear.com is an wintersport racegear shop based in the Austrian Alps and offers the qualtiy skiwear from brands like Spyder, Phenix, Bogner, Kappa Goldwin and many more. [profiler]
Memory usage: real: 44826624, emalloc: 43447032
Code ProfilerTimeCntEmallocRealMem
Executed 2620 queries in 1.0482552051544 seconds
Average query length: 0.00040009740654749 seconds
Queries per second: 2499.3913572927
Longest query length: 0.18014597892761
Longest query:
SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '32') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '32') AND (`at_is_active`.`store_id` = 9) INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = '498') AND `at_include_in_menu_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = '498') AND (`at_include_in_menu`.`store_id` = 9) LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id='9' AND core_url_rewrite.id_path LIKE 'category/%') WHERE (`e`.`entity_type_id` = '3') AND (`e`.`entity_id` IN('327', '330', '331', '332', '393', '333', '334', '335', '336', '328', '337', '338', '339', '394', '340', '342', '343', '329', '344', '345', '346', '395', '347', '348', '388', '349', '350', '280', '285', '288', '289', '290', '291', '351', '286', '292', '293', '294', '295', '287', '296', '297', '299', '298', '381', '177', '178', '179', '180', '182', '185', '183', '184', '186', '187', '383', '188', '262', '191', '193', '195', '181', '215', '216', '217', '218', '219', '220', '221', '222', '223', '224', '225', '226', '227', '228', '229', '231', '230', '270', '232', '213', '243', '244', '246', '245', '278', '321', '324', '247', '248', '249', '250', '279', '325', '251', '320', '253', '252', '323', '322', '281', '282', '300', '301', '302', '303', '283', '304', '305', '306', '307', '284', '308', '309', '310', '311', '212', '233', '234', '236', '235', '237', '380', '238', '397', '266', '239', '382', '240', '241', '267', '242', '214', '254', '255', '257', '256', '258', '259', '260', '261', '268', '352', '354', '357', '358', '359', '360', '361', '355', '362', '363', '364', '365', '366', '356', '367', '368', '369', '353', '370', '371', '372', '373', '374', '379', '375', '376', '377', '378', '384', '385', '386', '387', '271', '277', '272', '274', '396', '273', '275')) AND (`e`.`entity_id` NOT IN('292', '293', '295', '308', '309', '311', '362', '363', '365', '366', '367', '369')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = '1')