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(91) 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/prokids/domains/prokids.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/prokids/domains/prokids.ee/public_html/catalog/model/module/mega_filter.php on line 2564Warning: Invalid argument supplied for foreach() in /home/prokids/domains/prokids.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(91) 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/prokids/domains/prokids.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/prokids/domains/prokids.ee/public_html/catalog/model/module/mega_filter.php on line 2439Warning: Invalid argument supplied for foreach() in /home/prokids/domains/prokids.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(91) 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/prokids/domains/prokids.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/prokids/domains/prokids.ee/public_html/catalog/model/module/mega_filter.php on line 2227Warning: Invalid argument supplied for foreach() in /home/prokids/domains/prokids.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(91) 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/prokids/domains/prokids.ee/public_html/system/database/mmysqli.php on line 39Notice: Trying to get property of non-object in /home/prokids/domains/prokids.ee/public_html/catalog/model/module/mega_filter.php on line 1384 Autosse - ProKids
See e-pood on müügis WebShopperi AFTERMARKETIS

Autosse - ProKids

Autosse - ProKids

Autosse - ProKids

Autosse - ProKids

Autosse - ProKids
Autosse - ProKids
Klienditugi
560 45 000
Kategooriad
Filtreeri
  • Hind
    € - €
  • Hinnang
    0
    0
    0
    0
    0
  • Lao staatus
    0
    0
    0
    0
    0
    0
    0
Uued tooted
4469 BUTELKA MIO DO PICIA I KARMIENIA KR..
4469 BUTELKA MIO DO PICIA I KARMIENIA KR..
Neno Mio to butelka smart 3w1 ze smoczkiem antykolkowym, wpływają..

UUDIS
38.90€
4452 BIDON MIO2 ZE SŁOMKĄ BRĄZOWY
4452 BIDON MIO2 ZE SŁOMKĄ BRĄZOWY
Neno Mio 2 jest praktycznym zamiennikiem butelki, a jednocześnie ..

UUDIS
38.90€
Avaleht » Beebi- ja lastekaubad » Autosse

Autosse

