Difference between revisions of "Furniture/New Horizons/Music"
From Nookipedia, the Animal Crossing wiki
< Furniture | New Horizons
m (Text replacement - "nh_interior.en_name" to "nh_interior.category_sort,nh_interior.en_name") |
PanchamBro (talk | contribs) (Converting furniture query to module) |
||
(10 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
+ | {{DISPLAYTITLE:List of music-themed furniture in {{NH|short|nolink}}}} | ||
+ | This is a list of '''music-themed furniture''' in {{NH}}. | ||
__TOC__ | __TOC__ | ||
Line 4: | Line 6: | ||
{{TableTop NH Furniture}} | {{TableTop NH Furniture}} | ||
− | {{# | + | {{#invoke:NHFurnitureCargoQuery|main|limit=600|order by=nh_furniture.category_sort,nh_furniture.catalog_num|group by=nh_furniture.en_name|where=theme1{{=}}'Music' OR theme2{{=}}'Music'}} |
− | |||
− | | | ||
− | |group by=nh_furniture.en_name | ||
− | |||
− | |where=theme1='Music' OR theme2='Music' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | }} | ||
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
Line 24: | Line 15: | ||
{{#cargo_query: | {{#cargo_query: | ||
table=nh_interior | table=nh_interior | ||
− | |group by= | + | |group by=nh_interior.en_name |
− | |fields=en_name=name,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,color1,color2,theme1,theme2,grid_size=gridsize | + | |fields=en_name=name,catalog_num=catalog-num,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,color1,color2,theme1,theme2,grid_size=gridsize |
|where=theme1='Music' OR theme2='Music' | |where=theme1='Music' OR theme2='Music' | ||
− | |order by=nh_interior.category_sort,nh_interior. | + | |order by=nh_interior.category_sort,nh_interior.catalog_num |
|format=template | |format=template | ||
|template=CargoDisplayNHInterior | |template=CargoDisplayNHInterior | ||
Line 37: | Line 28: | ||
<br> | <br> | ||
− | {{Furniture}} | + | |
+ | == Former furniture/interior items == | ||
+ | The following furniture/interior items were formerly part of the Music HHA theme. | ||
+ | {{TableTop NH Furniture Themes|name=Furniture/interior items formerly classified as Music|collapsed=yes}} | ||
+ | {{#cargo_compound_query: | ||
+ | tables=nh_furniture,nh_furniture_variation; | ||
+ | join on=nh_furniture_variation.en_name = nh_furniture.en_name; | ||
+ | group by=nh_furniture.en_name; | ||
+ | fields=nh_furniture.en_name=name,nh_furniture._pageName=pagename,nh_furniture_variation.image,nh_furniture.theme1,nh_furniture.theme2,nh_furniture.former_theme1=former-theme1,nh_furniture.former_theme2=former-theme2; | ||
+ | where=nh_furniture.former_theme1 IS NOT NULL AND (nh_furniture.former_theme1 = "Music" OR nh_furniture.former_theme2 = "Music"); | ||
+ | limit=600 | ||
+ | |tables=nh_interior; | ||
+ | group by=nh_interior.en_name; | ||
+ | fields=nh_interior.en_name=name,nh_interior._pageName=pagename,nh_interior.image,nh_interior.theme1,nh_interior.theme2,nh_interior.former_theme1=former-theme1,nh_interior.former_theme2=former-theme2; | ||
+ | where=nh_interior.former_theme1 IS NOT NULL AND (nh_interior.former_theme1 = "Music" OR nh_interior.former_theme2 = "Music"); | ||
+ | limit=600 | ||
+ | |format=template | ||
+ | |template=CargoDisplayNHHHAThemes | ||
+ | |named args=yes | ||
+ | }} | ||
+ | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
+ | {{clear}} | ||
+ | {{Navbox Furniture}} | ||
[[Category:Lists of furniture]] | [[Category:Lists of furniture]] |
Latest revision as of 21:27, February 26, 2024
This is a list of music-themed furniture in Animal Crossing: New Horizons.
Furniture[edit]
Furniture in Animal Crossing: New Horizons
# | Item | Image | Buy price | Sell price | Available from | HHA theme(s) | Interact | Customizable | Size |
---|---|---|---|---|---|---|---|---|---|
9 | Acoustic guitar | ![]() |
Not for sale | ![]() |
![]() |
Music | Instrument | No | ![]() |
16 | Alto saxophone | ![]() |
![]() |
![]() |
![]() |
Music | Instrument | No | ![]() |
266 | Cello | ![]() |
![]() |
![]() |
![]() |
Music / Expensive | Instrument | No | ![]() |
306 | Clarinet | ![]() |
![]() |
![]() |
![]() ![]() |
Music | Instrument | No | ![]() |
725 | Gong | ![]() |
Not for sale | ![]() |
![]() |
Harmonious / Music | Instrument | No | ![]() |
733 | Grand piano | ![]() |
![]() |
![]() |
![]() |
Music / School | Instrument | No | ![]() |
765 | Harp | ![]() |
![]() |
![]() |
![]() |
Music | Instrument | No | ![]() |
975 | Marimba | ![]() |
![]() |
![]() |
![]() |
Music / School | Instrument | No | ![]() |
1,004 | Mic stand | ![]() |
![]() |
![]() |
![]() |
Music / Party | Instrument | No | ![]() |
1,091 | Music stand | ![]() |
Not for sale | ![]() |
![]() |
Music | Instrument | No | ![]() |
1,182 | PA speaker | ![]() |
![]() |
![]() |
![]() ![]() |
Concert / Music | Audio | No | ![]() |
1,243 | Piano bench | ![]() |
![]() |
![]() |
![]() |
Music / School | Seating | No | ![]() |
1,578 | Snare drum | ![]() |
![]() |
![]() |
![]() ![]() |
Concert / Music | Instrument | No | ![]() |
1,736 | Theremin | ![]() |
![]() |
![]() |
![]() ![]() |
Music | Instrument | No | ![]() |
1,756 | Timpani drums | ![]() |
![]() |
![]() |
![]() ![]() |
Music | Instrument | No | ![]() |
1,806 | Trumpet | ![]() |
![]() |
![]() |
![]() ![]() |
Music | Instrument | No | ![]() |
1,831 | Upright piano | ![]() |
![]() |
![]() |
![]() |
Music / School | Instrument | No | ![]() |
1,849 | Velvet stool | ![]() |
![]() |
![]() |
![]() |
Music / School | Seating | No | ![]() |
1,865 | Virgo harp | ![]() |
Not for sale | ![]() |
![]() |
Expensive / Music | Instrument | No | ![]() |
1,899 | Wedding pipe organ | ![]() |
![]() |
![]() |
![]() |
Party / Music | Instrument | No | ![]() |
528 | Fancy violin | ![]() |
![]() |
![]() |
![]() |
Music / Expensive | Instrument | No | ![]() |
1,003 | Metronome | ![]() |
![]() |
![]() |
![]() |
Music / School | Instrument | No | ![]() |
1,329 | Pro tape recorder | ![]() |
![]() |
![]() |
![]() |
Retro / Music | Stereo | No | ![]() |
1,330 | Professional headphones | ![]() |
![]() |
![]() |
![]() ![]() |
Music / Concert | Audio | No | ![]() |
1,381 | Record box | ![]() |
![]() |
![]() |
![]() |
Music / Retro | - | No | ![]() |
1,453 | Sampler | ![]() |
![]() |
![]() |
![]() ![]() |
Concert / Music | Audio | No | ![]() |
466 | Drapery | ![]() |
![]() |
![]() |
![]() ![]() |
Music / Facility | - | No | ![]() |
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.
Interior[edit]
Interior in Animal Crossing: New Horizons
# | Item | Image | Buy price | Sell price | Available from | Colors | HHA theme(s) | Size |
---|---|---|---|---|---|---|---|---|
44 | Black hallway wall | ![]() |
![]() |
![]() |
![]() |
Black
Black
|
Facility / Music | - |
46 | Black perforated-board wall | ![]() |
![]() |
![]() |
![]() |
Black
Black
|
Music / Facility | - |
115 | Brown hallway wall | ![]() |
![]() |
![]() |
![]() |
Brown
Brown
|
Facility / Music | - |
142 | Chocolate hallway wall | ![]() |
![]() |
![]() |
![]() |
Brown
Brown
|
Facility / Music | - |
291 | Heavy-curtain wall | ![]() |
![]() |
![]() |
![]() |
Red
Black
|
Music / Party | - |
445 | Perforated-board wall | ![]() |
![]() |
![]() |
![]() |
Brown
Brown
|
Music / Facility | - |
513 | Red perforated-board wall | ![]() |
![]() |
![]() |
![]() |
Red
Red
|
Music / Facility | - |
665 | White hallway wall | ![]() |
![]() |
![]() |
![]() |
White
White
|
Facility / Music | - |
674 | White perforated-board wall | ![]() |
![]() |
![]() |
![]() |
White
White
|
Music / Facility | - |
175 | Cork flooring | ![]() |
![]() |
![]() |
![]() |
Beige
Beige
|
School / Music | - |
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.
Former furniture/interior items[edit]
The following furniture/interior items were formerly part of the Music HHA theme.
Furniture/interior items formerly classified as Music in Animal Crossing: New Horizons
Item | Image | Former HHA theme(s) | Current HHA theme(s) |
---|
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.