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(129) 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/stuffi/domains/stuffinshop.com/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/stuffi/domains/stuffinshop.com/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/stuffi/domains/stuffinshop.com/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(129) 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/stuffi/domains/stuffinshop.com/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/stuffi/domains/stuffinshop.com/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/stuffi/domains/stuffinshop.com/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(129) 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/stuffi/domains/stuffinshop.com/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/stuffi/domains/stuffinshop.com/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/stuffi/domains/stuffinshop.com/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(129) 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/stuffi/domains/stuffinshop.com/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/stuffi/domains/stuffinshop.com/public_html/catalog/model/module/mega_filter.php on line 1384Meestele - Stuff in Shop
Naljasokid paarissokid 2 paari pakis
Valged naljakad paarissokid on valmistatud kvaliteetsest puuvillasest materjalist, mis on pehme, hingav ja mugav kanda kogu päeva. Sokid on valmistatud kvaliteetsest polüester-puuvillasest kangast, mis on pehme..
Naljasokid paarissokid 2 paari pakis
Valged naljakad paarissok..
Täisautomaatne vihmavari 105cm, tumesinine, roostevabast terasest ribid.
Lihtne kasutada: automaatse toimimisega vihmavari, vihmavarjud, mis avanevad ja sulguvad automaatselt ühe nupuvajutusega
Kas sajab vihma, lund või lörtsi, selle vihmavarju 1..
Täisautomaatne vihmavari 105cm, hall, roostevabast terasest ribid.
Lihtne kasutada: automaatse toimimisega vihmavari, vihmavarjud, mis avanevad ja sulguvad automaatselt ühe nupuvajutusega
Kas sajab vihma, lund või lörtsi, selle vihmavarju 10 roos..
Salendav vöö, reguleeritav Velcro-kinnitus
Velcro kinnitus
35% lateks, 65% polüester
Hooldus: Ainult käsipesu, õhukuivata jahedas kohas riputades, mitte päikese käes. Ärge kuivatage trummelkuivatuses. Reguleeritav ja mugav: Meie vöökoha ümbris..
Peapael roosa, põrsastega polüestrist, hingav ja libisemisvastane
See jahutav peapael on suurepärane valik enamiku sise- ja välistegevuste jaoks, mis muudab teid stiilseks, kaitstes teid samal ajal päikesekiirte eest.
Peapael on valmistatud pol..
Peapael roosa, põrsastega polüestrist, hingav ja libisemisvastane..
Täisautomaatne vihmavari 105cm, must, roostevabast terasest ribid.
Lihtne kasutada: automaatse toimimisega vihmavari, vihmavarjud, mis avanevad ja sulguvad automaatselt ühe nupuvajutusega
Kas sajab vihma, lund või lörtsi, selle vihmavarju 10 roos..
Täisautomaatne vihmavari 105cm, seest punane, pealt must, roostevabast terasest ribid.
Lihtne kasutada: automaatse toimimisega vihmavari, vihmavarjud, mis avanevad ja sulguvad automaatselt ühe nupuvajutusega
Kas sajab vihma, lund või lörtsi, sell..
Täisautomaatne vihmavari 105cm, seest punane, pealt must, roostev..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt on valmistatud 92% polüestrist, 8% spandeksi kangast, tagamaks ülimat soojust ja minimeerides soojuskadu, kui temperatuur hakkab langema. See superpehme ja mugav meeste termoaluspesu o..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt on valmistatud 92% polüestrist, 8% spandeksi kangast, tagamaks ülimat soojust ja minimeerides soojuskadu, kui temperatuur hakkab langema. See superpehme ja mugav meeste termoaluspesu o..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt on valmistatud 92% polüestrist, 8% spandeksi kangast, tagamaks ülimat soojust ja minimeerides soojuskadu, kui temperatuur hakkab langema. See superpehme ja mugav meeste termoaluspesu o..
Termopesu meestele, ülimugav ja soe
Meie termoaluspesukomplekt..
Meeste kootud talvekindad, 3 paari komplektis hallid, tumesinised ja mustad avatud sõrmedega
Saate 3 paari kindaid 3 värvi, sealhulgas halli, tumesinise ja musta värvi, mida saavad kanda nii mehed kui ka naised. Kinnaste arv on piisav, et rahuldad..
Meeste kootud talvekindad, 3 paari komplektis hallid, tumesinised..
Soojad talvekindad, puutetundlikud kindad mobiiltelefoni kasutusvõimalusega.
Unisex sõrmevabad kindad on valmistatud polüestrist puuvillast ja kašmiirist, on pehmed ja mugavad ning ei ärrita nahka.
See sobib ideaalselt igapäevaseks kasutamiseks. ..
Soojad talvekindad, puutetundlikud kindad mobiiltelefoni kasutusvõimalusega.
Unisex sõrmevabad kindad on valmistatud polüestrist puuvillast ja kašmiirist, on pehmed ja mugavad ning ei ärrita nahka.
See sobib ideaalselt igapäevaseks kasutamiseks. ..
Soojad talvekindad, puutetundlikud kindad mobiiltelefoni kasutusvõimalusega.
Unisex sõrmevabad kindad on valmistatud polüestrist puuvillast ja kašmiirist, on pehmed ja mugavad ning ei ärrita nahka.
See sobib ideaalselt igapäevaseks kasutamiseks. ..
Soojad talvekindad, puutetundlikud kindad mobiiltelefoni kasutusvõimalusega.
Unisex sõrmevabad kindad on valmistatud polüestrist puuvillast ja kašmiirist, on pehmed ja mugavad ning ei ärrita nahka.
See sobib ideaalselt igapäevaseks kasutamiseks. ..