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(3202) 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(3202) 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(3202) 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(3202) 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 Kottide tarvikud - mma24
See e-pood on müügis WebShopperi AFTERMARKETIS

Kottide tarvikud - mma24

Kottide tarvikud - mma24

Kottide tarvikud - mma24

Kottide tarvikud - mma24

Kottide tarvikud - mma24
Kottide tarvikud - 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 » Poksikotid » Kottide tarvikud

Kottide tarvikud

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
Cross-type Hook for punching bag
Cross-type Hook for punching bag
MASTERS hook for hanging bags on the ceiling, cross type. Reinforced, steel, painted black. For bags up to 100 kg.   Dimensions: - total shoulder length: 42 cm - shoulder width: 4 cm - thickness: 1 cm - length of the hook with the base: 14 cm - hol..
MASTERS hook for hanging bags on the ceiling, cross type. Reinfo..
24.90€

KM-ta: 20.41€
Shock absorber anchor Plawil PREMIUM 40 x 10 cm
Shock absorber anchor Plawil PREMIUM 40 x 10 cm
The shock-absorbing anchor is perfect for stabilizing punching bags during training. Thanks to it, you can attach the bag to the ground without drilling into the floor. The anchor is equipped with a triangular handle with a carabiner, to which it is ..
The shock-absorbing anchor is perfect for stabilizing punching ba..
21.90€

KM-ta: 17.95€
Hak obrotowy do zawieszania worka
Hak obrotowy do zawieszania worka
Hak obrotowy na sufit MASTERS do zawieszania worków. Wzmocniony, stalowy, ocynkowany, zakończony szeklą. Wytrzymałość dla worków do 100 kg.Wymiary:- podstawa: 10 cm x 10 cm- grubość podstawy: 0,8 cm- szekla: 1 cm - otwory: 1 cm- waga: 1,10 kg...
Hak obrotowy na sufit MASTERS do zawieszania worków. Wzmocniony, ..
34.90€

KM-ta: 28.61€
Konks poksikoti riputamiseks HAK-120kg
Konks poksikoti riputamiseks HAK-120kg
Swivel hook on the ceiling for hanging bags on ball bearings.   STRENGTH: up to 120 kg LENGTH: 14.5 cm WIDTH: 4 cm HEIGHT: 12 cm BASE THICKNESS: 0.5 cm HOOK THICKNESS: 1.1 cm WEIGHT: 0.60 kg MATERIAL: galvanized steel SUPPLIED: 2 screws with expans..
Swivel hook on the ceiling for hanging bags on ball bearings.   ..
18.90€

KM-ta: 15.49€
Vedru poksikotile SW
Vedru poksikotile SW
Sprężyna amortyzująca do worków metalowa, ocynkowana.Przedłuża trwałość używanych worków, amortyzuje ich ruchy.Posiada 13 szerokich zwojów, długość 14 cm.Jest wykonana z wysokiej jakości stali, z szerokich zwojów, specjalnie do użytku na workach boks..
Sprężyna amortyzująca do worków metalowa, ocynkowana.Przedłuża tr..
9.90€

KM-ta: 8.11€
Konks poksikoti riputamiseks HW
Konks poksikoti riputamiseks HW
MASTERS ceiling hook for hanging bags. Reinforced, steel, galvanized. Strength for bags up to 80 kg.   Dimensions: - base: 10 cm x 10 cm - base thickness: 0.8 cm - hook length: 10 cm - hook thickness: 1.6 cm - holes: 0.9 cm - weight: 0.95 kg ..
MASTERS ceiling hook for hanging bags. Reinforced, steel, galvani..
19.90€

KM-ta: 16.31€
Pöörlev seinakonks WNS-10S
Pöörlev seinakonks WNS-10S
A strong hanger for bags, in a version to be screwed to the wall, made of a closed metal profile. The design allows for hanging at any height. Tip with a rotating and replaceable shackle.   ARM MATERIAL: steel profile 4 cm x 4 cm x 0.2 cm BASE MATER..
A strong hanger for bags, in a version to be screwed to the wall,..
83.90€

KM-ta: 68.77€
Pöörlev seinakonks redelile WD-1
Pöörlev seinakonks redelile WD-1
Mocny wieszak do worków na drabinki, wykonany z metalowego profilu zamkniętego.Konstrukcja umożliwia zawieszanie na dowolnej wysokości. Końcówka z wymienną szeklą.Wymiary wieszaka:- długość ramienia - 83 cm- podstawa - 77 cm- uchwyt - 80 cm- waga - 9..
Mocny wieszak do worków na drabinki, wykonany z metalowego profil..
67.90€

KM-ta: 55.66€
Kett poksikotile ŁW-5
Kett poksikotile ŁW-5
Chain MASTERS for the punching bag - steel, chrome-plated, consisting of a double joint and four chains with hooks. Holds punching bags with a maximum weight of 30 - 35 kg.   DIMENSIONS AND WEIGHT: Total length - 46 cm Chain length with a hook - 3..
Chain MASTERS for the punching bag - steel, chrome-plated, consi..
9.90€

KM-ta: 8.11€
Konks poksikoti riputamiseks HAK-200
Konks poksikoti riputamiseks HAK-200
Hak na sufit MASTERS do zawieszania worków.Wzmocniony, stalowy, pomalowany na czarno.Wytrzymałość dla worków do 200 kg.Wymiary:- podstawa: 133 mm x 133 mm- grubość podstawy: 8 mm- długość haka: 125 mm- grubość haka: 16 mm- otwory: 10 mm- waga: 1.65 k..
Hak na sufit MASTERS do zawieszania worków.Wzmocniony, stalowy, p..
24.90€

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