Fehler beim Senden der Abfrage: SELECT produkte1.*,MATCH(`artname_de`, `artnr`, `ean`, `hersteller`, `seo_keywords_de`) AGAINST ('Kerbl*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`artname_de`, `artnr`, `ean`, `hersteller`, `seo_keywords_de`) AGAINST ('Kerbl*' IN BOOLEAN MODE) AND produkte1.del='N' AND status='Y' AND (menge > '0' AND menge >= ve) AND (produkte1.ID IN ( SELECT art_id FROM aong_shop_arts_kats WHERE kat_id IN (24,24,27,30,36,336,338,491,492,581,618,631,582,493,563,339,342,344,346,388,391,393,395,397,399,401,403,405,497,499,507,560,579,584,595,597,611,624,627,629,635,650,656,657,651,625,612,598,596,606,585,561,508,652,500,498,571,622,463,490,565,400,509,653,398,503,562,566,396,458,505,564,568,583,394,502,534,574,392,535,623,389,511,587,347,452,473,506,620,345,501,504,567,570,588,590,343,390,494,530,340,573,602,337,409,445,495,514,541,575,577,591,569,515,517,520,546,641,642,643,664,496,510,446,37,77,252,275,363,369,373,697,713,714,715,716,374,418,421,431,439,440,442,544,276,432,433,434,435,436,38,46,61,75,96,159,189,235,31,48,67,71,80,97,104,118,121,142,243,256,264,271,719,257,286,292,298,334,368,411,488,536,545,244,250,258,262,335,351,376,414,415,453,647,692,210,248,259,274,291,296,308,309,384,387,407,413,467,486,521,249,283,468,122,127,174,183,188,193,209,217,359,699,123,199,201,230,119,186,190,191,194,200,213,246,381,105,164,206,360,98,99,100,111,131,166,367,707,81,120,132,136,141,149,202,295,712,72,130,139,227,234,272,710,68,205,269,698,49,162,218,225,357,32,112,113,28,33,39,43,64,69,78,94,116,133,144,240,263,270,281,365,593,717,465,282,287,288,299,301,303,330,332,333,352,371,412,416,423,526,533,672,289,353,372,382,532,543,675,688,689,527,702,241,260,267,277,302,456,459,485,537,558,644,704,370,700,261,297,310,311,316,430,447,145,196,253,254,265,266,280,284,290,300,349,362,379,383,385,426,438,441,457,460,461,649,680,693,705,706,708,709,134,163,203,223,356,380,151,95,108,152,169,224,79,107,137,140,279,294,703,70,129,138,147,157,221,226,233,711,65,148,168,179,219,605,701,44,66,109,173,182,187,197,215,220,377,466,45,51,52,128,150,181,40,47,106,178,361,366,34,35,41,42,62,63,101,114,115,155,167,175,273,293,355,572,684,696,29,73,74,82,84,86,93,165,87,90,153,83,85,88,89,91,92,110,177,251,489,25,54,102,125,161,222,242,718,126,192,216,358,103,195,232,55,56,57,58,59,146,170,207,208,425,429,674,26,50,53,60,76,154,160,171,172,176,198,204,214,231,669)) 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,27,30,36,336,338,491,492,581,618,631,582,493,563,339,342,344,346,388,391,393,395,397,399,401,403,405,497,499,507,560,579,584,595,597,611,624,627,629,635,650,656,657,651,625,612,598,596,606,585,561,508,652,500,498,571,622,463,490,565,400,509,653,398,503,562,566,396,458,505,564,568,583,394,502,534,574,392,535,623,389,511,587,347,452,473,506,620,345,501,504,567,570,588,590,343,390,494,530,340,573,602,337,409,445,495,514,541,575,577,591,569,515,517,520,546,641,642,643,664,496,510,446,37,77,252,275,363,369,373,697,713,714,715,716,374,418,421,431,439,440,442,544,276,432,433,434,435,436,38,46,61,75,96,159,189,235,31,48,67,71,80,97,104,118,121,142,243,256,264,271,719,257,286,292,298,334,368,411,488,536,545,244,250,258,262,335,351,376,414,415,453,647,692,210,248,259,274,291,296,308,309,384,387,407,413,467,486,521,249,283,468,122,127,174,183,188,193,209,217,359,699,123,199,201,230,119,186,190,191,194,200,213,246,381,105,164,206,360,98,99,100,111,131,166,367,707,81,120,132,136,141,149,202,295,712,72,130,139,227,234,272,710,68,205,269,698,49,162,218,225,357,32,112,113,28,33,39,43,64,69,78,94,116,133,144,240,263,270,281,365,593,717,465,282,287,288,299,301,303,330,332,333,352,371,412,416,423,526,533,672,289,353,372,382,532,543,675,688,689,527,702,241,260,267,277,302,456,459,485,537,558,644,704,370,700,261,297,310,311,316,430,447,145,196,253,254,265,266,280,284,290,300,349,362,379,383,385,426,438,441,457,460,461,649,680,693,705,706,708,709,134,163,203,223,356,380,151,95,108,152,169,224,79,107,137,140,279,294,703,70,129,138,147,157,221,226,233,711,65,148,168,179,219,605,701,44,66,109,173,182,187,197,215,220,377,466,45,51,52,128,150,181,40,47,106,178,361,366,34,35,41,42,62,63,101,114,115,155,167,175,273,293,355,572,684,696,29,73,74,82,84,86,93,165,87,90,153,83,85,88,89,91,92,110,177,251,489,25,54,102,125,161,222,242,718,126,192,216,358,103,195,232,55,56,57,58,59,146,170,207,208,425,429,674,26,50,53,60,76,154,160,171,172,176,198,204,214,231,669))))AND is_in_group<>'Y' ORDER BY score DESC[Can't find FULLTEXT index matching the column list]