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(3112,'3113','3136','3183') 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(3112,'3113','3136','3183') 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(3112,'3113','3136','3183') 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(3112,'3113','3136','3183') 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 Kiivrid - mma24
See e-pood on müügis WebShopperi AFTERMARKETIS

Kiivrid - mma24

Kiivrid - mma24

Kiivrid - mma24

Kiivrid - mma24

Kiivrid - mma24
Kiivrid - 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 » Kiivrid

Kiivrid

Täpsusta valikut

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
nieb nieb
Kiiver TOP TEN AVANTGARDE - KTT-2 WAKO APPROVED
Kiiver TOP TEN AVANTGARDE - KTT-2 WAKO APPROVED
Made of extremely durable and impact-absorbing "BAYFLEX" material. New design, updated cut to prevent injury to the eyebrow arches, 9 holes for better ventilation of the head during exercise. Possibility to buy a mask for the helmet. Size table: S (..
Made of extremely durable and impact-absorbing "BAYFLEX" material..
84.90€

KM-ta: 69.59€
Headguard KTOP-MATT-BLACK
Headguard KTOP-MATT-BLACK
Large front and side parts of the headguard, closed ears and upper part of the head are the hallmarks of the KTOP-MATT headguard. Well-fitting area that protects the cheekbones help protect the fighter from injuries. The headguard belongs to the MATT..
Large front and side parts of the headguard, closed ears and uppe..
32.90€

KM-ta: 26.97€
nieb nieb
Headguard with a mask KSSPU-M WAKO APPROVED
Headguard with a mask KSSPU-M WAKO APPROVED
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it. Has WAKO certificate   MODEL: Headguard KSSPU-M COLOUR: (availab..
KSSPU-M headguard with a mask will ensure the highest level of sa..
43.90€

KM-ta: 35.98€
czer czer
Headguard with a mask KSSPU-M WAKO APPROVED
Headguard with a mask KSSPU-M WAKO APPROVED
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it. Has WAKO certificate   MODEL: Headguard KSSPU-M COLOUR: (availab..
KSSPU-M headguard with a mask will ensure the highest level of sa..
43.90€

KM-ta: 35.98€
czer czer
Headguard with a mask KSSPU-M WAKO APPROVED
Headguard with a mask KSSPU-M WAKO APPROVED
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it. Has WAKO certificate   MODEL: Headguard KSSPU-M COLOUR: (availab..
KSSPU-M headguard with a mask will ensure the highest level of sa..
43.90€

KM-ta: 35.98€
nieb nieb
Headguard with a mask KSSPU-M WAKO APPROVED
Headguard with a mask KSSPU-M WAKO APPROVED
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it. Has WAKO certificate   MODEL: Headguard KSSPU-M COLOUR: (availab..
KSSPU-M headguard with a mask will ensure the highest level of sa..
43.90€

KM-ta: 35.98€
KSSPU-M must poksikiiver koos maskiga
KSSPU-M must poksikiiver koos maskiga
KSSPU-M maskiga kiiver tagab kõrgeima turvalisuse taseme. Tugeva ülesehitusega, lõua ja pea ülaosa kaitsega. Läbipaistva maski saab eemaldada ja ilma selleta treenida.   MUDEL : KSSPU-M kiiver STANDARDVÄRV : must STANDARD SUURUS (saadaval valikumenüü..
KSSPU-M maskiga kiiver tagab kõrgeima turvalisuse taseme. Tugeva ..
42.90€

KM-ta: 35.16€
Headguard with a mask KSSPU-M black
Headguard with a mask KSSPU-M black
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it.   MODEL: Headguard KSSPU-M COLOUR: black SIZE (available in th..
KSSPU-M headguard with a mask will ensure the highest level of sa..
42.90€

KM-ta: 35.16€
Headguard with a mask KSSPU-M black
Headguard with a mask KSSPU-M black
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it.   MODEL: Headguard KSSPU-M COLOUR: black SIZE (available in th..
KSSPU-M headguard with a mask will ensure the highest level of sa..
42.90€

KM-ta: 35.16€
SOODUS
Headguard with a mask KSSPU-M black
Headguard with a mask KSSPU-M black
KSSPU-M headguard with a mask will ensure the highest level of safety. Heavily built, with chin and upper head protection. The transparent mask can be removed and practiced without it.   MODEL: Headguard KSSPU-M COLOUR: black SIZE (available in th..
KSSPU-M headguard with a mask will ensure the highest level of sa..
34.95€ 42.90€

KM-ta: 28.65€
Sparring headguard with grill KSS-4BPK
Sparring headguard with grill KSS-4BPK
Sparring headguard with grill KSS-4BPK made of synthetic leather. Fully enclosed with protection for the cheekbones, chin and top head. Removal metal grille with large openings around the eyes that do not limit visibility. MODEL: Headguard KSS-4BPK..
Sparring headguard with grill KSS-4BPK made of synthetic leather...
43.90€

KM-ta: 35.98€
Sparring headguard with grill KSS-K
Sparring headguard with grill KSS-K
Sparring headguard with grill KSS-K made of high quality cowhide leather. Fully enclosed with protection for the cheekbones, chin and top head. Removal metal grille with large openings around the eyes that do not limit visibility.   MODEL: Headgu..
Sparring headguard with grill KSS-K made of high quality cowhide ..
53.90€

KM-ta: 44.18€
Headguard KT-PROFESSIONAL
Headguard KT-PROFESSIONAL
The KT-PROFESSIONAL headguard is made of the highest quality cowhide. A perfect fit is ensured by two Velcro fasteners at the top of the head and a wide Velcro with additional foam filling at the back of the headguard. The headguard belongs to the PR..
The KT-PROFESSIONAL headguard is made of the highest quality cowh..
44.90€

KM-ta: 36.80€
Headguard KT-PROFESSIONAL
Headguard KT-PROFESSIONAL
The KT-PROFESSIONAL headguard is made of the highest quality cowhide. A perfect fit is ensured by two Velcro fasteners at the top of the head and a wide Velcro with additional foam filling at the back of the headguard. The headguard belongs to the PR..
The KT-PROFESSIONAL headguard is made of the highest quality cowh..
44.90€

KM-ta: 36.80€
Sparringi poksikiiver MASTERS - KSS-4B1
Sparringi poksikiiver MASTERS - KSS-4B1
Sparring headguard KSS-4B1 made of high quality cowhide leather. Fully enclosed with protection for the cheekbones, chin and top head.   MODEL: Headguard KSS-4B1 COLOUR: black SIZE (available in the selection menu): S - XL SIZE CHART:(head circu..
Sparring headguard KSS-4B1 made of high quality cowhide leather. ..
47.90€

KM-ta: 39.26€
SOODUS
Sparring headguard KSS-4B1
Sparring headguard KSS-4B1
Sparring headguard KSS-4B1 made of high quality cowhide leather. Fully enclosed with protection for the cheekbones, chin and top head.   MODEL: Headguard KSS-4B1 COLOUR: black SIZE (available in the selection menu): S - XL SIZE CHART:(head circu..
Sparring headguard KSS-4B1 made of high quality cowhide leather. ..
39.95€ 47.90€

KM-ta: 32.75€
Sparringi poksikiiver MASTERS - KSS-4B1
Sparringi poksikiiver MASTERS - KSS-4B1
Sparring headguard KSS-4B1 made of high quality cowhide leather. Fully enclosed with protection for the cheekbones, chin and top head.   MODEL: Headguard KSS-4B1 COLOUR: black SIZE (available in the selection menu): S - XL SIZE CHART:(head circu..
Sparring headguard KSS-4B1 made of high quality cowhide leather. ..
47.90€

KM-ta: 39.26€
Sparring headguard KSS-4B1
Sparring headguard KSS-4B1
Sparring headguard KSS-4B1 made of high quality cowhide leather. Fully enclosed with protection for the cheekbones, chin and top head.   MODEL: Headguard KSS-4B1 COLOUR: black SIZE (available in the selection menu): S - XL SIZE CHART:(head circu..
Sparring headguard KSS-4B1 made of high quality cowhide leather. ..
47.90€

KM-ta: 39.26€
Sparring headguard KSS-4BP
Sparring headguard KSS-4BP
Sparring headguard KSS-4BP made of syntethic leather. Fully enclosed with protection for the cheekbones, chin and top head.   MODEL: Headguard KSS-4BP COLOUR: black SIZE (available in the selection menu): S - L SIZE CHART (head circuit): S (50-5..
Sparring headguard KSS-4BP made of syntethic leather. Fully enclo..
30.90€

KM-ta: 25.33€
nieb nieb
Headguard KTOP-PU WAKO APPROVED
Headguard KTOP-PU WAKO APPROVED
MASTERS classic KTOP-PU tournament headguard with built-in top of head. Boxing headguard designed for training high kicks. Has WAKO certificate   MODEL: Headguard KTOP-PU COLOUR: (available in the selection menu) red, blue SIZE (available in the se..
MASTERS classic KTOP-PU tournament headguard with built-in top of..
29.90€

KM-ta: 24.51€
nieb nieb
Headguard KTOP-PU WAKO APPROVED
Headguard KTOP-PU WAKO APPROVED
MASTERS classic KTOP-PU tournament headguard with built-in top of head. Boxing headguard designed for training high kicks. Has WAKO certificate   MODEL: Headguard KTOP-PU COLOUR: (available in the selection menu) red, blue SIZE (available in the se..
MASTERS classic KTOP-PU tournament headguard with built-in top of..
29.90€

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