No products found - Search results - Kornkammer Onlineshop

New in stock

Pflanzenwasser 125ml
140,00 € *
Butzwasser 125ml Set
21,00 € *
Golden Body Yogana-Set
146,40 € 125,90 € *
Golden Face Yogana-Set
137,00 € 119,00 € *
Golden Exclusive Yogana-Set
289,00 € 245,65 € *
Astaxanthin 60 capsules (89 g)
60,90 € 57,86 € *
Content: 89 g
Base Price: 650,11 € / Kg
Astaxanthin 60 capsules (180 g)
29,90 € 28,41 € *
Content: 180 g
Base Price: 157,83 € / Kg
Car-Bio-KAT PEN-YANG
178,00 € *

Fehler beim Senden der Abfrage: SELECT * FROM (SELECT produkte1.*, 2 as score FROM aong_shop_arts produkte1 WHERE (artname_en LIKE '%Orgon%' OR artnr LIKE '%Orgon%' OR hersteller LIKE '%Orgon%' OR seo_keywords_en LIKE '%Orgon%' ) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)) OR produkte1.ID IN (SELECT produktID FROM aong_shop_arts_variants_search, aong_shop_arts xxx WHERE produktID=produkte1.ID AND mainID=xxx.ID AND xxx.del='N' AND xxx.status='Y' AND mainID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('Orgon*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('Orgon*' IN BOOLEAN MODE) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)) OR produkte1.ID IN (SELECT produktID FROM aong_shop_arts_variants_search, aong_shop_arts xxx WHERE produktID=produkte1.ID AND mainID=xxx.ID AND xxx.del='N' AND xxx.status='Y' AND mainID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)))) ORDER BY score DESC) ut GROUP BY ID[Can't find FULLTEXT index matching the column list]Fehler beim Senden der Abfrage: SELECT * FROM (SELECT produkte1.*, 2 as score FROM aong_shop_arts produkte1 WHERE (artname_en LIKE '%Orgon%' OR artnr LIKE '%Orgon%' OR hersteller LIKE '%Orgon%' OR seo_keywords_en LIKE '%Orgon%' ) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)) OR produkte1.ID IN (SELECT produktID FROM aong_shop_arts_variants_search, aong_shop_arts xxx WHERE produktID=produkte1.ID AND mainID=xxx.ID AND xxx.del='N' AND xxx.status='Y' AND mainID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('Orgon*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('Orgon*' IN BOOLEAN MODE) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)) OR produkte1.ID IN (SELECT produktID FROM aong_shop_arts_variants_search, aong_shop_arts xxx WHERE produktID=produkte1.ID AND mainID=xxx.ID AND xxx.del='N' AND xxx.status='Y' AND mainID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,34,47,28,32,36,33,37,38,55,57,86,108,88,92,104,89,111,116,105,97,99,109,110,94,95,96,93,90,80,64,115,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,114,68,78,113,82,77,117,48,50,52,53,49,102,45,44,106,91,46,67,54,51,112,26,27,30,35)))) ORDER BY score DESC) ut GROUP BY ID LIMIT 0, 12[Can't find FULLTEXT index matching the column list]