matches.js | Powerful pattern matching for Javascript | Runtime Evironment library

SELECT 
    m.*, g.*, t1.*, t2.*
FROM
    matches m
        INNER JOIN
    `groups` g ON g.group_id = m.group_id
        INNER JOIN
    teams t1 ON t1.team_id = m.team_id_1
        INNER JOIN
    teams t2 ON t2.team_id = m.team_id_2

WITH
Home AS (
SELECT m.home_team_id AS team_id,t.team_name,
         SUM(CASE WHEN m.htft = '1/1' THEN 1 ELSE 0 END) AS 'h 1/1',
         SUM(CASE WHEN m.htft = 'X/1' THEN 1 ELSE 0 END) AS 'h X/1',
         SUM(CASE WHEN m.htft = 'X/X' TH

select top(1) ta.*
/* into table_output */
from table_20220121 ta 
join table_20220121_b tb on ta.ip = tb.ip 
  and ta.[Scroll Depth Threshold] = tb.[Scroll Depth Threshold]
order by [Time since 1970] desc;

with ma

WITH matches ( text, match, idx, num_matches ) AS (
  SELECT text,
         REGEXP_SUBSTR(text, '(obj.*?)(,|$)', 1, 1, NULL, 1),
         1,
         REGEXP_COUNT(text, '(obj.*?)(,|$)')
  FROM   test_me
UNION ALL
  SELECT text,
         RE

(SELECT 'kills' AS what, kills, gamemode, id   FROM matches ORDER BY kills DESC, id LIMIT 1)
UNION ALL
(SELECT 'deaths'       , deaths, gamemode, id  FROM matches ORDER BY deaths DESC, id LIMIT 1)
UNION ALL
(SELECT 'assists'      , assists

SELECT p.group_id, 
       SUBSTRING_INDEX(GROUP_CONCAT(p.player_id ORDER BY t.score DESC, p.player_id), ',', 1) winner_id
FROM players p
LEFT JOIN (
  SELECT player_id, SUM(score) score
  FROM (
    SELECT first_player player_id, first_sc

SELECT DISTINCT p.group_id, 
       FIRST_VALUE(p.player_id) OVER (PARTITION BY p.group_id ORDER BY m.score DESC) winner_id
FROM players p
LEFT JOIN (
  SELECT player, SUM(score) score
  FROM (
    SELECT match_id, first_player player, fir

SELECT T.TEAM_ID, T.TEAM, 
        SUM(points) AS Points, 
        SUM(HomeScore) AS 'Goals Scored', 
        SUM(AwayScore) AS 'Goals Received',
        SUM(HomeScore-AwayScore) 'GoalDiff'
 FROM 
Teams T 
LEFT JOIN
(SELECT HomeTeam AS Tea