# Music (MoC)
## Overview
Everything about music in this vault. Part of the [[Media (MoC)]]. The full collection (shelf, wishlist, collection, Kanban board) lives in [[Music (Base).base]].
## Want to Listen to
<!-- QueryToSerialize: LIST FROM #type/media/album WHERE (status = "To Listen" OR status = "To Listen Again") AND public_note = true SORT priority ASC, manual_order ASC, file.name ASC -->
<!-- SerializedQuery: LIST FROM #type/media/album WHERE (status = "To Listen" OR status = "To Listen Again") AND public_note = true SORT priority ASC, manual_order ASC, file.name ASC -->
<!-- SerializedQuery END -->
## Wishlist
Public by design: a shareable gift list.
<!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Album", wishlist_priority AS "Wishlist Priority", join(formats, ", ") AS "Formats" FROM #type/media/album WHERE contains(ownership, "Wishlist") AND public_note = true SORT default(wishlist_priority, "9") ASC, priority ASC, file.name ASC -->
<!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Album", wishlist_priority AS "Wishlist Priority", join(formats, ", ") AS "Formats" FROM #type/media/album WHERE contains(ownership, "Wishlist") AND public_note = true SORT default(wishlist_priority, "9") ASC, priority ASC, file.name ASC -->
| Album | Wishlist Priority | Formats |
| ----- | ----------------- | ------- |
<!-- SerializedQuery END -->
## Listening
<!-- QueryToSerialize: LIST FROM #type/media/album WHERE status = "Listening" AND public_note = true SORT date_started DESC -->
<!-- SerializedQuery: LIST FROM #type/media/album WHERE status = "Listening" AND public_note = true SORT date_started DESC -->
<!-- SerializedQuery END -->
## Completed by Year
<!-- QueryToSerialize: TABLE WITHOUT ID y AS "Year", file.link AS "Album", length(filter(cd, (d) => startswith(d, y))) AS "Times", rating AS "Rating" FROM #type/media/album FLATTEN list(unique(map(filter(flat(list(dates_completed, dates_played, choice(status = "Listened", date_finished, null))), (d) => d), (d) => dateformat(date(d), "yyyy-MM-dd")))) AS cd FLATTEN unique(map(cd, (d) => substring(d, 0, 4))) AS y WHERE public_note = true SORT y DESC, file.name ASC -->
<!-- SerializedQuery: TABLE WITHOUT ID y AS "Year", file.link AS "Album", length(filter(cd, (d) => startswith(d, y))) AS "Times", rating AS "Rating" FROM #type/media/album FLATTEN list(unique(map(filter(flat(list(dates_completed, dates_played, choice(status = "Listened", date_finished, null))), (d) => d), (d) => dateformat(date(d), "yyyy-MM-dd")))) AS cd FLATTEN unique(map(cd, (d) => substring(d, 0, 4))) AS y WHERE public_note = true SORT y DESC, file.name ASC -->
| Year | Album | Times | Rating |
| ---- | ----- | ----- | ------ |
<!-- SerializedQuery END -->
## Ratings
<!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Album", rating AS "Rating" FROM #type/media/album WHERE rating AND public_note = true SORT rating ASC, file.name ASC -->
<!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Album", rating AS "Rating" FROM #type/media/album WHERE rating AND public_note = true SORT rating ASC, file.name ASC -->
| Album | Rating |
| ----- | ------ |
<!-- SerializedQuery END -->
## Works
Compositions I listen to or learn to play.
<!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Work", composers AS "Composer(s)", artists AS "Artist(s)", key AS "Key" FROM #type/music/work AND !#type/session WHERE public_note = true SORT file.name ASC -->
<!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Work", composers AS "Composer(s)", artists AS "Artist(s)", key AS "Key" FROM #type/music/work AND !#type/session WHERE public_note = true SORT file.name ASC -->
| Work | Composer(s) | Artist(s) | Key |
| --------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------- | ------- |
| [[Do I Wanna Know (Music Work)]] | <ul></ul> | <ul><li>[[Arctic Monkeys (Music Artist)]]</li></ul> | G minor |
| [[Nothing Else Matters (Music Work)]] | <ul></ul> | <ul><li>[[Metallica (Music Artist)]]</li></ul> | E minor |
| [[Seven Nation Army (Music Work)]] | <ul></ul> | <ul><li>[[The White Stripes (Music Artist)]]</li></ul> | E minor |
| [[Smoke on the Water (Music Work)]] | <ul></ul> | <ul><li>[[Deep Purple (Music Artist)]]</li></ul> | G minor |
| [[Three Little Birds (Music Work)]] | <ul><li>[[Bob Marley (Music Artist)]]</li></ul> | <ul><li>[[Bob Marley (Music Artist)]]</li></ul> | A major |
<!-- SerializedQuery END -->
## Artists
<!-- QueryToSerialize: TABLE WITHOUT ID file.link AS "Artist", artist_kind AS "Kind", years_active AS "Years Active" FROM #type/music/artist AND !#type/session WHERE public_note = true SORT file.name ASC -->
<!-- SerializedQuery: TABLE WITHOUT ID file.link AS "Artist", artist_kind AS "Kind", years_active AS "Years Active" FROM #type/music/artist AND !#type/session WHERE public_note = true SORT file.name ASC -->
| Artist | Kind | Years Active |
| --------------------------------------------------------------------------------------------------------------- | ----------- | ----------------------- |
| [[Arctic Monkeys (Music Artist)]] | Band | 2002–present |
| [[Bob Marley (Music Artist)]] | Solo artist | 1962-1981 |
| [[Deep Purple (Music Artist)]] | Band | 1968–1976, 1984–present |
| [[Metallica (Music Artist)]] | Band | 1981–present |
| [[The White Stripes (Music Artist)]] | Duo | 1997–2011 |
<!-- SerializedQuery END -->
## Notes
<!-- QueryToSerialize: LIST WITHOUT ID key FROM #type/media/album FLATTEN file.inlinks AS n WHERE !startswith(meta(n).path, "30 Areas/38 Media/") AND !startswith(meta(n).path, "30 Areas/34 Maps/") FLATTEN [n.file.tags] AS nt FLATTEN [n.public_note] AS np WHERE !econtains(nt, "#type/book") AND !econtains(nt, "#type/media") AND !econtains(nt, "#type/quote") AND !econtains(nt, "#type/creation/quote") AND !econtains(nt, "#type/map") AND !econtains(nt, "#type/folder_note") AND !econtains(nt, "#type/person") AND !econtains(nt, "#type/contact") AND !econtains(nt, "#type/highlight") AND length(nt) > 0 AND np = true GROUP BY n SORT key.file.name ASC -->
<!-- SerializedQuery: LIST WITHOUT ID key FROM #type/media/album FLATTEN file.inlinks AS n WHERE !startswith(meta(n).path, "30 Areas/38 Media/") AND !startswith(meta(n).path, "30 Areas/34 Maps/") FLATTEN [n.file.tags] AS nt FLATTEN [n.public_note] AS np WHERE !econtains(nt, "#type/book") AND !econtains(nt, "#type/media") AND !econtains(nt, "#type/quote") AND !econtains(nt, "#type/creation/quote") AND !econtains(nt, "#type/map") AND !econtains(nt, "#type/folder_note") AND !econtains(nt, "#type/person") AND !econtains(nt, "#type/contact") AND !econtains(nt, "#type/highlight") AND length(nt) > 0 AND np = true GROUP BY n SORT key.file.name ASC -->
<!-- SerializedQuery END -->
## Quotes
<!-- QueryToSerialize: LIST WITHOUT ID key FROM #type/media/album FLATTEN file.inlinks AS n WHERE !startswith(meta(n).path, "30 Areas/38 Media/") AND !startswith(meta(n).path, "30 Areas/34 Maps/") FLATTEN [n.file.tags] AS nt FLATTEN [n.public_note] AS np WHERE (econtains(nt, "#type/quote") OR econtains(nt, "#type/creation/quote")) AND np = true GROUP BY n SORT key.file.name ASC -->
<!-- SerializedQuery: LIST WITHOUT ID key FROM #type/media/album FLATTEN file.inlinks AS n WHERE !startswith(meta(n).path, "30 Areas/38 Media/") AND !startswith(meta(n).path, "30 Areas/34 Maps/") FLATTEN [n.file.tags] AS nt FLATTEN [n.public_note] AS np WHERE (econtains(nt, "#type/quote") OR econtains(nt, "#type/creation/quote")) AND np = true GROUP BY n SORT key.file.name ASC -->
<!-- SerializedQuery END -->
## References
## Related
- [[Media (MoC)]]
- [[Favorite Music (MoC)]]