{"queries":[{"id":"seasons","compiledQueryString":"select season from (\n select season, max(is_current_season::int) as is_current\n from superligaen.mart_match_results\n group by season\n) order by is_current desc, season desc","inputQueryString":"select season from (\n select season, max(is_current_season::int) as is_current\n from superligaen.mart_match_results\n group by season\n) order by is_current desc, season desc","compiled":false,"inline":true},{"id":"rounds","compiledQueryString":"select distinct cast(match_round_number as integer) as round_number\nfrom superligaen.mart_match_results\nwhere season = '${inputs.season.value}'\norder by 1 desc","inputQueryString":"select distinct cast(match_round_number as integer) as round_number\nfrom superligaen.mart_match_results\nwhere season = '${inputs.season.value}'\norder by 1 desc","compiled":false,"inline":true},{"id":"results","compiledQueryString":"select *,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom superligaen.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${inputs.round.value ?? -1}\norder by match_date desc","inputQueryString":"select *,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom superligaen.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${inputs.round.value ?? -1}\norder by match_date desc","compiled":false,"inline":true},{"id":"round_kpis","compiledQueryString":"with curr as (\n select\n sum(total_goals) as total_goals,\n round(sum(total_goals)::double / count(distinct match_id), 2) as avg_goals_per_match,\n round(sum(total_shots_on_goal)::double / count(distinct match_id), 1) as avg_shots_on_goal,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as goals_per_big_chance\n from (select *,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom superligaen.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${inputs.round.value ?? -1}\norder by match_date desc)\n),\nprev as (\n select\n sum(total_goals) as prev_total_goals,\n round(sum(total_goals)::double / count(distinct match_id), 2) as prev_avg_goals_per_match,\n round(sum(total_shots_on_goal)::double / count(distinct match_id), 1) as prev_avg_shots_on_goal,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as prev_goals_per_big_chance\n from superligaen.mart_match_results\n where season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${(inputs.round.value ?? 1) - 1}\n)\nselect curr.*, prev.*\nfrom curr cross join prev","inputQueryString":"with curr as (\n select\n sum(total_goals) as total_goals,\n round(sum(total_goals)::double / count(distinct match_id), 2) as avg_goals_per_match,\n round(sum(total_shots_on_goal)::double / count(distinct match_id), 1) as avg_shots_on_goal,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as goals_per_big_chance\n from ${results}\n),\nprev as (\n select\n sum(total_goals) as prev_total_goals,\n round(sum(total_goals)::double / count(distinct match_id), 2) as prev_avg_goals_per_match,\n round(sum(total_shots_on_goal)::double / count(distinct match_id), 1) as prev_avg_shots_on_goal,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as prev_goals_per_big_chance\n from superligaen.mart_match_results\n where season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${(inputs.round.value ?? 1) - 1}\n)\nselect curr.*, prev.*\nfrom curr cross join prev","compiled":true,"inline":true},{"id":"potw","compiledQueryString":"select category, icon, player_name, player_photo, team_name, team_logo,\n stat_value, stat_label, sort_order\nfrom superligaen.mart_round_potw\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${inputs.round.value ?? -1}\norder by sort_order","inputQueryString":"select category, icon, player_name, player_photo, team_name, team_logo,\n stat_value, stat_label, sort_order\nfrom superligaen.mart_round_potw\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = ${inputs.round.value ?? -1}\norder by sort_order","compiled":false,"inline":true}]}

Match Results

Match Results — 2025/26 — Round 32