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(3200) 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(3200) 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(3200) 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(3200) 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 Punktivõitluskindad - mma24
See e-pood on müügis WebShopperi AFTERMARKETIS

Punktivõitluskindad - mma24

Punktivõitluskindad - mma24

Punktivõitluskindad - mma24

Punktivõitluskindad - mma24

Punktivõitluskindad - mma24
Punktivõitluskindad - mma24
Klienditugi
560 45 000
Kategooriad
Filtreeri
  • Hind
    € - €
Uued tooted
ziel
Kimono belt MASTERS
Kimono belt MASTERS
Kimono straps, designed to be wrapped around the waist twice and..

UUDIS
3.90€
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€
Avaleht » Punktivõitluskindad

Punktivõitluskindad

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
bia
Open gloves Pointfighter ROTT-KIDS
Open gloves Pointfighter ROTT-KIDS
TOP TEN open gloves created especially for children over 5 years old. Ideal for semi contact and Taekwondo. The gloves are equipped with safety foam and a drawstring at the wrist. MODEL: Open gloves ROTT-KIDS COLOUR: white, black, red, blue SIZE: ..
TOP TEN open gloves created especially for children over 5 years ..
38.90€

KM-ta: 31.89€
nieb nieb
Open gloves ROTT
Open gloves ROTT "GLOSSY BLOCK" (WAKO APPROVED)
Open gloves created for pointfighting. Extremely lightweight with contoured liner and additional reinforcement to support the wrist during blocking.   MODEL: Open gloves ROTT “GLOSSY BLOCK” COLOUR: white-gold, black-red, red-white, blue-white, gree..
Open gloves created for pointfighting. Extremely lightweight with..
50.90€

KM-ta: 41.72€
bia bia
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue or black or white Size: XS, S,..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
bia bia
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue or black or white Size: XS, S,..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
bia bia
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue or black or white Size: XS, S,..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
Rękawice otwarte ROTT
Rękawice otwarte ROTT "GLOSSY BLOCK" czerwono-bi..
Rękawice otwarte stworzone do pointfightingu. Niezwykle lekkie z wyprofilowanym wkładem i dodatkowym wzmocnieniem podtrzymującym nadgarstek podczas blokowania.MODEL: Rękawice otwarte ROTT "GLOSSY BLOCK"KOLOR W STANDARDZIE: biało-złote, czarno-czerwon..
Rękawice otwarte stworzone do pointfightingu. Niezwykle lekkie z ..
50.90€

KM-ta: 41.72€
SOODUS
ró ró
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves created for pointfighting. Extremely lightweight with contoured liner and additional reinforcement to support the wrist during blocking.   MODEL: Open gloves ROTT “Glossy Block PRISM” COLOUR black, red, blue, pink SIZE: XS, S, M EXTER..
Open gloves created for pointfighting. Extremely lightweight with..
42.95€ 50.90€

KM-ta: 35.20€
czer czer
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves created for pointfighting. Extremely lightweight with contoured liner and additional reinforcement to support the wrist during blocking.   MODEL: Open gloves ROTT “Glossy Block PRISM” COLOUR black, red, blue SIZE: S, M EXTERNAL MATERI..
Open gloves created for pointfighting. Extremely lightweight with..
50.90€

KM-ta: 41.72€
czar czar
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czer czer
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
nieb nieb
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czar czar
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czar czar
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czer czer
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czer czer
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
nieb nieb
Boxing open gloves ROSM-FIGHT
Boxing open gloves ROSM-FIGHT
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthetic leather. These are gloves for point fighting. They are light, profiled, durable and ventilated. MODEL: Boxing gloves ROSM-FIGHT COLOUR: red or blue Size: XS, S, M EXTERNAL MATER..
Open gloves MASTERS model ROSM-FIGHT are made entirely of synthet..
24.90€

KM-ta: 20.41€
czar czar
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves ROTT -PRISM (WAKO APPROVED)
Open gloves created for pointfighting. Extremely lightweight with contoured liner and additional reinforcement to support the wrist during blocking.   MODEL: Open gloves ROTT “Glossy Block PRISM” COLOUR black, red, blue SIZE: S, M EXTERNAL MATERI..
Open gloves created for pointfighting. Extremely lightweight with..
50.90€

KM-ta: 41.72€
SOODUS
nieb
Open gloves Pointfighter ROTT-KIDS
Open gloves Pointfighter ROTT-KIDS
TOP TEN open gloves created especially for children over 5 years old. Ideal for semi contact and Taekwondo. The gloves are equipped with safety foam and a drawstring at the wrist. MODEL: Open gloves ROTT-KIDS COLOUR: white, black, red, blue SIZE: ..
TOP TEN open gloves created especially for children over 5 years ..
32.95€ 38.90€

KM-ta: 27.01€
Boxing open gloves ROSM-MJC
Boxing open gloves ROSM-MJC
MASTERS open gloves model ROSM-MJC are made entirely of synthetic leather. These are point fighting gloves. They are light, profiled, durable and ventilated. The hard insert and the highly profiled shape of the glove perfectly absorb the impact forc..
MASTERS open gloves model ROSM-MJC are made entirely of syntheti..
24.90€

KM-ta: 20.41€
Boxing open gloves ROSM-MJC
Boxing open gloves ROSM-MJC
MASTERS open gloves model ROSM-MJC are made entirely of synthetic leather. These are point fighting gloves. They are light, profiled, durable and ventilated. The hard insert and the highly profiled shape of the glove perfectly absorb the impact forc..
MASTERS open gloves model ROSM-MJC are made entirely of syntheti..
24.90€

KM-ta: 20.41€
Boxing open gloves ROSM-MJC
Boxing open gloves ROSM-MJC
MASTERS open gloves model ROSM-MJC are made entirely of synthetic leather. These are point fighting gloves. They are light, profiled, durable and ventilated. The hard insert and the highly profiled shape of the glove perfectly absorb the impact forc..
MASTERS open gloves model ROSM-MJC are made entirely of syntheti..
24.90€

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