query

WITH CTE_SportAttributes AS (
    SELECT 
        st.*, 
        str."SportId"
    FROM "dbo"."SportAttributes" AS st
    INNER JOIN "dbo"."SportAttributesRelation" AS str
    ON st."Id" = str."AttributeId"
), 
CTE_SportAttributeGroups AS (
    SELECT 
        sag.*, 
        sagr."SportId"
    FROM "dbo"."SportAttributeGroups" AS sag
    INNER JOIN "dbo"."SportAttributeGroupsRelation" AS sagr
    ON sag."Id" = sagr."AttributeGroupId"
)
SELECT *
FROM CTE_SportAttributes AS sa
INNER JOIN CTE_SportAttributeGroups AS sag
ON sa."SportId" = sag."SportId"
INNER JOIN "dbo"."Sports" as s
ON s."Id" = sa."SportId";