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(206) 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(206) 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(206) 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(206) 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 Guess - Turvavarustus

Guess - Turvavarustus

Guess - Turvavarustus

Guess - Turvavarustus

Guess - Turvavarustus

Guess - Turvavarustus
Guess - Turvavarustus
Kategooriad
Filtreeri
  • Hind
    € - €
  • Hinnang
    0
    0
    0
    0
    0
  • Lao staatus
    0
    0
    0
    0
    0
    0
    0
    0
Uued tooted
37 38 39 40 41 42 43 44 45 46
TÖÖSAAPAD BTEX SB
TÖÖSAAPAD BTEX SB
Turvajalatsid metallist varvastega. 100% polüester Fly -kootud..

UUDIS
48.98€
44 45 46 47
KERGED VABAAJAJALATSID
KERGED VABAAJAJALATSID
..

UUDIS
39.99€
Avaleht » BRÄNDID » Guess

Guess

Kuva:
Näita korraga:
Sorteeri:
Hind
Tootevõrdlus (0)
UNIV
Guess - müts
Guess - müts
..
..
30.40€

KM-ta: 24.92€
41
GUESS ketsid
GUESS ketsid
GUESS ketsid, värv Must Kujundus ja lisad Ühevärviline Nahk Platvormiga Ümar nina Polsterdatud sisetald 6-auguline nöörimine Profiiltald Tugevdatud kand Varbanina Kaubamärgi silt Polsterdatud saapasä..
GUESS ketsid, värv Must Kujundus ja lisad Üh..
81.23€

KM-ta: 66.58€
35 36 37 38 39 40 41
GUESS kontsakingad
GUESS kontsakingad
..
..
141.32€

KM-ta: 115.83€
35 36 37 38 39 40 41
GUESS paeltega poolsaabas
GUESS paeltega poolsaabas
..
..
151.48€

KM-ta: 124.17€
XS S M L XL
GUESS kleit
GUESS kleit
..
..
131.15€

KM-ta: 107.50€
XS S M XL
GUESS kleit
GUESS kleit
GUESS Kokteilikleit  Kujundus ja lisad Ühevärviline Kaelapael V-kaelus Nööbiliist Aluskleidiga Soonikkrae Taljesse töödeldud lõige Sügav dekoltee Väljalõige seljal Toon toonis õmblused Sile kang..
GUESS Kokteilikleit  Kujundus ja lisad ..
131.15€

KM-ta: 107.50€
S M
GUESS kleit
GUESS kleit
Võluv Guess kleit Zena annab enesekindla tunde. Suvine õlapaeltega kleit on läbikumav, pitsiline ja kaasaliikuv. Ilmekust lisab veetlev sats kaelusel , varrukaotstes on kummid ning sisemuses on osalise pikkusega aluskleit. Naudi kaaslaste tunnustavai..
Võluv Guess kleit Zena annab enesekindla tunde. Suvine õlapaelteg..
193.17€

KM-ta: 158.33€
w26 w27 w28 w29 w30 w31
GUESS teksapüksid
GUESS teksapüksid
..
..
91.40€

KM-ta: 74.92€
w26 w31 w32
GUESS teksapüksid
GUESS teksapüksid
..
..
101.57€

KM-ta: 83.25€
XS S M L XL
GUESS pluus
GUESS pluus
GUESS Pluus Kujundus ja lisad Loomamuster Šifoon Nööpkinnitusega krae Ühe nööbiga mansetid Tepitud ääris Sirge mansetilõige Nööbiliist Kergelt läbipaistev Kogu pinda kattev muster Klassikaline pluus ..
GUESS Pluus Kujundus ja lisad Loomamuster ..
81.23€

KM-ta: 66.58€
XS S M L XL
GUESS kampsun
GUESS kampsun
GUESS Kampsun Kujundus ja lisad Ühevärviline Viskoos Ümmargune kaelus Tikand Dekoratiivkivid Riba- / kootud soonikkrae Soonikkätised Veniv kangas Kuju hoidev LENZING™ ECOVERO™ viskoos* Mat..
GUESS Kampsun Kujundus ja lisad Ühevärviline..
60.90€

KM-ta: 49.92€
XS S M L XL
GUESS kampsun
GUESS kampsun
GUESS Kampsun  Kujundus ja lisad Trükitud logo Viskoos V-kaelus Dekoratiivkivid Riba- / kootud soonikkrae Soonikkätised Sügav dekoltee Kuju hoidev Pehme materjal LENZING™ ECOVERO™ viskoos* ..
GUESS Kampsun  Kujundus ja lisad Trükit..
91.40€

KM-ta: 74.92€
S
GUESS kampsun
GUESS kampsun
GUESS Kampsun  Kujundus ja lisad Trükitud logo Viskoos V-kaelus Dekoratiivkivid Riba- / kootud soonikkrae Soonikkätised Sügav dekoltee Kuju hoidev Pehme materjal LENZING™ ECOVERO™ viskoos* ..
GUESS Kampsun  Kujundus ja lisad Trükit..
91.40€

KM-ta: 74.92€
XS S L XL
GUESS kampsun
GUESS kampsun
GUESS Kampsun  Kujundus ja lisad Trükitud logo Viskoos V-kaelus Dekoratiivkivid Riba- / kootud soonikkrae Soonikkätised Sügav dekoltee Kuju hoidev Pehme materjal LENZING™ ECOVERO™ viskoos* ..
GUESS Kampsun  Kujundus ja lisad Trükit..
91.40€

KM-ta: 74.92€
XS S
GUESS dressipluus
GUESS dressipluus
GUESS Dressipluus Kujundus ja lisad Trükitud logo Dressikangas Ümmargune kaelus Pärlid Riba- / kootud soonikkrae Soonikkätised Üleulatuv õlaosa Lisandid Pehme materjal Materjal & hooldus ..
GUESS Dressipluus Kujundus ja lisad Trükitud..
91.40€

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