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(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/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(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/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(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/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(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/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 1384Käsitööriistad - Stuff in Shop
Astmeline koonuspuur - 3 tk
HHS TERAS - TITANIUMKATTEGA - puurid on vastupidavad. Need on valmistatud vastupidavast HHS terasest,ning sobivad suurepäraselt aukude puurimiseks nt PVC-sse, õhukese seinaga lehtedesse ja isegi metalli. Toode ei vaja e..
Mopihoidja konksuga metallist, liimitav 5 tk pakis
SUS 304 roostevabast terasest valmistatud, vee- ja roostekindel mopihoidja seinaosa, millel on pikk kasutusiga. See on varustatud liimiga ja suudab hoida kuni 10 naela, nii et teie mopi ja h..
Mopihoidja konksuga metallist, liimitav 5 tk pakis
SUS 3..
Uksesulgur sise- ja välisustele 65kg, must
Uksesulgurit saab kasutada nii sise- kui ka välisuksele, parem- või vasakukäelistele ustele, mille maksimaalne kaal on 65 kg ja maksimaalne laius 1100 mm. Toodet on lihtne paigaldada - seda saab kinn..
Uksesulgur sise- ja välisustele 65kg, must
Uksesulgurit s..
Puhastusharjad trellile 3tk
Trellile lisatud harjade komplekt osutub kasulikuks paljudes igapäevaelu valdkondades. Komplekt on kasulik nii töökojas, kodus, aias kui ka autos. Harjade harjad on valmistatud vastupidavast nailonist, mis ei paindu kas..
Puhastusharjad trellile 3tk
Trellile lisatud harjade komplekt ..
Betoonivorm kassipeaga must 50x50
Vastupidavast materjalist valmistatud korduvkasutatav betoonist vorm, mis sobib suurepäraselt kõnnitee sillutuskivide ise valmistamiseks.
Vorm võimaldab teil tee rajamisel vabalt kujundada elemente.
Lisades beto..
Betoonivorm kassipeaga must 50x50
Vastupidavast materjalist va..
Õlilambi taht rullis 2m
Puuvillane laternataht. Õlilambi taht on kergesti kohandatav lambi kujuga, vastupidav ja kergesti trimmitav.
Taht on 2m pikk, iga rulli pikkus umbes 2 meetrit ja 2cm lai.
Need tahid on lõigatavad, neil on väga hea õ..
Põrkepallid värvilised,4 tk pakis
Hüppepall on valmistatud kvaliteetsest ülikõrge tihedusega polüuretaanmaterjalist, mida iseloomustab suurepärane elastsus ja vastupidavus. See on mittetoksiline, lõhnatu, ohutu ja keskkonnasõbralik ning peab vastu..
Põrkepallid värvilised,4 tk pakis
Hüppepall on valmistatud kva..
Põrkepallid värvilised, 6 tk pakis
Hüppepall on valmistatud kvaliteetsest ülikõrge tihedusega polüuretaanmaterjalist, mida iseloomustab suurepärane elastsus ja vastupidavus. See on mittetoksiline, lõhnatu, ohutu ja keskkonnasõbralik ning peab vast..
Põrkepallid värvilised, 6 tk pakis
Hüppepall on valmistatud kv..
Tööriistade organiseerija kangast, riputatav
Tööriistarulli suurus on 49x29 cm (L x L), tööriistarulli kott on valmistatud kangast , kulumiskindel, kerge ja vastupidav, tõmblukud ja pandlad turvaliseks sulgemiseks.
5 lukuga kott on hea väikeste p..
Astmeline koonuspuur, HSS terasest, titaankattega, 3 tk komp, 4-20 mm
HSS teras, titaaniumiga kaetud - puurid on vastupidavad, valmistatud kiirest, vastupidavast ja vastupidavast HHS terasest. Toode ei vaja eelnevat puurimist.
Puurid on astmeli..
Ampermeeter digitaalne, suure LCD ekraaniga
Mahutavuse mõõtmine, suured voolu/pinge vahemikud. Mõõteriistal on suur ja kergesti loetav LCD-ekraan Toode on asendamatu tööriist igale hooldustehnikule. Välja töötatud vastavalt IEC-1010 standardi..
Ampermeeter digitaalne, suure LCD ekraaniga
Mahutavuse mõ..
Tugevad Neodymium magnetid 10 tk pakis
Väga tugev - neodümium magnetil on väga suur energiatihedus, mis muudab selle väga tugevaks, mis tekitab vaatamata oma väikestele mõõtmetele väga, tugeva magnetvälja.
- magnet on valmistatud väga kval..
Tugevad Neodymium magnetid 10 tk pakis
Väga tugev - neodü..
Neetimistangid, tugevad otsikud, mugavad käepidemed
Vastupidav neetimisvahend sobib ideaalselt väikeste tööde tegemiseks igas kodus või töökojas. Võimaldab teha sisekeermega neetliiteid. Hästi tasakaalustatud pikkade kummeeritud vartega kiirek..
Neetimistangid, tugevad otsikud, mugavad käepidemed
Vastup..
Klemmitangid koos tarvikute ja organiseerijaga, 0.25-10mm2 komplekt.
Kaablipress on valmistatud terasest, käepide on ergonoomiline ja mugav kasutamiseks.
SPETSIFIKATSIOON - vahemik 0,25-10 mm2; materjal: teras; mõõtmed: 18 / 7-16 / 4c..
Klemmitangid koos tarvikute ja organiseerijaga, 0.25-10mm2 komple..
Magnethoidja nugadele ja tööriistadele
Kahekordse magnetilise südamikule "kinnituvad" metallesemed kindlalt magnaethoidjale.
Magnethoidja saab kinnitada kruvide või kahepoolse teibi abil.
Magnethoidja töötab kodus, garaažis, stuudios ja töökojas..
Magnethoidja nugadele ja tööriistadele
Kahekordse magnetilise ..
Astmeline koonuspuur - 3 tk
HHS TERAS - TITANIUMKATTEGA - puurid on vastupidavad. Need on valmistatud vastupidavast HHS terasest,ning sobivad suurepäraselt aukude puurimiseks nt PVC-sse, õhukese seinaga lehtedesse ja isegi metalli. Toode ei vaja e..