LeafApp_Infinite

LeafApp_Infinite copied to clipboard

Should list journey of games throughout tourney

MariaDB [leafapp_infinite]> select count(*), faceit_id, name from matchup_teams group by faceit_id order by count(*) desc limit 15;
+----------+--------------------------------------+-----------------+
| count(*) | faceit_id                            | name            |
+----------+--------------------------------------+-----------------+
|     1345 | bye                                  | bye             |
|       59 | 717d66e6-f09a-4487-b09c-63ab19b799c1 | G1              |
|       55 | c4b74840-edee-458a-9719-ad95321a3b26 | Crowd Pleasers  |
|       53 | ce41ff95-70ad-473b-9515-2d9de48d5f16 | Business        |
|       52 | cc7ac234-1311-4656-bee8-bc0fc3dfd355 | Infernal        |
|       52 | 01400bb8-d0e3-49ea-87f0-c1428cfc7b31 | Dethruptor fans |
|       50 | 0f16ce31-8e85-454c-920f-1580369d4c75 | OpTic Gaming    |
|       49 | 7a6fb4f0-eb68-48ac-a2ac-0ebe9811ac32 | BBR             |
|       48 | 61aa59ce-55b2-46ef-bf74-ac205ba32788 | Stainers        |
|       46 | 53905529-8a02-48b6-bc49-4325d47bc784 | Dire Wolves     |
|       46 | 351ef3ff-48ee-4f32-9a77-3ed244b0d4d3 | Status Quo      |
|       46 | fee587b2-aec4-4b65-9007-905926e401eb | G2 Esports      |
|       44 | e30eb0d4-78cb-4fa7-96b2-1a2c955ebbfd | eUnited         |
|       44 | 42892ee2-2bfe-45ab-b216-f8137d9089b9 | Solaris         |
|       44 | deedae1f-0ab2-4010-a552-246c74cee28c | Cloud9          |
+----------+--------------------------------------+-----------------+

Missing a way to find the team players over time on a team. Need an updated_at on matchup_player

https://wikiki.github.io/components/timeline/