{"queries":[{"id":"seasons","compiledQueryString":"select season from (\n select season, max(is_current_season::int) as is_current\n from scotland.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 scotland.mart_match_results\n group by season\n) order by is_current desc, season desc","compiled":false,"inline":true},{"id":"rounds","compiledQueryString":"select distinct\n season || '|' || cast(match_round_number as integer) as round_key,\n cast(match_round_number as integer) as round_number\nfrom scotland.mart_match_results\nwhere season = '${inputs.season.value}'\norder by round_number desc","inputQueryString":"select distinct\n season || '|' || cast(match_round_number as integer) as round_key,\n cast(match_round_number as integer) as round_number\nfrom scotland.mart_match_results\nwhere season = '${inputs.season.value}'\norder by round_number desc","compiled":false,"inline":true},{"id":"results","compiledQueryString":"select *,\n round(100.0 * total_goals / nullif(total_shots, 0), 1) as shot_conversion,\n round(100.0 * total_shots_on_goal / nullif(total_shots, 0), 1) as shot_accuracy,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom scotland.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by match_date desc","inputQueryString":"select *,\n round(100.0 * total_goals / nullif(total_shots, 0), 1) as shot_conversion,\n round(100.0 * total_shots_on_goal / nullif(total_shots, 0), 1) as shot_accuracy,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom scotland.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\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(100.0 * sum(total_goals) / nullif(sum(total_shots), 0), 1) as shot_conversion_pct,\n round(100.0 * sum(total_shots_on_goal) / nullif(sum(total_shots), 0), 1) as shot_accuracy_pct,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as goals_per_big_chance\n from (select *,\n round(100.0 * total_goals / nullif(total_shots, 0), 1) as shot_conversion,\n round(100.0 * total_shots_on_goal / nullif(total_shots, 0), 1) as shot_accuracy,\n referee_name as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom scotland.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by match_date desc)\n),\nprev as (\n select\n sum(total_goals) as prev_total_goals,\n round(100.0 * sum(total_goals) / nullif(sum(total_shots), 0), 1) as prev_shot_conversion_pct,\n round(100.0 * sum(total_shots_on_goal) / nullif(sum(total_shots), 0), 1) as prev_shot_accuracy_pct,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as prev_goals_per_big_chance\n from scotland.mart_match_results\n where season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer) - 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(100.0 * sum(total_goals) / nullif(sum(total_shots), 0), 1) as shot_conversion_pct,\n round(100.0 * sum(total_shots_on_goal) / nullif(sum(total_shots), 0), 1) as shot_accuracy_pct,\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(100.0 * sum(total_goals) / nullif(sum(total_shots), 0), 1) as prev_shot_conversion_pct,\n round(100.0 * sum(total_shots_on_goal) / nullif(sum(total_shots), 0), 1) as prev_shot_accuracy_pct,\n round(sum(total_goals)::double / nullif(sum(total_big_chances), 0), 2) as prev_goals_per_big_chance\n from scotland.mart_match_results\n where season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer) - 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 scotland.mart_round_potw\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by sort_order","inputQueryString":"select category, icon, player_name, player_photo, team_name, team_logo,\n stat_value, stat_label, sort_order\nfrom scotland.mart_round_potw\nwhere season = '${inputs.season.value}'\n and cast(match_round_number as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by sort_order","compiled":false,"inline":true},{"id":"last_updated","compiledQueryString":"select * from scotland.last_updated","inputQueryString":"select * from scotland.last_updated","compiled":false,"inline":true}]}

Match Results

Match Results — 2026/27 — Round 11