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(47997) 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/tehnika/domains/tehnikakaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/tehnika/domains/tehnikakaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/tehnika/domains/tehnikakaubad.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(47997) 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/tehnika/domains/tehnikakaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/tehnika/domains/tehnikakaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/tehnika/domains/tehnikakaubad.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(47997) 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/tehnika/domains/tehnikakaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/tehnika/domains/tehnikakaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/tehnika/domains/tehnikakaubad.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(47997) 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/tehnika/domains/tehnikakaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/tehnika/domains/tehnikakaubad.ee/public_html/catalog/model/module/mega_filter.php on line 1384 Segistid - Tehnikakaubad
See e-pood on müügis WebShopperi AFTERMARKETIS

Segistid - Tehnikakaubad

Segistid - Tehnikakaubad

Segistid - Tehnikakaubad

Segistid - Tehnikakaubad

Segistid - Tehnikakaubad
Segistid - Tehnikakaubad
Klienditugi
560 45 000
Kategooriad
Filtreeri
  • Hind
    € - €
  • Hinnang
    0
    0
    0
    0
    0
  • Lao staatus
    0
    0
    0
    0
    0
    0
Uued tooted
Toiduprotsessor ETA203890000 Gratus Kuliner II Org..
Toiduprotsessor ETA203890000 Gratus Kuliner II Org..
Virtuvinis kombainas ETA203890000 Gratus Kuliner II Orgin baltas ..

UUDIS
564.90€
Must teekann temperatuuriregulaatoriga ETA45959000..
Must teekann temperatuuriregulaatoriga ETA45959000..
Juodos spalvos arbatinukas su temperatūros reguliavimu ETA4595900..

UUDIS
40.90€
Avaleht » Sanitaartehnika » Segistid

Segistid

