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(120) 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/digi/domains/digikaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/digi/domains/digikaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/digi/domains/digikaubad.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(120) 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/digi/domains/digikaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/digi/domains/digikaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/digi/domains/digikaubad.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(120) 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/digi/domains/digikaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/digi/domains/digikaubad.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/digi/domains/digikaubad.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(120) 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/digi/domains/digikaubad.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/digi/domains/digikaubad.ee/public_html/catalog/model/module/mega_filter.php on line 1384Telefonide tarvikud - Digikaubad
Natec Alvito on praktiline väike käsistatiiv ja traditsiooniline kolmejalgne statiiv ühes. See teeb selfide ja grupivõtete tegemise imelihtsaks. Kokkupanduna on statiiv nii väike, et seda on mugav kõikjale kaasa võtta ning pikendatult ulatub see 70 c..
Natec Alvito on praktiline väike käsistatiiv ja traditsiooniline ..
Xiaomi Mi juhtmevaba laadija võimaldab telefoni laadida nii püstises kui ka pikali asendis. Laadimiseks ei pea Sa eemaldama telefoni plastikust kaitseümbrist.
Kummeeritud libisemisvastane aluspind
Kiirlaadimine
Max 20 W laadimisvõimsus
Toetab ..
Xiaomi Mi juhtmevaba laadija võimaldab telefoni laadida nii püsti..
Universaalne telefonihoidik autosse koos integreeritud juhtmevaba laadijaga. Laadimine algab niipea, kui hoidik telefoni puutub ning tänu kiirlaadimisele puhub telefonile energia sisse ka lühikese sõidu kestel. Hoidik ühildub nutitelefonidega, mis to..
Universaalne telefonihoidik autosse koos integreeritud juhtmevaba..
Boya BY-WM4 PRO-K3 on 2,4 GHz juhtmevaba mikrofonisüsteem, mis on spetsiaalselt disainitud iOS seadmetele. Komplektis on saatja koos mikrofoniga ja kompaktne vastuvõtjat Lightning ühendusega. BY-WM4 PRO-K3 on professionaalne mikrofoni komplekt, mis t..
Boya BY-WM4 PRO-K3 on 2,4 GHz juhtmevaba mikrofonisüsteem, mis on..
Ülikompaktne Joby telefonihoidik on Sinu telefonile toeks igas olukottas. Micro Stand on niivõrd väike, et saad selle mugavalt taskusse libistada ja kõikjal kaasas kanda. Saab kasutada nii kaitseümbrisega kui ilma.
Universaalne disain ühildub 56–9..
Ülikompaktne Joby telefonihoidik on Sinu telefonile toeks igas ol..
Universaalne telefonihoidik autosse, mis kinnitub auto ventilatsiooniavasse. Hoidik püsib ventilatsioonivõredes kindlalt ka rappuval teel ning sobib enamike telefonidega (mille maksimaalne laius on 85 mm). 360° pööratav disain võimaldab telefoni pöör..
Universaalne telefonihoidik autosse, mis kinnitub auto ventilatsi..
GripTight One – loodud sobima iga nutitelefoniga, nii ümbrisega kui ilma. See võimaldab telefoni kinnitada statiivile, üksjalale või käsistatiivile lihtsa 1/4" keerme kaudu. Adapter sobib kasutamiseks telefonidega, mille laius on 56–91 mm. Kui telefo..
GripTight One – loodud sobima iga nutitelefoniga, nii ümbrisega k..
Profitasemel GripTight Mount PRO statiiviadapteriga on tagatud teravad pildid, stabiilsed videod ja on-the-go vlogid. Adapteri universaalne disain mahutab 56–91 mm laiused nutitelefonid.
Turvaline GripTight tehnoloogia
Mahutab kõik nutitelefonid ..
Profitasemel GripTight Mount PRO statiiviadapteriga on tagatud te..
GripTight One – loodud sobima iga nutitelefoniga, nii ümbrisega kui ilma. See võimaldab telefoni kinnitada statiivile, üksjalale või käsistatiivile lihtsa 1/4" keerme kaudu. Adapter sobib kasutamiseks telefonidega, mille laius on 56–91 mm. Kui telefo..
GripTight One – loodud sobima iga nutitelefoniga, nii ümbrisega k..
Profitasemel GripTight PRO 2 statiiviadapteriga on tagatud teravad pildid, stabiilsed videod ja on-the-go vlogid. Adapteri universaalne disain mahutab 56–91 mm laiused nutitelefonid.
Turvaline GripTight tehnoloogia
Lihtne kallutada ja vahetada ve..
Profitasemel GripTight PRO 2 statiiviadapteriga on tagatud terava..
Rode VideoMic Me mikrofon on kompaktne ja kerge suundmikrofon, mis ühildub otse nutiseadme kõrvaklapi (TRRS) pesasse. Tänu muudetava suurusega kinnitusele ühildub mikrofon paljude nutitelefonidega. Mikrofoni tagumises osas on ka kõrvklapipesa, mis võ..
Rode VideoMic Me mikrofon on kompaktne ja kerge suundmikrofon, mi..
85.39€ KM-ta: 69.99€
Kirjed 1 - 11, kirjeid kokku 11, lehekülgi 1
Tähelepanu! See veebileht salvestab küpsiseid, et tagada parim teenuse kvaliteet ning koguda infot keskkonna paremaks muutmiseks!