The cloud of tags

SELECT COUNT(members.id) as importance, categories.* FROM yacs_members AS members, yacs_categories AS categories WHERE (members.anchor LIKE 'category:%') AND ((categories.active='Y') AND ((categories.expiry_date is NULL) OR (categories.expiry_date <= '0000-00-00 00:00:00') OR (categories.expiry_date > '2023-06-01 15:45:07')) AND (categories.nick_name NOT LIKE 'week%') AND (categories.nick_name NOT LIKE 'hebdomadaire') AND (categories.nick_name NOT LIKE 'month%') AND (categories.nick_name NOT LIKE 'mensuel')) AND (categories.id = SUBSTRING(members.anchor, 10)) GROUP BY members.anchor ORDER BY importance DESC, title, edit_date DESC LIMIT 0,200
1055: 'qgem6871_cyb.categories.id' isn't in GROUP BY