Difference between revisions of "Furniture/New Horizons/Fitness"
From Nookipedia, the Animal Crossing wiki
< Furniture | New Horizons
PanchamBro (talk | contribs) (adding display title) |
PanchamBro (talk | contribs) m (Text replacement - "|group by=nh_interior.en_name |fields=en_name=name" to "|group by=nh_interior.en_name |fields=en_name=name,catalog_num=catalog-num") |
||
(5 intermediate revisions by the same user not shown) | |||
Line 10: | Line 10: | ||
|join on=nh_furniture_variation.en_name = nh_furniture.en_name | |join on=nh_furniture_variation.en_name = nh_furniture.en_name | ||
|group by=nh_furniture.en_name | |group by=nh_furniture.en_name | ||
− | |fields=nh_furniture.en_name=name,nh_furniture_variation.image,nh_furniture.buy1_price=buy1-price,nh_furniture.buy1_wikitext=buy1,nh_furniture.sell,nh_furniture.availability1,nh_furniture.availability2,nh_furniture.theme1,nh_furniture.theme2,nh_furniture.function1,nh_furniture.function2,nh_furniture.customizable,nh_furniture.grid_size=gridsize | + | |fields=nh_furniture._pageName=pagename,nh_furniture.en_name=name,nh_furniture.catalog_num=catalog-num,nh_furniture_variation.image,nh_furniture.buy1_price=buy1-price,nh_furniture.buy1_wikitext=buy1,nh_furniture.sell,nh_furniture.availability1,nh_furniture.availability2,nh_furniture.theme1,nh_furniture.theme2,nh_furniture.function1,nh_furniture.function2,nh_furniture.customizable,nh_furniture.grid_size=gridsize |
|where=theme1='Fitness' OR theme2='Fitness' | |where=theme1='Fitness' OR theme2='Fitness' | ||
− | |order by=nh_furniture.category_sort,nh_furniture. | + | |order by=nh_furniture.category_sort,nh_furniture.catalog_num |
|format=template | |format=template | ||
|template=CargoDisplayNHFurniture | |template=CargoDisplayNHFurniture | ||
Line 27: | Line 27: | ||
table=nh_interior | table=nh_interior | ||
|group by=nh_interior.en_name | |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='Fitness' OR theme2='Fitness' | |where=theme1='Fitness' OR theme2='Fitness' | ||
− | |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 39: | Line 39: | ||
<br> | <br> | ||
+ | |||
+ | == Former furniture/interior items == | ||
+ | The following furniture/interior items were formerly part of the Fitness HHA theme. | ||
+ | {{TableTop NH Furniture Themes|name=Furniture/interior items formerly classified as Fitness|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 = "Fitness" OR nh_furniture.former_theme2 = "Fitness"); | ||
+ | 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 = "Fitness" OR nh_interior.former_theme2 = "Fitness"); | ||
+ | limit=600 | ||
+ | |format=template | ||
+ | |template=CargoDisplayNHHHAThemes | ||
+ | |named args=yes | ||
+ | }} | ||
+ | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
+ | {{clear}} | ||
{{Furniture}} | {{Furniture}} | ||
[[Category:Lists of furniture]] | [[Category:Lists of furniture]] |
Revision as of 01:01, October 3, 2022
This is a list of fitness-themed furniture in Animal Crossing: New Horizons.
Furniture
Furniture in Animal Crossing: New Horizons
# | Item | Image | Buy price | Sell price | Available from | HHA theme(s) | Interact | Customizable | Size |
---|---|---|---|---|---|---|---|---|---|
102 | Barbell | Not for sale | 7,500 Bells | Crafting |
Fitness | - | Yes | ||
310 | Climbing wall | 4,300 Bells | 1,075 Bells | Nook's Cranny (upgraded) |
Fitness | - | No | ||
512 | Exercise ball | 1,100 Bells | 275 Bells | Nook's Cranny |
Fitness / Office | - | No | ||
513 | Exercise bike | 4,800 Bells | 1,200 Bells | Nook's Cranny (upgraded) |
Fitness | - | No | ||
637 | Full-length mirror | 3,600 Bells | 900 Bells | Nook's Cranny Paradise Planning office |
Apparel shop / Fitness | Dresser | No | ||
1,122 | Nook Inc. yoga mat | 1,000 Nook Miles | 5,000 Bells | Tom Nook Nook Stop |
Fitness / Sports | - | No | ||
1,339 | Pull-up-bar stand | 4,800 Bells | 1,200 Bells | Nook's Cranny (upgraded) |
Fitness | - | No | ||
1,347 | Punching bag | 3,800 Bells | 950 Bells | Nook's Cranny |
Fitness / Sports | - | No | ||
1,523 | Shower booth | 110,000 Bells | 27,500 Bells | Nook's Cranny (upgraded) |
Bathroom / Fitness | - | No | ||
1,598 | Speed bag | 3,500 Bells | 875 Bells | Nook's Cranny |
Fitness / Sports | - | No | ||
1,792 | Treadmill | 64,000 Bells | 16,000 Bells | Nook's Cranny (upgraded) |
Fitness | - | No | ||
1,902 | Weight bench | 5,400 Bells | 1,350 Bells | Nook's Cranny (upgraded) |
Fitness | Bed | No | ||
1,971 | Yoga mat | 440 Bells | 110 Bells | Nook's Cranny Paradise Planning office |
Fitness | - | Yes | ||
752 | Handy water cooler | 1,400 Bells | 350 Bells | Timmy Nook's Cranny |
Fitness / Sports | - | No | ||
882 | Kettlebell | Not for sale | 3,750 Bells | Crafting |
Fitness | - | Yes | ||
1,334 | Protein shaker bottle | 1,400 Bells | 350 Bells | Nook's Cranny |
Kitchen / Fitness | - | No | ||
1,406 | Ring-Con | 4,950 Bells | 1,237 Bells | Nook Shopping Nintendo |
Fitness / Living room | - | 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
Interior in Animal Crossing: New Horizons
# | Item | Image | Buy price | Sell price | Available from | Colors | HHA theme(s) | Size |
---|---|---|---|---|---|---|---|---|
530 | Rock-climbing wall | 3,000 Bells | 750 Bells | Saharah |
White
Colorful
|
Fitness / Sports | - | |
227 | Football rug | 2,000 Bells | 500 Bells | Nook Shopping |
Brown
White
|
Fitness / Child's room |
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
The following furniture/interior items were formerly part of the Fitness HHA theme.
Furniture/interior items formerly classified as Fitness in Animal Crossing: New Horizons
Item | Image | Former HHA theme(s) | Current HHA theme(s) |
---|---|---|---|
Ball | Fitness | Sports / School | |
Basketball hoop | Fitness | Sports / School | |
Blue corner | Fitness | Sports | |
Football | Fitness | Sports / School | |
Golf bag | Fitness | Sports / Expensive | |
Judge's bell | Fitness | Sports | |
Mountain bike | Fitness / Garden | Sports / Outdoors | |
Neutral corner | Fitness | Sports | |
Pool | Fitness / Expensive | Garden / Resort | |
Red corner | Fitness | Sports | |
Soccer goal | Fitness | School / Sports | |
Throwback hat table | Fitness | Child's room / Sports | |
Throwback mitt chair | Fitness | Child's room / Sports | |
Blue rubber flooring | Fitness | Facility / School | |
Boxing-ring mat | Fitness | Sports | |
Dojo wall | Fitness | Sports / Harmonious | |
Green rubber flooring | Fitness | Facility / School | |
Racetrack flooring | Fitness | Sports / School | |
Ringside seating | Fitness | Sports | |
Stadium wall | Fitness | Sports | |
Sumo ring | Fitness | Sports / Harmonious |
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.