Kuva:
Näita korraga:
Sorteeri:
Tootevõrdlus (0)
Grohe AQA Pure Urban C-kujuline segisti BWT-..
Grohe AQA Pure Urban C-kujuline segisti BWT-..
Plautuvės maišytuvas                        GROHE  plautuvės maišytuvas su BWT kompanijos filtravimo sistema . Maišytuvas turi dvi svirtis vieną filtruotam , kitą nefiltruotam vandeniui . Filtruotas geriamas vanduo gali būti prisodrintas magniu min..
Plautuvės maišytuvas                        GROHE  plautuvės ma..
685.90€
KM-ta: 562.21€
Grohe AQA Pure Loft L-kujuline segisti BWT-f..
Grohe AQA Pure Loft L-kujuline segisti BWT-f..
Plautuvės maišytuvas                        GROHE plautuvės maišytuvas su BWT kompanijos filtravimo sistema . Maišytuvas turi dvi svirtis vieną filtruotam , kitą nefiltruotam vandeniui . Filtruotas geriamas vanduo gali būti prisodrintas magniu mine..
Plautuvės maišytuvas                        GROHE plautuvės mai..
866.90€
KM-ta: 710.57€
Veesegisti koos sissetõmmatava voolikuga Pl..
Veesegisti koos sissetõmmatava voolikuga Pl..
Vandens maišytuvas su ištraukiama žarna Plados -Telma  VEMIXEXTL MIS58L 26TG  Juoda matinė spalva   Ekologiškas nes tinkamas perdirbimui Plados-Telma maišytuvas Vemixextl yra pagamintas iš naujoviškų polimerinių medžiagų- tai absoliuti naujovė ir u..
Vandens maišytuvas su ištraukiama žarna Plados -Telma  VEMIXEXTL ..
262.90€
KM-ta: 215.49€
Paindliku ülaosaga veekraan Plados-Telma SP..
Paindliku ülaosaga veekraan Plados-Telma SP..
Vandens maišytuvas su lanksčia viršutine dalimi Plados-Telma SPRINGP30 chromas   Kruopščiai atrinkti komponentai, geriausių tiekėjų vandens maišymo kasetės, daugkartiniai patikrinimai gamybos etape ir kruopštūs bandymai -daro Plados Telma maišytuv..
Vandens maišytuvas su lanksčia viršutine dalimi Plados-Telma SPRI..
341.90€
KM-ta: 280.25€
Paindliku ülaosaga veekraan Plados-Telma SH..
Paindliku ülaosaga veekraan Plados-Telma SH..
Vandens maišytuvas su lanksčia viršutine dalimi Plados-Telma MIS89 chromas   Kruopščiai atrinkti komponentai, geriausių tiekėjų vandens maišymo kasetės, daugkartiniai patikrinimai gamybos etape ir kruopštūs bandymai -daro Plados Telma maišytuvus l..
Vandens maišytuvas su lanksčia viršutine dalimi Plados-Telma MIS8..
314.90€
KM-ta: 258.11€
Veekraan Plados-Telma VENMIXL MIS59 N6 NS Ri..
Veekraan Plados-Telma VENMIXL MIS59 N6 NS Ri..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
285.90€
KM-ta: 234.34€
Veekraan Plados-Telma VENMIXL MIS59 26TG Mus..
Veekraan Plados-Telma VENMIXL MIS59 26TG Mus..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
245.90€
KM-ta: 201.56€
Veekraan Plados-Telma VENMIXL MIS59 09 Chrom..
Veekraan Plados-Telma VENMIXL MIS59 09 Chrom..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
222.90€
KM-ta: 182.70€
Veekraan Plados-Telma QUAMIXL MGG05L 28TG Pi..
Veekraan Plados-Telma QUAMIXL MGG05L 28TG Pi..
Vienos svirties maišytuvas su kvadratiniu korpusu ir snapeliu. ..
Vienos svirties maišytuvas su kvadratiniu korpusu ir snapeliu. ..
267.90€
KM-ta: 219.59€
SOODUS
Veekraan Plados-Telma POLITEK20 28TG Piimava..
Veekraan Plados-Telma POLITEK20 28TG Piimava..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
213.90€ 177.95€
KM-ta: 145.86€
Veekraan Plados-Telma POLITEK20 26TG Must ma..
Veekraan Plados-Telma POLITEK20 26TG Must ma..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
213.90€
KM-ta: 175.33€
Veekraan Plados-Telma FLO65 09 Chrome
Veekraan Plados-Telma FLO65 09 Chrome
3 krypčių vienos svirties maišytuvas. Nepriklausomas trečiasis vandens valdymas. ..
3 krypčių vienos svirties maišytuvas. Nepriklausomas trečiasis v..
299.90€
KM-ta: 245.82€
Veekraan Plados -Telma VENMIXL MIS59 28TG Pi..
Veekraan Plados -Telma VENMIXL MIS59 28TG Pi..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
245.90€
KM-ta: 201.56€
Veekraan Plados -Telma POLITEK20 09 Chrome
Veekraan Plados -Telma POLITEK20 09 Chrome
Vienos svirties maišytuvas su L formos vamzdeliu. ..
Vienos svirties maišytuvas su L formos vamzdeliu. ..
191.90€
KM-ta: 157.30€
Veekraan Plados-Telma QUAMIXL MGG05L 26TG Mu..
Veekraan Plados-Telma QUAMIXL MGG05L 26TG Mu..
Vienos svirties maišytuvas su kvadratiniu korpusu ir snapeliu. ..
Vienos svirties maišytuvas su kvadratiniu korpusu ir snapeliu. ..
267.90€
KM-ta: 219.59€
Kraan FRANKE Smart 115.0391.481, roostevabas..
Kraan FRANKE Smart 115.0391.481, roostevabas..
Fikseeritud roostevabast terasest varrega kraan Franke SMART Toote tüüp: Nutikas Fikseeritud pööratava otsikuga segisti Juhtimine: nupp ülevalt Segisti kõrgus: 20 cm Segisti pöördenurk: 360 kraadi Ühendusvooliku pikkus 510 mm Läbilaskvus normaalse vo..
Fikseeritud roostevabast terasest varrega kraan Franke SMART Toot..
213.90€
KM-ta: 175.33€
Tehnikakaubad @ 2024 | Veebiturvalisuse tagab: veebikaitse.ee | Ostuturvalisuse tagab: ostugarantii.eeWebShopper