Fehler beim Senden der Abfrage: SELECT produkte1.*,MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('palazzetti*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('palazzetti*' 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)) 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)))) 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 '%palazzetti%' OR artnr LIKE '%palazzetti%' OR hersteller LIKE '%palazzetti%' OR seo_keywords_en LIKE '%palazzetti%' ) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)) 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('palazzetti*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('palazzetti*' 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)) 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)))) 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 '%palazzetti%' OR artnr LIKE '%palazzetti%' OR hersteller LIKE '%palazzetti%' OR seo_keywords_en LIKE '%palazzetti%' ) AND produkte1.del='N' AND status='Y' AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)) 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)))) UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('palazzetti*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('palazzetti*' 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)) 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 (135,135,140,103,165,21,54,45,190,191,192,224,234,251,283,335,284,285,286,287,288,289,255,256,270,257,272,253,252,254,262,263,264,265,273,274,266,275,271,276,258,261,268,277,278,260,259,269,279,280,267,225,232,281,226,227,228,248,229,233,242,231,243,245,246,249,244,250,247,334,223,195,194,209,196,219,212,222,200,197,198,214,221,213,201,202,199,204,203,215,218,211,217,216,205,206,207,208,210,220,125,131,84,183,161,111,152,58,105,46,149,282,336,49,159,176,154,155,157,158,178,156,179,180,107,115,59,186,187,189,185,184,175,182,163,142,141,148,181,137,139,138,145,164)))) 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: