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(30511) 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(30511) 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(30511) 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(30511) 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 1384Kohvimasina hooldusvahendid - Tehnikakaubad
Araktiivse disainiga Vida veefilter on optimaalse ergonoomilise käsitsemisega. Elektrooniline indikaator tagab, et te ei jäta kunagi vahele õiget aega filtrikasseti vahetamiseks. Penguin veefilter sobib kõikidele standardsetele külmiku ustele.
Käe..
Araktiivse disainiga Vida veefilter on optimaalse ergonoomilise k..
Vähendavad tabletid Krups kohvimasinatele
Originaalne kalibreerimisvahend Krups kohvimasinatele - et teie masin kestaks kauem. Sisaldab: kaks pakki 40 g kaaliumivabastusainet ja veekaredusriba.
Krups, nagu ka teised kohvimasinad, vajavad korrapä..
BWT besthead filtripea
Universaalne filtripea automaatse sulgeventiili ja tagasivoolutõkke abil. Bypass-režiim otse filtripeale, ühendustoru 3/8. Sisaldab seinakinnitust, sobib BWT Bestmax S, V, M, XL, 2XL filtritele.
..
M DYDIS
Vesi on restoranide, kohvikute ja hotellide köögi põhitegur, mis aitab külalistel nautida iga lonksu ja iga suutäit. Täiesti puhtast veest valmistatud kohvi ja tee on lummava aroomi ja suurepärase maitsega. Kui keeduvesi on just õige, ei val..
M DYDIS
Vesi on restoranide, kohvikute ja hotellide köögi põhite..
Uue põlvkonna filtripea, mis on mõeldud kasutamiseks ainult Claris 3/8" BSP asenduskassettidega.
Veefiltripea omadused:
Vargusevastased kohaloleku seaded
Pikavahetus - lukustub vaid 45° pööramisega
Automaatne sisselaske- ja väljalaskeklapi sulg..
Uue põlvkonna filtripea, mis on mõeldud kasutamiseks ainult Clari..
BWT veefilter koos tsingi ja magneesiumiga vähendab kraanivees leiduvate kahjulike ainete, sealhulgas raskemetallide (nt plii ja vask) ja kloori hulka, mis võivad mõjutada lõhna ja maitset. Lisaks pakub see filter optimaalset kaitset lubjakivide lade..
BWT veefilter koos tsingi ja magneesiumiga vähendab kraanivees le..
2XL DYDIS
Vesi on restoranide, kohvikute ja hotelliköökide põhitarvik, aidates külalistel nautida iga lonksu ja iga suutäit. Täiesti puhtast veest valmistatud kohvi ja tee on lummava aroomi ja suurepärase maitsega. Kui keeduvesi on just õige, ei val..
2XL DYDIS
Vesi on restoranide, kohvikute ja hotelliköökide põhit..
BWT veefilter AQUAlizer toob teie koju esteetilisuse ja uusima tehnoloogia. Tänu BWT patenteeritud filtritehnoloogiale muudab see elegantne, puristliku disainiga lauaveefilter teie kohaliku kraanivee maitsvaks, kvaliteetselt magneesiumiga mineralisee..
BWT veefilter AQUAlizer toob teie koju esteetilisuse ja uusima te..
Vee pehmendaja BWT filter on spetsiaalselt mõeldud äärmiselt kõva vee töötlemiseks. See usaldusväärne vee kareduse vähendamine kaitseb kodumasinaid lubjakihi ladestumise eest. Lisaks vähendab spetsiaalselt projekteeritud filter ka raskemetalle (nt pl..
Vee pehmendaja BWT filter on spetsiaalselt mõeldud äärmiselt kõva..
Puhastustabletid KRUPSi kohvimasinatele. Puhastustablettide abil saate eemaldada kohvimasinast kohviõli jäägid ja rasva ning tagada, et teil oleks alati värske kohv.
Kogus - 10 tabletti. Puhastamine tuleb teostada vastavalt kasutatava kohvimasina..
Puhastustabletid KRUPSi kohvimasinatele. Puhastustablettide abil ..
Silikaatide ja magneesiumiga BWT veefiltri padrun sisaldab räni selle loomulikul kujul. Seda ei ole mitte ainult meeldiv juua, vaid see aitab ka säilitada normaalset nahka, juukseid ja küüsi. Räniga rikastatud vesi säilitab teie loomuliku ilu ja vaim..
Silikaatide ja magneesiumiga BWT veefiltri padrun sisaldab räni s..
Magneesiumiga BWT veefilter vähendab raskemetallide (nt plii ja vask) ja selliste ainete nagu kloor sisaldust, mis võivad mõjutada lõhna ja maitset. Lisaks pakub see optimaalset kaitset lubjakivide vastu ja rikastab vett ka väärtuslike magneesiummine..
Magneesiumiga BWT veefilter vähendab raskemetallide (nt plii ja v..
Uus topeltpuhastusefekt
1. faas: lahustab tõhusalt kohvipuru
Faas 2: pikaajaline puhtus ja kaitse
Kaudu uue koostisega kahefaasiline puhastustablett eemaldab usaldusväärselt kõik kohvirasva- ja õlijäägid, vabastades teid kibedast kohvi järel..
Uus topeltpuhastusefekt
1. faas: lahustab tõhusalt kohvipuru
..
XL DYDIS
Vesi on restoranide, kohvikute ja hotelliköökide põhitarvik, aidates külalistel nautida iga lonksu ja iga suutäit. Täiesti puhtast veest valmistatud kohvi ja tee on lummava aroomi ja suurepärase maitsega. Kui keeduvesi on just õige, ei valm..
XL DYDIS
Vesi on restoranide, kohvikute ja hotelliköökide põhita..