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(64) 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/demopood/domains/demopood.ee/public_html/uus/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/demopood/domains/demopood.ee/public_html/uus/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/demopood/domains/demopood.ee/public_html/uus/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(64) 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/demopood/domains/demopood.ee/public_html/uus/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/demopood/domains/demopood.ee/public_html/uus/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/demopood/domains/demopood.ee/public_html/uus/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(64) 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/demopood/domains/demopood.ee/public_html/uus/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/demopood/domains/demopood.ee/public_html/uus/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/demopood/domains/demopood.ee/public_html/uus/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(64) 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/demopood/domains/demopood.ee/public_html/uus/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/demopood/domains/demopood.ee/public_html/uus/catalog/model/module/mega_filter.php on line 1384Naised - Demopood
Seda poodi on võimalik osta või rentida - www.webshopper.ee
More room to move.
With 80GB or 160GB of storage and up to 40 hours of battery life, the new iPod classic lets you enjoy up to 40,000 songs or up to 200 hours of video or any combination wherever you go.
Cover Flow.
Browse through your m..
More room to move.
With 80GB or 160GB of storage and up to..
Unprecedented power. The next generation of processing technology has arrived. Built into the newest VAIO notebooks lies Intels latest, most powerful innovation yet: Intel® Centrino® 2 processor technology. Boasting incredible speed, expanded wireles..
Unprecedented power. The next generation of processing technology..
The 30-inch Apple Cinema HD Display delivers an amazing 2560 x 1600 pixel resolution. Designed specifically for the creative professional, this display provides more space for easier access to all the tools and palettes needed to edit, format and com..
The 30-inch Apple Cinema HD Display delivers an amazing 2560 x 16..
Born to be worn.
Clip on the worlds most wearable music player and take up to 240 songs with you anywhere. Choose from five colors including four new hues to make your musical fashion statement.
Random meets rhythm.
With iTunes autofill, iPod ..
Born to be worn.
Clip on the worlds most wearable music player a..
120€96€ KM-ta: 80€
Kirjed 1 - 4, kirjeid kokku 4, lehekülgi 1
Tähelepanu! See veebileht salvestab küpsiseid, et tagada parim teenuse kvaliteet ning koguda infot keskkonna paremaks muutmiseks!
Telli parimad pakkumised oma e-postiIga päev uued pakkumised!