Kuva:
Näita korraga:
Sorteeri:
Tootevõrdlus (0)
PÄIKESEVARI MIKI 1 TK. 36x45
PÄIKESEVARI MIKI 1 TK. 36x45
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud õrnast sünteetilisest kangast, kaunistatud vastupidava, esteetilise ja värvika Disney teemaga. Rulood rullitakse pärast nupu vajutamist automaatselt üles. Õrn kangas ei takista lapse n..
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud..
16.90€
KM-ta: 13.85€
PÄIKESEVARI FROZEN 1 TK. 36x45
PÄIKESEVARI FROZEN 1 TK. 36x45
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud õrnast sünteetilisest kangast, kaunistatud vastupidava, esteetilise ja värvika Disney teemaga. Rulood rullitakse pärast nupu vajutamist automaatselt üles. Õrn kangas ei takista lapse n..
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud..
16.90€
KM-ta: 13.85€
PÄIKESEVARI FROZEN
PÄIKESEVARI FROZEN
Värviliste motiividega päikesevarjud tutvustavad lastele Disney muinasjuttude maailma, muutes autos veedetud hetked meeldivamaks. Kardinad on esiklaasi külge kinnitatud kummist iminappadega, need sobivad kõigile automudelitele. Päikesesirmid on..
Värviliste motiividega päikesevarjud tutvustavad lastele Disney m..
7.90€
KM-ta: 6.48€
PÄIKESEVARI AUTO AKNALE 1 TK. 36x45
PÄIKESEVARI AUTO AKNALE 1 TK. 36x45
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud õrnast sünteetilisest kangast, kaunistatud vastupidava, esteetilise ja värvika Disney teemaga. Rulood rullitakse pärast nupu vajutamist automaatselt üles. Õrn kangas ei takista lapse n..
Päikesevari on mõeldud kõigile automudelitele. See on valmistatud..
16.90€
KM-ta: 13.85€
A0086 MUSTAD PÄIKESEKAITSE 2 TK
A0086 MUSTAD PÄIKESEKAITSE 2 TK
Kõigi autode küljeakende päikesevarjud. Need muudavad teie reisi päikeselistel päevadel meeldivamaks. Lihtne iminappadega kinnitada. Komplekti kuulub 2 tk kardinaid ja 2 iminappu. Hoiatus! Toode ei ole mänguasi. ..
Kõigi autode küljeakende päikesevarjud. Need muudavad teie reisi ..
2.90€
KM-ta: 2.38€
9340 PÄIKESEKAITSE 2 TK 44 \ '35
9340 PÄIKESEKAITSE 2 TK 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9328 SPIDERMAN rullkardin autosse 1 TK 36x45
9328 SPIDERMAN rullkardin autosse 1 TK 36x45
..
..
16.90€
KM-ta: 13.85€
9333 PÄIKESEKAITSE PRINTSESS 2 TK 44 \ '35
9333 PÄIKESEKAITSE PRINTSESS 2 TK 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9332 PÄIKESEKAITSE 2 TK 44 \ '35
9332 PÄIKESEKAITSE 2 TK 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9331 PÄIKESEKAITSE MINNIE & MICKEY 2TK 4..
9331 PÄIKESEKAITSE MINNIE & MICKEY 2TK 4..
..
..
7.90€
KM-ta: 6.48€
9329 PÄIKESEKAITSE 2 TK 44 \ '35
9329 PÄIKESEKAITSE 2 TK 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9330 PÄIKESEKAITSE MICKEY 2TK 44 \ '35
9330 PÄIKESEKAITSE MICKEY 2TK 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9324 Päiksekaitse autosse 2tk 44 \ '35
9324 Päiksekaitse autosse 2tk 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9323 Päiksekaitse autosse 2tk 44 \ '35
9323 Päiksekaitse autosse 2tk 44 \ '35
..
..
7.90€
KM-ta: 6.48€
9322 Päiksekaitse autosse 2tk 44 \ '35
9322 Päiksekaitse autosse 2tk 44 \ '35
..
..
7.90€
KM-ta: 6.48€
LASTE VAATLUSPEEGEL LED
LASTE VAATLUSPEEGEL LED
Valgustatud peegel lapse vaatlemiseks annab tänu oma suurele suurele vaatenurgale. Pöördmehhanism tagab lihtsa kohandamise vajadustega. Lisaks võimaldab peegel tänu LED-taustvalgusele vaatlemist ka öösel, mida saab juhtida komplekti kuuluva kaugjuhti..
Valgustatud peegel lapse vaatlemiseks annab tänu oma suurele suur..
32.90€
KM-ta: 26.97€
PEEGEL LASTE JÄLGIMISEKS AUTOS
PEEGEL LASTE JÄLGIMISEKS AUTOS
Lisapeegel autos tagab reisi ajal mugavuse ja turvalisuse. See võimaldab juhil jälgida koos temaga reisivat last ilma vajaduseta ümber pöörata. Peegel on sujuvalt reguleeritav igas suunas, mis võimaldab seda reguleerida, et tagada tagaistme parim ..
Lisapeegel autos tagab reisi ajal mugavuse ja turvalisuse. See võ..
7.90€
KM-ta: 6.48€
Butterfly padi 26X35 GRAPHITE
Butterfly padi 26X35 GRAPHITE
Butterfly padi tagab teie lapsele ohutu ja mugava reisi . Selle eriline kuju kohandub turvatoolil ja kärus istuva lapse peaga . Annab pea täiendava kaitse löökide eest . Ühelt poolt on see kaetud pehme minkilise kangaga ja teiselt poolt õrna puuvilla..
Butterfly padi tagab teie lapsele ohutu ja mugava reisi . Selle e..
11.90€
KM-ta: 9.75€
ProKids @ 2024 | Veebiturvalisuse tagab: veebikaitse.ee | Ostuturvalisuse tagab: ostugarantii.eeWebShopper