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(91,'92','93','94','95') 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/itmarket/domains/itmarket.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/itmarket/domains/itmarket.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/itmarket/domains/itmarket.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(91,'92','93','94','95') 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/itmarket/domains/itmarket.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/itmarket/domains/itmarket.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/itmarket/domains/itmarket.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(91,'92','93','94','95') 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/itmarket/domains/itmarket.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/itmarket/domains/itmarket.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/itmarket/domains/itmarket.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(91,'92','93','94','95') 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/itmarket/domains/itmarket.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/itmarket/domains/itmarket.ee/public_html/catalog/model/module/mega_filter.php on line 1384 Printerid ja skännerid - IT market
See e-pood on müügis WebShopperi AFTERMARKETIS

Printerid ja skännerid - IT market

Printerid ja skännerid - IT market

Printerid ja skännerid - IT market

Printerid ja skännerid - IT market

Printerid ja skännerid - IT market
Printerid ja skännerid - IT market
Klienditugi
560 45 000
Kategooriad
Filtreeri
  • Hind
    € -
  • Hinnang
    0
    0
    0
    0
    0
  • Lao staatus
    0
    0
    0
    0
    0
    0

Printerid ja skännerid

Täpsusta valikut

Kuva:
Näita korraga:
Sorteeri:
Laser Printer PANTUM BP5100DN USB 2.0 BP5100DN
Laser BP5100DN USB 2.0 Windows 10 Windows 8 Windows 7 Linux MacOS Windows XP Windows Vista Paper size A4/210 C- 297 Resolution 1200x1200 dpi First print 6.9 sec Print speed PPM 40 Memory (RAM) 512MB Dimensions 364*344*257mmGarantii: 24..
Laser BP5100DN USB 2.0 Windows 10 Windows 8 Windows 7 Linux..
238.95€
KM-ta: 195.86€
Laser Printer CANON LBP243dw USB 2.0 WiFi ETH 595..
Laser LBP243dw USB 2.0 WiFi ETH Windows 11 Windows 10 Linux MacOS Paper size A4/210 C- 297 Paper input 350 sheets Paper output 150 sheets Resolution 1200x1200 dpi First print 5 sec Print speed PPM 36 Memory (RAM) 1GB Supplies, black ..
Laser LBP243dw USB 2.0 WiFi ETH Windows 11 Windows 10 Linu..
203.95€
KM-ta: 167.17€
Colour Laser Printer HP Color LaserJet Pro M255dw..
Laser Color LaserJet Pro M255dw Colour printing USB 2.0 WiFi ETH Paper size A4/210 C- 297 Paper input 250 sheets Paper output 100 sheets Memory (RAM) 256MB Duty Cycle 40000 Pages/month Dimensions 392 x 475x 297 mmGarantii: 12/24 kuud!..
Laser Color LaserJet Pro M255dw Colour printing USB 2.0 WiFi ..
381.95€
KM-ta: 313.07€
Colour Laser Printer KYOCERA ECOSYS P7240cdn USB ..
Garantii: 12 kuud!..
Garantii: 12 kuud!..
904.95€
KM-ta: 741.76€
Colour Laser Printer HP LaserJet Pro M454dw USB 2..
Laser LaserJet Pro M454dw Colour printing USB 2.0 WiFi ETH Windows 10 Windows 8 Windows 7 MacOS Paper size A4/210 C- 297 Paper input 250 sheets Paper output 150 sheets First print 9.5 sec Print speed PPM 28 Memory (RAM) 512MB Duty Cyc..
Laser LaserJet Pro M454dw Colour printing USB 2.0 WiFi ETH ..
582.95€
KM-ta: 477.83€
Laser Printer HP LaserJet Pro M501dn USB 2.0 ETH ..
Laser LaserJet Pro M501dn USB 2.0 ETH Windows 10 Windows 8 Windows 7 Linux MacOS Windows Vista Paper size A4/210 C- 297 Paper input 100 sheets Paper output 250 sheets First print 5.8 sec Print speed PPM 43 Memory (RAM) 256MB Duty Cycl..
Laser LaserJet Pro M501dn USB 2.0 ETH Windows 10 Windows 8 ..
461.95€
KM-ta: 378.65€
Colour Laser Printer CANON i-SENSYS LBP673Cdw WiF..
Garantii: 12/24 kuud!..
Garantii: 12/24 kuud!..
300.95€
KM-ta: 246.68€
IT market @ 2024 | Veebiturvalisuse tagab: veebikaitse.ee | Ostuturvalisuse tagab: ostugarantii.eeWebShopper

AutoBot

Mina olen WebShopperi AutoBot. Klienditeenindaja robotist abiline.