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(118) 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/workwe/domains/turvavarustus.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/workwe/domains/turvavarustus.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/workwe/domains/turvavarustus.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(118) 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/workwe/domains/turvavarustus.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/workwe/domains/turvavarustus.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/workwe/domains/turvavarustus.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(118) 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/workwe/domains/turvavarustus.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/workwe/domains/turvavarustus.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/workwe/domains/turvavarustus.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` = '0' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) ) 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` = '0' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 67 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '0' ) ) ) 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(118) 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/workwe/domains/turvavarustus.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/workwe/domains/turvavarustus.ee/public_html/catalog/model/module/mega_filter.php on line 1384 Kummikindad - Turvavarustus

Kummikindad - Turvavarustus

Kummikindad - Turvavarustus

Kummikindad - Turvavarustus

Kummikindad - Turvavarustus

Kummikindad - Turvavarustus
Kummikindad - Turvavarustus
Kategooriad
Filtreeri
  • Hind
    € - €
  • Hinnang
    0
    0
    0
    0
    0
  • Lao staatus
    0
    0
    0
    0
    0
    0
    0
    0
Uued tooted
44 45 46 47
KERGED VABAAJAJALATSID
KERGED VABAAJAJALATSID
..

UUDIS
39.99€
44 45 46
SPORTLIKUD VABAAJAJALATSID
SPORTLIKUD VABAAJAJALATSID
..

UUDIS
42.70€
Avaleht » Kummikindad

Kummikindad

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
11
PUNASED KUMMIKINDAD, KAETUD PVC-GA
PUNASED KUMMIKINDAD, KAETUD PVC-GA
PVC kattega kaetud kummikindad. Punase värviga. Pikkus - 35 sentimeetrit.  Kogus pakis - 12 paari, kogus karbis - 60 paari. PVC...
PVC kattega kaetud kummikindad. Punase värviga. Pikkus - 35 se..
3.05€

KM-ta: 2.50€
11
KUMMIKINDAD 60CM
KUMMIKINDAD 60CM
Pikad kummikindad, kaetud PVC-ga. Punase värviga.  PVC...
Pikad kummikindad, kaetud PVC-ga. Punase värviga.  PVC...
3.66€

KM-ta: 3€
10 11
PVC-GA KAETUD KUMMIKINDAD
PVC-GA KAETUD KUMMIKINDAD
PVC-ga kaetud kummikindad. Külmakindel.  Kogus pakis - 12 paari, kogus karbis - 60 paari. PVC, tekstiil...
PVC-ga kaetud kummikindad. Külmakindel.  Kogus pakis - 12..
6.10€

KM-ta: 5€
11
KUMMIKINDAD KALURILE
KUMMIKINDAD KALURILE
PVC külmakindlad karmi peopesaga kindad kaluritele. Oranži värvi.  PVC, tekstiil. Kogus pakis - 12 paari, kogus karbis - 60 paari...
PVC külmakindlad karmi peopesaga kindad kaluritele. Oranži värvi...
7.32€

KM-ta: 6€
10
PVC KUMMIKINDAD
PVC KUMMIKINDAD
Tugeva peopesaga kummikindad. Kaetud musta värvi PVC-ga. Kogus pakis - 12 paari, kogus karbis - 60 paari. PVC...
Tugeva peopesaga kummikindad. Kaetud musta värvi PVC-ga. Kogus pa..
3.66€

KM-ta: 3€
S M L
MAJAPIDAMISKINDAD
MAJAPIDAMISKINDAD
Lateksist valmistatud kummist majapidamiskindad. Võib olla kollast või roosat värvi. Sobib majapidamistöödeks nagu nõude või põranda puhastamine. Kogus pakis - 12 paari, kogus karbis - 120 paari. Lateks...
Lateksist valmistatud kummist majapidamiskindad. Võib olla kolla..
0.82€

KM-ta: 0.67€
UNIV
SILIKOON KINDAD HARJASTEGA
SILIKOON KINDAD HARJASTEGA
Multifunktsionaalsed harjastega kindad peopesal. Valmistatud silikoonist. Sobib kodutöödeks - nõudepesu, auto, vanni või tualeti pesemiseks. Võib kasutada lemmikloomade puhastamiseks ja hooldamiseks. Kogub kergesti riietelt ebemeid. Kindad on ku..
Multifunktsionaalsed harjastega kindad peopesal. Valmistatud sil..
4.88€

KM-ta: 4€
8 9 10 11
KUMMIKINDAD 35CM
KUMMIKINDAD 35CM
Nitriilkindad, antibakteriaalsed, pikkusega 35 cm. Vastupidav sellistele kemikaalidele nagu metanool, naatriumkülm, vitriool, heptaan. Rohelist värvi. Nitriil. Kogus pakis - 12 paari, kogus karbis - 120 paari...
Nitriilkindad, antibakteriaalsed, pikkusega 35 cm. Vastupidav se..
2.44€

KM-ta: 2€
10 11
TÖÖSTUSLIKUD KINDAD 45CM
TÖÖSTUSLIKUD KINDAD 45CM
Tööstuslikud nitriilkindad pikkusega 45 cm. Sobib tööks keemiliste materjalidega, naftatoodetega, laborites, tootmises. Rohelist värvi. Nitriil. Kogus pakis - 12 paari, kogus karbis - 120 paari..
Tööstuslikud nitriilkindad pikkusega 45 cm. Sobib tööks keemilis..
2.44€

KM-ta: 2€
8 9 10 11
KUMMIKINDAD 32CM
KUMMIKINDAD 32CM
Kemikaalidele vastupidavad kummikindad. Valmistatud neopreeni ja lateksi segust. Karestatud peopesa ja sõrmed pakuvad haaret. Kaitseb nõrkade hapete, desinfitseerimisvahendite, alkoholi, ketooni lahustite eest. Kinnaste pikkus - 32 cm. Neopreen,..
Kemikaalidele vastupidavad kummikindad. Valmistatud neopreeni ja ..
1.22€

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