{"queries":[{"id":"seasons","compiledQueryString":"select season from (\n select season, max(is_current_season::int) as is_current\n from turkey.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 turkey.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(round_order as integer) as round_key,\n cast(round_order as integer) as round_order,\n round_label\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\norder by round_order desc","inputQueryString":"select distinct\n season || '|' || cast(round_order as integer) as round_key,\n cast(round_order as integer) as round_order,\n round_label\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\norder by round_order 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 coalesce(referee_name, '–') as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(round_order 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 coalesce(referee_name, '–') as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(round_order as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by match_date desc","compiled":false,"inline":true},{"id":"round_title","compiledQueryString":"select any_value(round_display) as label\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(round_order as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)","inputQueryString":"select any_value(round_display) as label\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(round_order as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)","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 coalesce(referee_name, '–') as referee,\n '' || match_name || '' as match_link,\n '' || match_short_name || '' as match_short_link\nfrom turkey.mart_match_results\nwhere season = '${inputs.season.value}'\n and cast(round_order 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 turkey.mart_match_results\n where season = '${inputs.season.value}'\n and cast(round_order 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 turkey.mart_match_results\n where season = '${inputs.season.value}'\n and cast(round_order 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":"totr","compiledQueryString":"select category, icon, team_name, team_short_name, team_logo,\n opponent_team_short_name, stat_value, stat_label, sort_order\nfrom turkey.mart_round_totr\nwhere season = '${inputs.season.value}'\n and cast(round_order as integer) = try_cast(split_part('${inputs.round.value ?? -1}', '|', 2) as integer)\norder by sort_order","inputQueryString":"select category, icon, team_name, team_short_name, team_logo,\n opponent_team_short_name, stat_value, stat_label, sort_order\nfrom turkey.mart_round_totr\nwhere season = '${inputs.season.value}'\n and cast(round_order 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 turkey.last_updated","inputQueryString":"select * from turkey.last_updated","compiled":false,"inline":true}]}

Match Results

Match Results — 2026/27 — undefined

Teams of the Round