Fehler beim Senden der Abfrage: SELECT * FROM (SELECT produkte1.*, 2 as score FROM aong_shop_arts produkte1 WHERE (artname_en LIKE '%Innerlight%' OR artnr LIKE '%Innerlight%' OR hersteller LIKE '%Innerlight%' OR seo_keywords_en LIKE '%Innerlight%' ) 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 ('Innerlight*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('Innerlight*' 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 '%Innerlight%' OR artnr LIKE '%Innerlight%' OR hersteller LIKE '%Innerlight%' OR seo_keywords_en LIKE '%Innerlight%' ) 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 ('Innerlight*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('Innerlight*' 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]
Note
No items found
Last viewed: