Fehler beim Senden der Abfrage: SELECT produkte1.*,MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('olsberg*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`artname_en`, `artnr`, `ean`, `hersteller`, `seo_keywords_en`) AGAINST ('olsberg*' 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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,164))))AND is_in_group<>'Y' 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 '%olsberg%' OR artnr LIKE '%olsberg%' OR hersteller LIKE '%olsberg%' OR seo_keywords_en LIKE '%olsberg%' ) 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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,164))))AND is_in_group<>'Y' UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('olsberg*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('olsberg*' 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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,164))))AND is_in_group<>'Y' 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 '%olsberg%' OR artnr LIKE '%olsberg%' OR hersteller LIKE '%olsberg%' OR seo_keywords_en LIKE '%olsberg%' ) 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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,164))))AND is_in_group<>'Y' UNION ALL SELECT produkte1.*,MATCH(`beschreibung_en`) AGAINST ('olsberg*') AS score FROM aong_shop_arts produkte1 WHERE MATCH(`beschreibung_en`) AGAINST ('olsberg*' 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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,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,225,232,226,227,228,229,233,242,231,243,245,246,244,247,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,207,208,210,220,125,131,183,161,111,152,58,105,46,149,49,159,176,154,155,157,158,178,156,179,180,107,115,59,166,188,186,187,189,185,184,175,182,163,142,141,144,148,181,137,139,138,164))))AND is_in_group<>'Y' ORDER BY score DESC) ut GROUP BY ID LIMIT 0, 8[Can't find FULLTEXT index matching the column list]
Note
No items found
Last viewed: