Fehler beim Senden der Abfrage: SELECT produkte1.*,MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('chaga*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('chaga*' 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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,26,27,30,35)))) ORDER BY score DESC[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 '%chaga%' OR artnr LIKE '%chaga%' OR hersteller LIKE '%chaga%' OR seo_keywords_en LIKE '%chaga%' ) 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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,26,27,30,35)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('chaga*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('chaga*' 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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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 '%chaga%' OR artnr LIKE '%chaga%' OR hersteller LIKE '%chaga%' OR seo_keywords_en LIKE '%chaga%' ) 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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,26,27,30,35)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('chaga*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('chaga*' 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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,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,28,33,32,36,34,37,38,47,55,57,86,108,88,92,104,89,111,105,99,109,110,94,95,96,100,93,90,80,64,74,85,73,66,107,76,60,70,65,58,79,61,63,75,62,59,69,103,81,84,68,78,82,77,106,91,46,67,54,51,112,48,50,52,53,49,102,45,44,26,27,30,35)))) ORDER BY score DESC) ut GROUP BY ID LIMIT 0, 12[Can't find FULLTEXT index matching the column list]
Note
No items found
Last viewed: