#565 [MEDIUM] apps.py N+1 query in list_versions endpoint

N+1 query pattern in list_versions endpoint. Each version fetches related data in separate queries instead of using JOINs or batch loading. Fix: Use SQL JOINs to fetch all related data in single query.