Fehler beim Senden der Abfrage: SELECT produkte1.*,MATCH(`artname_de`, `artnr`, `ean`, `hersteller`, `seo_keywords_de`) AGAINST ('Allco*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`artname_de`, `artnr`, `ean`, `hersteller`, `seo_keywords_de`) AGAINST ('Allco*' 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,720,721,492,581,582,493,563,339,342,344,346,388,391,393,395,397,399,401,405,497,499,507,560,584,595,597,611,624,650,656,657,651,625,612,598,596,606,561,652,500,498,571,463,490,565,400,653,398,503,562,566,396,458,505,564,568,583,394,502,534,574,392,535,623,389,511,587,347,452,473,620,345,501,504,567,570,588,590,343,390,494,530,573,602,337,445,495,514,541,738,569,515,517,520,546,641,642,643,664,496,510,37,77,252,363,369,373,421,431,439,440,442,544,38,46,61,75,96,159,189,235,31,48,67,71,80,97,104,118,121,142,243,256,264,271,257,286,292,298,334,368,411,488,536,545,244,250,258,262,335,376,414,415,453,692,210,248,259,274,291,296,308,309,384,387,407,413,467,486,521,742,743,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,723,105,164,206,360,98,100,111,131,166,367,707,733,81,120,132,136,141,149,202,295,712,732,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,465,288,299,301,303,330,333,352,371,412,416,423,526,731,353,372,382,543,675,527,702,241,260,267,277,302,456,459,485,537,558,644,704,740,741,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,461,649,680,693,695,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,126,192,216,358,739,56,55,146,464,170,58,26,50,53,60,76,154,160,171,172,176,198,204,214,231,669,103)) 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,720,721,492,581,582,493,563,339,342,344,346,388,391,393,395,397,399,401,405,497,499,507,560,584,595,597,611,624,650,656,657,651,625,612,598,596,606,561,652,500,498,571,463,490,565,400,653,398,503,562,566,396,458,505,564,568,583,394,502,534,574,392,535,623,389,511,587,347,452,473,620,345,501,504,567,570,588,590,343,390,494,530,573,602,337,445,495,514,541,738,569,515,517,520,546,641,642,643,664,496,510,37,77,252,363,369,373,421,431,439,440,442,544,38,46,61,75,96,159,189,235,31,48,67,71,80,97,104,118,121,142,243,256,264,271,257,286,292,298,334,368,411,488,536,545,244,250,258,262,335,376,414,415,453,692,210,248,259,274,291,296,308,309,384,387,407,413,467,486,521,742,743,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,723,105,164,206,360,98,100,111,131,166,367,707,733,81,120,132,136,141,149,202,295,712,732,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,465,288,299,301,303,330,333,352,371,412,416,423,526,731,353,372,382,543,675,527,702,241,260,267,277,302,456,459,485,537,558,644,704,740,741,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,461,649,680,693,695,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,126,192,216,358,739,56,55,146,464,170,58,26,50,53,60,76,154,160,171,172,176,198,204,214,231,669,103))))AND is_in_group<>'Y' ORDER BY score DESC[Can't find FULLTEXT index matching the column list]