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(144) 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(144) 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(144) 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(144) 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 Vabaaja riided - Turvavarustus

Vabaaja riided - Turvavarustus

Vabaaja riided - Turvavarustus

Vabaaja riided - Turvavarustus

Vabaaja riided - Turvavarustus

Vabaaja riided - Turvavarustus
Vabaaja riided - 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 » Vabaaja riided

Vabaaja riided

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
M L XL 2XL 3XL
Adler Fit-T pikkade varrukatega meeste särk must
Adler Fit-T pikkade varrukatega meeste särk must
materjal 100% puuvill mõnusalt keha ümber hoidev pikad varrukad masinpestav 30C juures ..
materjal 100% puuvill mõnusalt keha ümber hoidev pikad var..
8.13€

KM-ta: 6.66€
M L XL 2XL
Adler Fit-T pikkade varrukatega särk valge
Adler Fit-T pikkade varrukatega särk valge
materjal 100% puuvill mõnusalt keha ümber hoidev pikad varrukad masinpestav 30C juures ..
materjal 100% puuvill mõnusalt keha ümber hoidev pikad var..
8.13€

KM-ta: 6.66€
S M L XL
TÖÖSÄRK
TÖÖSÄRK
Klassikaline pikkade varrukatega T-särk, kerge, mugav...
Klassikaline pikkade varrukatega T-särk, kerge, mugav...
9.15€

KM-ta: 7.50€
M L XL
MUST T-SÄRK
MUST T-SÄRK
T-särk meestele.  Puuvill 100%, 180g...
T-särk meestele.  Puuvill 100%, 180g...
7.32€

KM-ta: 6€
M L XL
SININE T-SÄRK
SININE T-SÄRK
Meeste T-särk, ümara kraega. Topeltõmblused kaelas, allääres ja varrukatel. 100% puuvill, 160 gsm...
Meeste T-särk, ümara kraega. Topeltõmblused kaelas, allääres ja ..
5.49€

KM-ta: 4.50€
L M XL
PUNANE TALVEJOPE
PUNANE TALVEJOPE
Soe, punast värvi jope, mis sobib kandmiseks külmal aastaajal. Sellel on 2 välistaskut ja 2 sisetaskut. 100% polüester...
Soe, punast värvi jope, mis sobib kandmiseks külmal aastaajal. S..
59.78€

KM-ta: 49€
S M
SININE TALVEJOPE
SININE TALVEJOPE
Eemaldatava kapuutsiga talvejope. Kootud siseküljel soojust hoidvad varrukad. Sellel on kaks sise- ja neli välistaskut. Välisvooder - 100% puuvill, täidis - 70% puuvill, 30% polüester...
Eemaldatava kapuutsiga talvejope. Kootud siseküljel soojust hoid..
78.08€

KM-ta: 64€
M
PUNANE TALVEJOPE
PUNANE TALVEJOPE
Punane äravõetava kapuutsiga talvejope, mis on kaunistatud lambanahaga. Käes on välistasku ja vöökohal kaks taskut. Samuti on kaks sisetaskut. Väljast 100% polüester, seest - 70% puuvill, 30% polüester, täidis - 100% puuvill...
Punane äravõetava kapuutsiga talvejope, mis on kaunistatud lamban..
78.08€

KM-ta: 64€
M
MUGAV TALVEJOPE
MUGAV TALVEJOPE
Soe, kerge ja eriti mugav talvejope. Polüester...
Soe, kerge ja eriti mugav talvejope. Polüester...
53.68€

KM-ta: 44€
3XL
TALVEJOPE
TALVEJOPE
Soe, tuulekindel talvejope. Varrukatel ja vöökohal on elastsed kummipaelad. Sellel on eemaldatav kapuuts. Polüester...
Soe, tuulekindel talvejope. Varrukatel ja vöökohal on elastsed k..
64.66€

KM-ta: 53€
48
TUULEKINDEL JOPE
TUULEKINDEL JOPE
Tuulekindel, soe jope. Kinnitatakse luku ja nööpidega. Vöökohal on kaks topelttaskut, kaks rinnataskut ja neli taskut sees. Polüester...
Tuulekindel, soe jope. Kinnitatakse luku ja nööpidega. Vöökohal..
64.66€

KM-ta: 53€
48
JOPE KEVAD- SÜGISHOOAJAKS
JOPE KEVAD- SÜGISHOOAJAKS
Jope kevad- või sügishooajaks. Eriti kerge. Tumesinist värvi kapuutsiga. Vöökohal ja rinnal on kaks taskut...
Jope kevad- või sügishooajaks. Eriti kerge. Tumesinist värvi ka..
54.90€

KM-ta: 45€
48 50
MUST TALVEJOPE
MUST TALVEJOPE
..
..
71.98€

KM-ta: 59€
M
TALVEJOPE
TALVEJOPE
Soe talvejope. Sisse on õmmeldud termomeeter, mis näitab temperatuuri jope kandmisel. Jope kinnitub nööpide ja lukuga. Polüester, puuvill...
Soe talvejope. Sisse on õmmeldud termomeeter, mis näitab tempera..
64.66€

KM-ta: 53€
M
TALVEJOPE
TALVEJOPE
Soe, tuulekindel jope. Eemaldatav kapuuts. Väljas on neli taskut ja sees kolm taskut. Polüester, puuvill...
Soe, tuulekindel jope. Eemaldatav kapuuts. Väljas on neli tasku..
53€

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