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(114) 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(114) 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(114) 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(114) 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 1384Objektiivid - Digikaubad
Tamron on uue objektiivi puhul kasutanud spetsiaalset peeglita kaameratele mõeldud objektiivi disaini ja saavutanud taas kompaktse suuruse, fikseerides ava pikimal fookuskaugusel f/6.3 peale. Objektiivi maksimaalne läbimõõt on kõigest 77mm. See 70–30..
Tamron on uue objektiivi puhul kasutanud spetsiaalset peeglita ka..
Maailma esimene f/2.8 universaalsuumobjektiiv täiskaader kaamerateleUus Tamron 28-200mm f/2.8-5.6 Di III RXD objektiiv saavutab f/2.8 ava 28 mm fookuskauguse juures. Maksimaalsed avad teiste fookuskauguste juures on f/3.5 – 50 mm, f/4.5 – 100 mm ja f..
Maailma esimene f/2.8 universaalsuumobjektiiv täiskaader kaamerat..
Ideaalne kaaslane hübriidkaamerateleTamroni 70-180mm f/2.8 Di III VXD objektiiv kaalub kõigest 810g, mis teeb sellest ideaalse kaaslase kompaktsete hübriidkaamerate ette. Objektiiv pakub laitmatut teravust terves suumivahemikus. Lisaks aitavad uued o..
Ideaalne kaaslane hübriidkaamerateleTamroni 70-180mm f/2.8 Di III..
Fotograaf Siim Kinnas: "24-70 mm on üks uskumatult universaalne fookuskauguste vahemik. Päris ausalt – kui mul kästaks elu lõpuni pildistada ainult ühe objektiiviga, siis see oleks just selles vahemikus suumobjektiiv. See võimaldab ühelt poolt teha l..
Fotograaf Siim Kinnas: "24-70 mm on üks uskumatult universaalne f..
Fotograaf Siim Kinnas: "24-70 mm on üks uskumatult universaalne fookuskauguste vahemik. Päris ausalt – kui mul kästaks elu lõpuni pildistada ainult ühe objektiiviga, siis see oleks just selles vahemikus suumobjektiiv. See võimaldab ühelt poolt teha l..
Fotograaf Siim Kinnas: "24-70 mm on üks uskumatult universaalne f..
Sony FE 85mm f/1.8 loodud Sony E-bajonetiga täiskaader ning poolkaader hübriidkaameratele. Pole paremat kobinatsiooni kui lühike tele-fiksobjektiiv, terav pilt ja sujuv bokeh. See objektiiv pakub korralikku pildikvaliteeti, suurepärast kontrolli tera..
Sony FE 85mm f/1.8 loodud Sony E-bajonetiga täiskaader ning poolk..
Tamroni uus SP 70-200mm f/2.8 Di VC USD G2 teleobjektiiv on edasiarendus vanast 70-200mm objektiivist. Uuel objektiivil on võetud kasutusele uus autofookuse mootor ning parendatud stabilisaatorit; loomulikult ka uuendatud optilist disaini. Lisaks on ..
Tamroni uus SP 70-200mm f/2.8 Di VC USD G2 teleobjektiiv on edasi..
Tamroni uus SP 70-200mm f/2.8 Di VC USD G2 teleobjektiiv on edasiarendus vanast 70-200mm objektiivist. Uuel objektiivil on võetud kasutusele uus autofookuse mootor ning parendatud stabilisaatorit; loomulikult ka uuendatud optilist disaini. Lisaks on ..
Tamroni uus SP 70-200mm f/2.8 Di VC USD G2 teleobjektiiv on edasi..
50mm objektiiv on võrdlemisi universaalne, kuna sellega pildistades on perspektiiv sama, nagu inimene oma silmadega maailma näeb. Seetõttu on selle objektiiviga tehtud pildid loomutruud. Samas tänu suurele ning ümarale avale saab teravussügavuse kerg..
50mm objektiiv on võrdlemisi universaalne, kuna sellega pildistad..
Kvaliteetne supersuum täiskaader kaamerate jaoksFE 24-240mm f/3.5-6.3 OSS on suurepärane valik nendele, kes soovivad hakata täiskaader kaameraid kasutama. See on täiuslik portree- ja maastikufotograafidele ning olukorras, kus soovite reisida vaid ühe..
Juba hea objektiivi uus mudel. Talleta fantastilisi loodusfotosid või tee spordireportaaži selle kvaliteetse Tamroni 150 - 600mm G2 telesuumobjektiiviga. Objektiiv on varustatud uue võimeka optilise pildistabilisaatoriga (VC Vibration Compensation) m..
Juba hea objektiivi uus mudel. Talleta fantastilisi loodusfotosid..
3,8× suumiga teleobjektiiv, mis sobib suurepäraselt nii fotode jäädvustamiseks kui videosalvestuseks. Tänu optilisele pildistabilisaatorile on võimalik saavutada teravad pildid ka nõrkades valgusoludes...
3,8× suumiga teleobjektiiv, mis sobib suurepäraselt nii fotode jä..
Fujinon XF 100-400mm f/4.5-5.6 R LM OIS WR on supertele suumobjektiiv, mis katab 35 mm ekvivalenina vahemiku 152–609 mm. Objektiivi optiline konstruktsioon koosneb 21 elemendist 14 grupis, millest lausa viis on ED (eriti madala dispersiooniga) elemen..
Fujinon XF 100-400mm f/4.5-5.6 R LM OIS WR on supertele suumobjek..
Valgusjõuline, terav ning varustatud uusimate tehnoloogiatega. Sony FE 28mm f/2.0 loodud Sony E-bajonetiga täiskaader ning poolkaader hübriidkaameratele. See pakub korralikku pildikvaliteeti, suurepärast kontrolli teravussügavuse üle ning mugavust pi..
Valgusjõuline, terav ning varustatud uusimate tehnoloogiatega. So..
50mm objektiiv on võrdlemisi universaalne, kuna sellega pildistades on perspektiiv sama, nagu inimene oma silmadega maailma näeb. Seetõttu on selle objektiiviga tehtud pildid loomutruud. Samas tänu suurele ning ümarale avale saab teravussügavuse kerg..
50mm objektiiv on võrdlemisi universaalne, kuna sellega pildistad..