Created
July 10, 2025 00:44
-
-
Save ianfoo/604b453afaa7d15279014946ff9609e2 to your computer and use it in GitHub Desktop.
Phish 2024 Top Tracks and Shows (by Phish.in votes)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT lc.likes AS likes, | |
| s.date, | |
| s.venue_name, | |
| tours.name | |
| FROM | |
| (SELECT count(*) likes, | |
| likable_id id | |
| FROM likes | |
| WHERE likable_type = 'Show' | |
| GROUP BY likable_id) lc | |
| INNER JOIN shows AS s ON lc.id = s.id | |
| INNER JOIN tours ON s.tour_id = tours.id | |
| WHERE s.date BETWEEN '2024-01-01'::date AND '2025-01-01'::date | |
| ORDER BY likes DESC | |
| LIMIT 20; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| likes | date | venue_name | name | |
| -------+------------+----------------------------------------+-------------------- | |
| 18 | 2024-04-21 | Sphere | Sphere 2024 | |
| 17 | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 15 | 2024-04-18 | Sphere | Sphere 2024 | |
| 15 | 2024-07-20 | Xfinity Center | Summer Tour 2024 | |
| 14 | 2024-04-19 | Sphere | Sphere 2024 | |
| 14 | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 13 | 2024-08-14 | The Woodlands | Summer Tour 2024 | |
| 13 | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 13 | 2024-07-30 | Chaifetz Arena, Saint Louis University | Summer Tour 2024 | |
| 13 | 2024-08-30 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 12 | 2024-04-20 | Sphere | Sphere 2024 | |
| 11 | 2024-08-31 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 10 | 2024-07-19 | Xfinity Center | Summer Tour 2024 | |
| 9 | 2024-07-24 | Mohegan Sun Arena | Summer Tour 2024 | |
| 9 | 2024-08-03 | Ruoff Music Center | Summer Tour 2024 | |
| 9 | 2024-07-21 | Xfinity Center | Summer Tour 2024 | |
| 9 | 2024-08-11 | Bethel Woods Center for the Arts | Summer Tour 2024 | |
| 9 | 2024-12-29 | Madison Square Garden | New Years Run 2024 | |
| 9 | 2024-08-18 | The Woodlands | Summer Tour 2024 | |
| 9 | 2024-08-29 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| (20 rows) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT lc.likes AS likes, | |
| t.title, | |
| s.date, | |
| s.venue_name, | |
| tours.name | |
| FROM | |
| (SELECT count(*) likes, | |
| likable_id id | |
| FROM likes | |
| WHERE likable_type = 'Track' | |
| GROUP BY likable_id) lc | |
| INNER JOIN tracks AS t ON lc.id = t.id | |
| INNER JOIN shows AS s ON t.show_id = s.id | |
| INNER JOIN tours ON s.tour_id = tours.id | |
| WHERE s.date BETWEEN '2024-01-01'::date AND '2025-01-01'::date | |
| ORDER BY likes DESC | |
| LIMIT 50 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| likes | title | date | venue_name | name | |
| -------+--------------------------------+------------+----------------------------------------+------------------------------------- | |
| 18 | Tweezer | 2024-07-30 | Chaifetz Arena, Saint Louis University | Summer Tour 2024 | |
| 14 | What's Going Through Your Mind | 2024-12-31 | Madison Square Garden | New Years Run 2024 | |
| 14 | Ghost | 2024-08-04 | Ruoff Music Center | Summer Tour 2024 | |
| 14 | Down with Disease | 2024-04-21 | Sphere | Sphere 2024 | |
| 13 | No Men In No Man's Land | 2024-07-20 | Xfinity Center | Summer Tour 2024 | |
| 13 | What's Going Through Your Mind | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 13 | Mondegreen Ambient Jam | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 13 | Simple | 2024-07-27 | Alpine Valley Music Theatre | Summer Tour 2024 | |
| 12 | Down with Disease | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 12 | Box of Rain | 2024-10-25 | MVP Arena | Divided Sky Foundation Benefit 2024 | |
| 12 | Pillow Jets | 2024-08-29 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 12 | Tweezer | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 12 | Sand | 2024-04-18 | Sphere | Sphere 2024 | |
| 11 | Your Pet Cat | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 11 | Human Nature | 2024-07-20 | Xfinity Center | Summer Tour 2024 | |
| 11 | Gotta Jibboo | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 10 | Wolfman's Brother | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 10 | Soul Planet | 2024-08-04 | Ruoff Music Center | Summer Tour 2024 | |
| 10 | The Moma Dance | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 10 | Wolfman's Brother | 2024-04-18 | Sphere | Sphere 2024 | |
| 10 | Pillow Jets | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 10 | Sand | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 10 | Kill Devil Falls | 2024-07-23 | Mohegan Sun Arena | Summer Tour 2024 | |
| 10 | Tweezer | 2024-04-18 | Sphere | Sphere 2024 | |
| 9 | Light | 2024-04-21 | Sphere | Sphere 2024 | |
| 9 | The Moma Dance | 2024-08-06 | Van Andel Arena | Summer Tour 2024 | |
| 9 | Scents and Subtle Sounds | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 9 | Chalk Dust Torture | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 9 | Life Saving Gun | 2024-04-18 | Sphere | Sphere 2024 | |
| 9 | Hey Stranger | 2024-07-19 | Xfinity Center | Summer Tour 2024 | |
| 9 | Fuego | 2024-04-20 | Sphere | Sphere 2024 | |
| 9 | My Friend, My Friend | 2024-08-09 | Bethel Woods Center for the Arts | Summer Tour 2024 | |
| 8 | Ruby Waves | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 8 | Ruby Waves | 2024-08-30 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 8 | Soundcheck | 2024-08-14 | The Woodlands | Summer Tour 2024 | |
| 8 | Monsters | 2024-07-20 | Xfinity Center | Summer Tour 2024 | |
| 8 | Back on the Train | 2024-07-20 | Xfinity Center | Summer Tour 2024 | |
| 8 | No Men In No Man's Land | 2024-08-16 | The Woodlands | Summer Tour 2024 | |
| 8 | Ghost | 2024-08-29 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 8 | Tweezer | 2024-08-09 | Bethel Woods Center for the Arts | Summer Tour 2024 | |
| 8 | Light | 2024-08-15 | The Woodlands | Summer Tour 2024 | |
| 8 | Sand | 2024-12-31 | Madison Square Garden | New Years Run 2024 | |
| 8 | Ruby Waves | 2024-12-29 | Madison Square Garden | New Years Run 2024 | |
| 8 | Pillow Jets | 2024-08-09 | Bethel Woods Center for the Arts | Summer Tour 2024 | |
| 8 | Oblivion | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 8 | Piper | 2024-07-30 | Chaifetz Arena, Saint Louis University | Summer Tour 2024 | |
| 8 | Theme From the Bottom | 2024-08-17 | The Woodlands | Summer Tour 2024 | |
| 8 | Ether Edge | 2024-07-30 | Chaifetz Arena, Saint Louis University | Summer Tour 2024 | |
| 7 | Ocelot | 2024-08-29 | Dick's Sporting Goods Park | Summer Tour 2024 | |
| 7 | Carini | 2024-07-23 | Mohegan Sun Arena | Summer Tour 2024 | |
| (50 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment