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 1384Printerid ja skännerid - IT market
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..
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..
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 ..
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 ..
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 ..