SELECT p.club, cl.club_id, SUM( cr.ranking_points ) AS ranking_points
FROM competition_results cr, competitions c, players p, clubs cl
WHERE c.competition_id = cr.competition_id && cr.player_id = p.player_id && p.club = cl.club && c.competition_date > "2024-09-01" AND c.competition_name NOT LIKE '%Section%' AND c.competition_type NOT LIKE '%Satellite%' && p.date_membership_paid >2024-06-30
GROUP BY p.club
ORDER BY ranking_points DESC
