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(3204) 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(3204) 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(3204) 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(3204) 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 1384Täisnahast - mma24
RBT-HARDÂ are leather boxing gloves designed for sparring. Made of quality natural leather. The filling is a multi-layer insert that absorbs safety and comfort of use. A wide Velcro fastener stiffens the wrist.
Â
MODEL: RBT-HARD Boxing Gloves 20 oz
S..
RBT-HARDÂ are leather boxing gloves designed for sparring. Made of..
RBT-HARDÂ are leather boxing gloves designed for sparring. Made of quality natural leather. The filling is a multi-layer insert that absorbs safety and comfort of use. A wide Velcro fastener stiffens the wrist.
Â
MODEL: RBT-HARD Boxing Gloves 18Â oz
S..
RBT-HARDÂ are leather boxing gloves designed for sparring. Made of..
Very comfortable and durable gloves ideal for sparring. Thick cushioning, good profiling, long and wide and velcro ensure safety during use. Preserved in red colors with an interesting print.
Â
MODEL: Boxing gloves RBT-RED
COLOUR: red
WEIGHT:Â 12 oz..
Very comfortable and durable gloves ideal for sparring. Thick cus..
RBT-LF are leather boxing gloves designed for sparring. They have additional wrist support thanks to the use of special foam inserts.
Â
MODEL: Boxing gloves RBT-LF
COLOUR: (available in the selection menu): black-red
WEIGHT: (available in the selec..
RBT-LF are leather boxing gloves designed for sparring. They have..
Gloves made of cowhide leather. These are gloves designed for kickboxing. In terms of technical details, the glove is compatible with the proven AIBA RTT-AIBA certified glove.
MODEL: Boxing gloves RTT-SUPERFIGHT 3000 STARS
COLOUR: black, red, ..
Gloves made of cowhide leather. These are gloves designed for ..
Gloves made of cowhide leather. These are gloves designed for kickboxing. In terms of technical details, the glove is compatible with the proven AIBA RTT-AIBA certified glove.
MODEL: Boxing gloves RTT-SUPERFIGHT 3000 STARS
COLOUR: black, red, ..
Gloves made of cowhide leather. These are gloves designed for ..
Gloves made of cowhide leather. These are gloves designed for kickboxing. In terms of technical details, the glove is compatible with the proven AIBA RTT-AIBA certified glove.
MODEL: Boxing gloves RTT-SUPERFIGHT 3000 STARS
COLOUR: black, red, ..
Gloves made of cowhide leather. These are gloves designed for ..
RTT-Black'n'Black boxing gloves are designed for the most demanding athletes who value comfort and safety.
Â
MODEL: Boxing gloves RTT-Black’n’Black
COLOUR: black
WEIGHT (available in the selection menu): 10 oz, 12 oz, 14 oz, 16 oz
EXTERNAL MATERIA..
RTT-Black'n'Black boxing gloves are designed for the most demandi..
Boxing gloves designed for women. Additional foam stiffening the wrist. Made of synthetic leather in an eye-catching pink color. Soft lining from the inside and ventilation holes ensure comfort of use.
MODEL: Boxing gloves RPU-WOMAN
COLOUR:Â pink
..
Boxing gloves designed for women. Additional foam stiffening the ..
Boxing gloves designed for women. Additional foam stiffening the wrist. Made of synthetic leather in an eye-catching pink color. Soft lining from the inside and ventilation holes ensure comfort of use.
MODEL: Boxing gloves RPU-WOMAN
COLOUR:Â pink
..
Boxing gloves designed for women. Additional foam stiffening the ..
Very comfortable and durable gloves ideal for sparring. Thick cushioning, good profiling, long and wide and velcro ensure safety during use. Preserved in red colors with an interesting print.
Â
MODEL: Boxing gloves RBT-RED
COLOUR: red
WEIGHT: 14..
Very comfortable and durable gloves ideal for sparring. Thick cus..
Gloves RBT-9 made from natural leather in gold color. Machine made thick cushioning is safety during the training.
Â
MODEL: Boxing gloves RBT-9
COLOUR: gold
WEIGHT: 12 oz
EXTERNAL MATERIAL: cowhide leather
INTERNAL MATERIAL: durable and pleasan..
Gloves RBT-9 made from natural leather in gold color. Machine mad..
RBT-SPAR are leather boxing gloves designed for sparring. Made of the highest quality natural leather. The filling is a multi-layer cushioning insert ensuring safety and comfort of use. The wide Velcro fastener perfectly stiffens the wrist.
MODEL: ..
RBT-SPAR are leather boxing gloves designed for sparring. Made of..
Boxing gloves Masters RBT-VINTAGE are high-quality, handmade gloves, made of selected cowhide leather.
Unusual design, comfort and safety
Â
MODEL: Boxing gloves RBT-VINTAGE
COLOUR: brown
WEIGHT(available in the selection menu): 10 oz, 12 oz, 14 oz
..
Boxing gloves Masters RBT-VINTAGE are high-quality, handmade glov..
Boxing gloves Masters RBT-VINTAGE are high-quality, handmade gloves, made of selected cowhide leather.
Unusual design, comfort and safety
Â
MODEL: Boxing gloves RBT-VINTAGE
COLOUR: brown
WEIGHT(available in the selection menu): 10 oz, 12 oz, 14 oz
..
Boxing gloves Masters RBT-VINTAGE are high-quality, handmade glov..
RBT-SPAR are leather boxing gloves designed for sparring. Made of the highest quality natural leather. The filling is a multi-layer cushioning insert ensuring safety and comfort of use. The wide Velcro fastener perfectly stiffens the wrist.
MODEL:..
RBT-SPAR are leather boxing gloves designed for sparring. Made of..
RBT-SPAR are leather boxing gloves designed for sparring. Made of the highest quality natural leather. The filling is a multi-layer cushioning insert ensuring safety and comfort of use. The wide Velcro fastener perfectly stiffens the wrist.
MODEL:..
RBT-SPAR are leather boxing gloves designed for sparring. Made of..
The highest quality buff leather and a very safe cushioning insert are the distinguishing features of the model RBT-301. Let's add comfort and convenience of combat that is to ensure the perfectly contoured shape of the glove. WIN TOGETHER, SAFETY ..
The highest quality buff leather and a very safe cushioning ins..
Boxing gloves designed for tournaments. The front part of the glove is smooth, which allows you to apply your own print. Tying with laces gives the possibility of fully adjusting the glove to the hand. It is extremely easy to use, just pull the strin..
Boxing gloves designed for tournaments. The front part of the glo..
Boxing gloves designed for tournaments. The front part of the glove is smooth, which allows you to apply your own print. Tying with laces gives the possibility of fully adjusting the glove to the hand. It is extremely easy to use, just pull the strin..
Boxing gloves designed for tournaments. The front part of the glo..
Gloves made of cowhide leather. These are gloves designed for kickboxing. In terms of technical details, the glove is compatible with the proven AIBA RTT-AIBA certified glove.
MODEL: Boxing gloves RTT-SUPERFIGHT 3000 STARS
COLOUR: black, red, ..
Gloves made of cowhide leather. These are gloves designed for ..