Notice: Error: Unknown column 'p.ean' in 'where clause'
Error No: 1054
SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id` FROM `product` AS `p` INNER JOIN `product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0 INNER JOIN `product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2 INNER JOIN `attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id` INNER JOIN `attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2 INNER JOIN `attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id` INNER JOIN `attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2 INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(3205) AND ((LCASE(`pd`.`name`) LIKE '%laos%') OR LCASE(`pd`.`tag`) LIKE '%laos%' OR LCASE(`p`.`model`) = 'laos' OR LCASE(`p`.`sku`) = 'laos' OR LCASE(`p`.`upc`) = 'laos' OR LCASE(`p`.`ean`) = 'laos' OR LCASE(`p`.`jan`) = 'laos' OR LCASE(`p`.`isbn`) = 'laos' OR LCASE(`p`.`mpn`) = 'laos') GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != '' ORDER BY `a`.`sort_order`, `txt` in /home/mma24/domains/mma24.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2564Notice: Error: Unknown column 'p.ean' in 'where clause'
Error No: 1054
SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `ov`.`image`, `ovd`.`name` FROM `product` AS `p` INNER JOIN `product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id` INNER JOIN `option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id` INNER JOIN `option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 2 INNER JOIN `option` AS `o` ON `o`.`option_id` = `pov`.`option_id` INNER JOIN `option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 2 INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(3205) AND ((LCASE(`pd`.`name`) LIKE '%laos%') OR LCASE(`pd`.`tag`) LIKE '%laos%' OR LCASE(`p`.`model`) = 'laos' OR LCASE(`p`.`sku`) = 'laos' OR LCASE(`p`.`upc`) = 'laos' OR LCASE(`p`.`ean`) = 'laos' OR LCASE(`p`.`jan`) = 'laos' OR LCASE(`p`.`isbn`) = 'laos' OR LCASE(`p`.`mpn`) = 'laos') AND `o`.`type` IN('radio','checkbox','select','image') GROUP BY `o`.`option_id`, `ov`.`option_value_id` ORDER BY `ov`.`sort_order`, `ovd`.`name` in /home/mma24/domains/mma24.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2439Notice: Error: Unknown column 'p.ean' in 'where clause'
Error No: 1054
SELECT `m`.* FROM `manufacturer` AS `m` INNER JOIN `manufacturer_to_store` AS `m2s` ON `m`.`manufacturer_id` = `m2s`.`manufacturer_id` AND `m2s`.`store_id` = '0' INNER JOIN `product` AS `p` ON `p`.`manufacturer_id` = `m`.`manufacturer_id` INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(3205) AND ((LCASE(`pd`.`name`) LIKE '%laos%') OR LCASE(`pd`.`tag`) LIKE '%laos%' OR LCASE(`p`.`model`) = 'laos' OR LCASE(`p`.`sku`) = 'laos' OR LCASE(`p`.`upc`) = 'laos' OR LCASE(`p`.`ean`) = 'laos' OR LCASE(`p`.`jan`) = 'laos' OR LCASE(`p`.`isbn`) = 'laos' OR LCASE(`p`.`mpn`) = 'laos') GROUP BY `m`.`manufacturer_id` ORDER BY `m`.`sort_order` ASC, `m`.`name` ASC in /home/mma24/domains/mma24.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 2227Notice: Error: Unknown column 'p.ean' in 'where clause'
Error No: 1054
SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max` FROM( SELECT ( `price_tmp` * ( 1 + IFNULL(`p_tax`, 0) / 100 ) + IFNULL(`f_tax`, 0) ) AS `price` FROM( SELECT IFNULL( (SELECT `price` FROM `product_special` AS `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1), IFNULL( (SELECT `price` FROM `product_discount` AS `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1), `p`.`price` ) ) AS `price_tmp` , ( SELECT SUM(`tr2`.`rate`) FROM `tax_rule` AS `tr1` LEFT JOIN `tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` INNER JOIN `tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id` LEFT JOIN `zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'F' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) ) AND `tr2cg`.`customer_group_id` = 1 ) AS f_tax , ( SELECT SUM(`tr2`.`rate`) FROM `tax_rule` AS `tr1` LEFT JOIN `tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id` INNER JOIN `tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id` LEFT JOIN `zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id` WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'P' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1054' ) ) ) AND `tr2cg`.`customer_group_id` = 1 ) AS p_tax FROM `product` AS `p` INNER JOIN `product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2 INNER JOIN `product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0 INNER JOIN `product_to_category` AS `p2c` ON `p2c`.`product_id` = `p`.`product_id` WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p2c`.`category_id` IN(3205) AND ((LCASE(`pd`.`name`) LIKE '%laos%') OR LCASE(`pd`.`tag`) LIKE '%laos%' OR LCASE(`p`.`model`) = 'laos' OR LCASE(`p`.`sku`) = 'laos' OR LCASE(`p`.`upc`) = 'laos' OR LCASE(`p`.`ean`) = 'laos' OR LCASE(`p`.`jan`) = 'laos' OR LCASE(`p`.`isbn`) = 'laos' OR LCASE(`p`.`mpn`) = 'laos') ) AS `tmp` ) AS `tmp` in /home/mma24/domains/mma24.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/mma24/domains/mma24.ee/public_html/catalog/model/module/mega_filter.php on line 1384 Sääreluukaitsmed - mma24
See e-pood on müügis WebShopperi AFTERMARKETIS

