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(111) 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(111) 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(111) 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(111) 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 Pusad ja fliisid - Turvavarustus

Pusad ja fliisid - Turvavarustus

Pusad ja fliisid - Turvavarustus

Pusad ja fliisid - Turvavarustus

Pusad ja fliisid - Turvavarustus

Pusad ja fliisid - Turvavarustus
Pusad ja fliisid - 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 » Pusad ja fliisid

Pusad ja fliisid

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
L XL 2XL
Adler Trendy Zipper meeste dressipluus must
Adler Trendy Zipper meeste dressipluus must
Adler Trendy puuvillane dressipluus koos kapuutsiga. Materjal: 100% puuvill 2 mahukat taskut ees Elastsed varruka otsad ja alumine äär Eest lukuga suletav Kapuuts paeltega reguleeritav ..
Adler Trendy puuvillane dressipluus koos kapuutsiga. M..
30.49€

KM-ta: 24.99€
M L XL 2XL 3XL 4XL
Cerva Sheldon dressipluus Hi-vis kollane
Cerva Sheldon dressipluus Hi-vis kollane
Cerva Sheldon kõrgnähtav HI-VIS lukuga dressipluus, millele on peale prinditud helkurribad.  Alumine äär on tehtud elastsest materjalist, mis ei lase tuulel alt sisse tulla. 35% puuvill & 65% polüester, 300/gm2 2 küljetaskut ..
Cerva Sheldon kõrgnähtav HI-VIS lukuga dressipluus, millele ..
74.21€

KM-ta: 60.83€
S M XL 2XL 3XL
CERVA BOYER JAKK MUST
CERVA BOYER JAKK MUST
Cerva Boyer meeste lukuga jakk on hästi veniv ja  hoiab keha soojas. Jakile on lisatud softshell materjali, mis aitab riide hoida kuivana sademete korral. Materjal: 96% polüester & 4% elastaan Õla ja varruka osad kaetud softsh..
Cerva Boyer meeste lukuga jakk on hästi veniv ja  hoia..
48.79€

KM-ta: 39.99€
S M L XL 2XL 3XL
CERVA BOYER JAKK HALL
CERVA BOYER JAKK HALL
Cerva Boyer meeste lukuga jakk on hästi veniv ja  hoiab keha soojas. Jakile on lisatud softshell materjali, mis aitab riide hoida kuivana sademete korral. Materjal: 96% polüester & 4% elastaan Õla ja varruka osad kaetud softsh..
Cerva Boyer meeste lukuga jakk on hästi veniv ja  hoia..
48.79€

KM-ta: 39.99€
M L XL
HELLY HANSEN DŽEMPER
HELLY HANSEN DŽEMPER
Helly Hanseni džemper CHELSEA EVOLUTION HOOD, mille kanga koostis võimaldab maksimaalset mugavust ega takista kehal hingamast. Toote disain on loodud selliselt, et see ei piiraks liikumisvabadust. Mugav moodsa disainiga džemper. Täispikk ees YKK..
Helly Hanseni džemper CHELSEA EVOLUTION HOOD, mille kanga ko..
106.14€

KM-ta: 87€
S L XL 2XL
PUSA
PUSA
DX kapuuts on valmistatud polüestrist elastaaniga, seega on see 4-suunaliselt veniv ja sobib ideaalselt tööle. Ideaalne kangas hoiab sind talvel soojas ja sobib hästi DX4 tööpükstega – nii näed sa välja tõeliselt kaasaegne ja stiilne. Niiskust ..
DX kapuuts on valmistatud polüestrist elastaaniga, seega on see 4..
76.86€

KM-ta: 63€
S M L XL 2XL 3XL
Džemper VENNER
Džemper VENNER
Helehalli värvi džemper. Hoiab suurepäraselt temperatuuri ja sobib kandmiseks külmal aastaajal. On kolm taskut. Tõmblukud on rohelist värvi. 100% polüester. ..
Helehalli värvi džemper. Hoiab suurepäraselt temperatuuri ja sobi..
39.04€

KM-ta: 32€
XL 2XL 3XL 4XL S M L 5XL
TUMEHALL KAMPSUN
TUMEHALL KAMPSUN
Uus disain, tumehall kampsun. See hoiab suurepäraselt soojust ja sobib kandmiseks külmal aastaajal. On kolm taskut. Tõmblukud on erekollased helkurmaterjaliga. 100% polüester..
Uus disain, tumehall kampsun. See hoiab suurepäraselt soojust ja..
39.04€

KM-ta: 32€
L
HALL KAMPSUN GRENDALE
HALL KAMPSUN GRENDALE
Halli värvi veekindel kampsun Greendale elastaaniga. Seest soojendatud fliismaterjal. Välispind on valmistatud Softshell materjalist. Kätised kinnituvad takjakleebistega. 94% polüester, 6% elastaan...
Halli värvi veekindel kampsun Greendale elastaaniga. Seest soojen..
43.92€

KM-ta: 36€
S M L 2XL XL
Fliis Džemper
Fliis Džemper
Tumesinine fliisist kampsun. Kõrge krae, tugevdatud õmblused õlgadel ja varrukatel. Ees on 2 taskut. Elastsed mansetid pakuvad mugavust ja toetavad randmeid. 100% polüester, 300 gsm...
Tumesinine fliisist kampsun. Kõrge krae, tugevdatud õmblused õlga..
24.40€

KM-ta: 20€
S M L XL 2XL 3XL 4XL 5XL
Džemper VENNER
Džemper VENNER
Tumehalli värvi džemper. Hoiab suurepäraselt temperatuuri ja sobib kandmiseks külmal aastaajal. On kolm taskut. Tõmblukud on punast värvi. 100% polüester...
Tumehalli värvi džemper. Hoiab suurepäraselt temperatuuri ja sobi..
39.04€

KM-ta: 32€
M S L XL 2XL 3XL 4XL 5XL
HELEHALL KAPUUTSIGA PUSA VENNER
HELEHALL KAPUUTSIGA PUSA VENNER
Helehall reguleeritava kapuutsiga kampsun. Sellel on kaks lukuga küljetaskut. Sees on fliisvooder. 100% polüester...
Helehall reguleeritava kapuutsiga kampsun. Sellel on kaks lukuga ..
34.16€

KM-ta: 28€
S M L XL 2XL 3XL 4XL 5XL
TUMEHALL KAPUUTSIGA PUSA VENNER
TUMEHALL KAPUUTSIGA PUSA VENNER
Reguleeritava kapuutsiga tumehalli värvi kampsun. Kaks taskut külgedel ja üks tasku rinnal. Taskutel on lukud. Sees fliisvooder. 100% polüester...
Reguleeritava kapuutsiga tumehalli värvi kampsun. Kaks taskut kül..
39.04€

KM-ta: 32€
M
VENNER PUSA
VENNER PUSA
Kahekihiline kapuutsiga talvekampsun. Altpoolt reguleeritav suurus. Kaks taskut külgedel ja üks rinnal. Taskutel on lukud. Sees fliisvooder.  100% polüester...
Kahekihiline kapuutsiga talvekampsun. Altpoolt reguleeritav suuru..
51.24€

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