96 groepen gevonden

SELECT "g".*, "gs"."domain_full" AS "g_domain_full", "gs"."name", "gs"."profile_image" AS "g_profile_image", COUNT(*) AS "cnt" FROM "groups" AS "g" INNER JOIN "site" AS "gs" ON g.group_site_id = gs.id INNER JOIN "group_members" AS "gm" ON gm.group_site_id = gs.id AND gm.show_on_site = true AND gm.authorized = true INNER JOIN "site" AS "ms" ON ms.id = gm.member_site_id AND gm.show_on_site = true AND ms.status > 1 AND ms.sitehelp_approved = 1 AND ms.active = true GROUP BY "g"."id", "g"."group_site_id", "g"."founder_site_id", "g"."member_access", "g"."member_sort", "gs"."domain_full", "gs"."name", "gs"."profile_image" HAVING (COUNT(*) >= 3) ORDER BY "cnt" desc LIMIT 10