Sääreluukaitsmed - mma24

Sääreluukaitsmed - mma24

Sääreluukaitsmed - mma24

Sääreluukaitsmed - mma24

Sääreluukaitsmed - mma24
Sääreluukaitsmed - mma24
Klienditugi
560 45 000
Kategooriad
Filtreeri
  • Hind
    € - €
Uued tooted
nieb nieb
Foot protectors TOP TEN OSTT..
Foot protectors TOP TEN OSTT..
OSTT-PU Superlight PRISM model foot protectors are made of pre-s..

UUDIS
58.90€
biaÅ
Ochraniacze stóp OSTT-KIDS
Ochraniacze stóp OSTT-KIDS
Ochraniacz stóp TOP TEN zaprojektowane specjalnie dla dzieci. Roz..

UUDIS
37.90€
Avaleht » Kaitsmed » Sääreluukaitsmed

Sääreluukaitsmed

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
czer czer
Nagolenniki TOP TEN WAKO style NA-TT
Nagolenniki TOP TEN WAKO style NA-TT
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations. Perfect damping, thanks to the EVA material used on the inside of the protector. The outer part is made of synthetic material - Rexion Maya. Rear elastic protector and two Velcro faste..
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations...
39.90€

KM-ta: 32.70€
czer czer
Nagolenniki TOP TEN WAKO style NA-TT
Nagolenniki TOP TEN WAKO style NA-TT
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations. Perfect damping, thanks to the EVA material used on the inside of the protector. The outer part is made of synthetic material - Rexion Maya. Rear elastic protector and two Velcro faste..
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations...
39.90€

KM-ta: 32.70€
nieb nieb
Nagolenniki TOP TEN WAKO style NA-TT
Nagolenniki TOP TEN WAKO style NA-TT
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations. Perfect damping, thanks to the EVA material used on the inside of the protector. The outer part is made of synthetic material - Rexion Maya. Rear elastic protector and two Velcro faste..
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations...
39.90€

KM-ta: 32.70€
Shin guards MASTERS JUNIOR COLLECTION NA-MJC-1
Shin guards MASTERS JUNIOR COLLECTION NA-MJC-1
NA-MJC shin guards have an anatomically formed cushioning insert, which makes them very comfortable during training and competition. The youngest players will like an interesting print.  The successor of the NA-MJC model with an even better formed sh..
NA-MJC shin guards have an anatomically formed cushioning insert,..
23.90€

KM-ta: 19.59€
Shin guards MASTERS JUNIOR COLLECTION NA-MJC-1
Shin guards MASTERS JUNIOR COLLECTION NA-MJC-1
NA-MJC shin guards have an anatomically formed cushioning insert, which makes them very comfortable during training and competition. The youngest players will like an interesting print.  The successor of the NA-MJC model with an even better formed sh..
NA-MJC shin guards have an anatomically formed cushioning insert,..
23.90€

KM-ta: 19.59€
czar czar
Nagolenniki TOP TEN WAKO style NA-TT
Nagolenniki TOP TEN WAKO style NA-TT
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations. Perfect damping, thanks to the EVA material used on the inside of the protector. The outer part is made of synthetic material - Rexion Maya. Rear elastic protector and two Velcro faste..
TOP TEN WAKO STYLE shin guards, adapted to the WAKO regulations...
39.90€

KM-ta: 32.70€
Shin guards MASTERS NA-JUNIOR
Shin guards MASTERS NA-JUNIOR
Children's model of MASTERS shinguards pads. Very well shaped, perfectly fits the leg. The inside is lined with CLIMA COOL moisture-absorbing mesh. They have 2 elastic Velcro fasteners. Safety for the youngest adepts of kick sports!   MODEL: NA-JUNIO..
Children's model of MASTERS shinguards pads. Very well shaped, pe..
19.90€

