Team Ranking at Event

No matching event found.

SQL query failed: [ERROR:  relation "match_2020" does not exist
LINE 11:    match_2020 AS match
            ^] SELECT
 '' || name || '' AS name,
 sq1.cmatch
FROM
 event,
 (SELECT
   event.id AS id_event,
   COUNT(match.*) AS cmatch
  FROM
   event,
   match_2020 AS match
  WHERE
   event.year = 2020
   AND event.date_start <= 1603658206 AND 1603658206 <= event.date_end
   AND match.id_event = event.id
   AND match.type = 2
   AND match.score_red != -1
  GROUP BY
   event.id
  ) AS sq1
WHERE
 event.id = sq1.id_event
ORDER BY
 event.name

© 2009-2019, Idle Loop Software Design, LLC