KM-ta: 16.31€
Shin guards MASTERS NA-JUNIOR
Shin guards MASTERS NA-JUNIOR
Children's model of MASTERS shinguards pads. Very well shaped, perfectly fits the leg. The inside is lined with CLIMA COOL moisture-absorbing mesh. They have 2 elastic Velcro fasteners. Safety for the youngest adepts of kick sports!   MODEL: NA-JUNIO..
Children's model of MASTERS shinguards pads. Very well shaped, pe..
19.90€

KM-ta: 16.31€
Shin guards MASTERS NA-JUNIOR
Shin guards MASTERS NA-JUNIOR
Children's model of MASTERS shinguards pads. Very well shaped, perfectly fits the leg. The inside is lined with CLIMA COOL moisture-absorbing mesh. They have 2 elastic Velcro fasteners. Safety for the youngest adepts of kick sports!   MODEL: NA-JUNIO..
Children's model of MASTERS shinguards pads. Very well shaped, pe..
19.90€

KM-ta: 16.31€
nieb nieb
Shin guards MASTERS NA-MFE WAKO APPROVED
Shin guards MASTERS NA-MFE WAKO APPROVED
Perfectly fitted thanks to the elastic back welt and rubber Velcro. Comfortable thanks to a smooth and pleasant synthetic material from the inside. Safe thanks to 3 cm shock absorbing foam. The NA-MFE model created for tournament starts, has WAKO cer..
Perfectly fitted thanks to the elastic back welt and rubber Velcr..
23.90€

KM-ta: 19.59€
czer czer
Shin guards MASTERS NA-MFE WAKO APPROVED
Shin guards MASTERS NA-MFE WAKO APPROVED
Perfectly fitted thanks to the elastic back welt and rubber Velcro. Comfortable thanks to a smooth and pleasant synthetic material from the inside. Safe thanks to 3 cm shock absorbing foam. The NA-MFE model created for tournament starts, has WAKO cer..
Perfectly fitted thanks to the elastic back welt and rubber Velcr..
23.90€

KM-ta: 19.59€
czer czer
Shin guards MASTERS NA-MFE WAKO APPROVED
Shin guards MASTERS NA-MFE WAKO APPROVED
Perfectly fitted thanks to the elastic back welt and rubber Velcro. Comfortable thanks to a smooth and pleasant synthetic material from the inside. Safe thanks to 3 cm shock absorbing foam. The NA-MFE model created for tournament starts, has WAKO cer..
Perfectly fitted thanks to the elastic back welt and rubber Velcr..
23.90€

KM-ta: 19.59€
nieb nieb
Shin guards MASTERS NA-MFE WAKO APPROVED
Shin guards MASTERS NA-MFE WAKO APPROVED
Perfectly fitted thanks to the elastic back welt and rubber Velcro. Comfortable thanks to a smooth and pleasant synthetic material from the inside. Safe thanks to 3 cm shock absorbing foam. The NA-MFE model created for tournament starts, has WAKO cer..
Perfectly fitted thanks to the elastic back welt and rubber Velcr..
23.90€

KM-ta: 19.59€
czer czer
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
czer czer
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
nieb nieb
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
nieb nieb
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
nieb nieb
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
czer czer
Säärekaitmsed vahuga MASTERS NA-TKD
Säärekaitmsed vahuga MASTERS NA-TKD
Shin protectors designed for taekwondo and pointfighting training. Made of oldewu foam, very light, easily adapts to the body. Available in corner colors, perfect for tournament use.   MODEL: Shin protectors NA-TKD COLOUR: (available in the selec..
Shin protectors designed for taekwondo and pointfighting traini..
16.90€

KM-ta: 13.85€
Shin guards MASTERS JUNIOR COLLECTION NA-MJC
Shin guards MASTERS JUNIOR COLLECTION NA-MJC
NA-MJC shin guards have an anatomically formed cushioning insert, which makes them very comfortable during training and competition. The youngest players will like an interesting print.   MODEL: Shin guards NA-MJC COLOUR: black SIZE (available in t..
NA-MJC shin guards have an anatomically formed cushioning insert,..
15.90€

KM-ta: 13.03€
Shin guards MASTERS JUNIOR COLLECTION NA-MJC
Shin guards MASTERS JUNIOR COLLECTION NA-MJC
NA-MJC shin guards have an anatomically formed cushioning insert, which makes them very comfortable during training and competition. The youngest players will like an interesting print.   MODEL: Shin guards NA-MJC COLOUR: black SIZE (available in t..
NA-MJC shin guards have an anatomically formed cushioning insert,..
15.90€

KM-ta: 13.03€
mma24 @ 2024 | Veebiturvalisuse tagab: veebikaitse.ee | Ostuturvalisuse tagab: ostugarantii.eeWebShopper