Difference between revisions of "Furniture/New Horizons/Den"

From Nookipedia, the Animal Crossing wiki
(adding description on the top to supplement the removal of the NH theme pages)
(Converting to query module)
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{DISPLAYTITLE:List of den-themed furniture in {{NH|short|nolink}}}}
 
This is a list of '''den-themed furniture''' in {{NH}}.
 
This is a list of '''den-themed furniture''' in {{NH}}.
 
__TOC__
 
__TOC__
Line 5: Line 6:
 
{{TableTop NH Furniture}}
 
{{TableTop NH Furniture}}
  
−
{{#cargo_query:
+
{{#invoke:NHFurnitureCargoQuery|main|limit=600|order by=nh_furniture.category_sort,nh_furniture.catalog_num|group by=nh_furniture.en_name|where=theme1{{=}}'Den' OR theme2{{=}}'Den'}}
−
table=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_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='Den' OR theme2='Den'
 
−
|order by=nh_furniture.category_sort,nh_furniture.en_name
 
−
|format=template
 
−
|template=CargoDisplayNHFurniture
 
−
|named args=yes
 
−
|limit=600
 
−
}}
 
  
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
 
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
Line 26: Line 16:
 
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='Den' OR theme2='Den'
 
|where=theme1='Den' OR theme2='Den'
−
|order by=nh_interior.category_sort,nh_interior.en_name
+
|order by=nh_interior.category_sort,nh_interior.catalog_num
 
|format=template
 
|format=template
 
|template=CargoDisplayNHInterior
 
|template=CargoDisplayNHInterior
Line 38: Line 28:
  
 
<br>
 
<br>
−
{{Furniture}}
+
 
 +
== Former furniture/interior items ==
 +
The following furniture/interior items were formerly part of the Den HHA theme.
 +
{{TableTop NH Furniture Themes|name=Furniture/interior items formerly classified as Den|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 = "Den" OR nh_furniture.former_theme2 = "Den");
 +
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 = "Den" OR nh_interior.former_theme2 = "Den");
 +
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:13, February 26, 2024

This is a list of den-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
420 Den chair den chair  8,700 Bells  2,175 Bells  Nook's Cranny (upgraded)
 Den / Expensive Seating No 1.0×1.0
421 Den desk den desk  10,000 Bells  2,500 Bells  Nook's Cranny (upgraded)
 Den / Expensive - No 2.0×1.0
1,469 Scattered papers scattered papers Not for sale  400 Bells  Crafting
 Den / Office - No 1.5×1.5
40 Antique map antique map  31,000 Bells  7,750 Bells  Nook's Cranny
 Paradise Planning office
 Den / Retro - No 1.0×1.0
99 Banker's lamp banker's lamp  1,600 Bells  400 Bells  Nook's Cranny
 Paradise Planning office
 Facility / Den Lighting No 1.0×1.0
159 Book book  290 Bells  72 Bells  Nook's Cranny
 Den / School - No 1.0×1.0
160 Book stands book stands  1,100 Bells  275 Bells  Nook's Cranny
 Den / Child's room - No 1.0×1.0
253 Cartoonist's set cartoonist's set  1,200 Bells  300 Bells  Nook's Cranny
 Child's room / Den - No 1.0×1.0
345 Cool globe cool globe  2,300 Bells  575 Bells  Nook Shopping
 Den / Expensive - No 1.0×1.0
506 Essay set essay set  650 Bells  162 Bells  Nook's Cranny
 Den / Retro - No 1.0×1.0
722 Golden wristwatch golden wristwatch Not for sale  27,000 Bells  Crafting
 Expensive / Den - No 1.0×1.0
1,028 Mixer mixer  1,400 Bells  350 Bells  Nook's Cranny
 Kitchen / Den - No 1.0×1.0
1,407 Ring light ring light  1,600 Bells  400 Bells  Nook's Cranny
 Paradise Planning office
 Facility / Den Lighting No 1.0×1.0
1,627 Stack of books stack of books Not for sale  725 Bells  Crafting
 Den / Living room - No 1.0×1.0
1,669 Strapped books strapped books  350 Bells  87 Bells  Nook's Cranny
 Paradise Planning office
 School / Den - No 1.0×1.0
1,706 Table lamp table lamp  1,100 Bells  275 Bells  Nook's Cranny
 Den / Child's room Lighting No 1.0×1.0
1,709 Tablet device tablet device  12,000 Bells  3,000 Bells  Nook's Cranny
 Paradise Planning office
 Office / Den - No 1.0×1.0
1,734 Thank-you Dad mug thank-you Dad mug  600 Bells  150 Bells  Nook Shopping
 Living room / Den - No 1.0×1.0
1,823 Typewriter typewriter  2,000 Bells  500 Bells  Nook's Cranny
 Den / Retro - No 1.0×1.0
1,826 Unfolded reference sheet unfolded reference sheet  200 Bells  50 Bells  Nook's Cranny
 Paradise Planning office
 Den / Office - No 1.0×1.0
1,966 Wristwatch wristwatch  68,000 Bells  17,000 Bells  Nook's Cranny
 Paradise Planning office
 Den / Expensive - No 1.0×1.0
63 Art plaque art plaque Not for sale  2,500 Bells  Blathers
 Expensive / Den - No 1.0×1.0
186 Bug plaque bug plaque Not for sale  2,500 Bells  Blathers
 Expensive / Den - No 1.0×1.0
523 Fancy frame fancy frame  38,000 Bells  9,500 Bells  Nook's Cranny
 Paradise Planning office
 Den / Expensive - No 1.0×1.0
562 Fish plaque fish plaque Not for sale  2,500 Bells  Blathers
 Expensive / Den - No 1.0×1.0
593 Formal paper formal paper  620 Bells  155 Bells  Nook's Cranny
 School / Den - No 1.0×1.0
598 Fossil plaque fossil plaque Not for sale  2,500 Bells  Blathers
 Expensive / Den - No 1.0×1.0
605 Framed poster framed poster  1,400 Bells  350 Bells  Nook's Cranny
 Paradise Planning office
 Living room / Den - No 1.0×1.0
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
152 Classic-library wall classic-library wall Not for sale  1,450 Bells  Crafting
Black
Black
 Den / Facility -
351 Manga-library wall manga-library wall Not for sale  1,050 Bells  Crafting
White
White
 Facility / Den -
538 Rosewood flooring rosewood flooring  2,420 Bells  605 Bells  Nook's Cranny
Gray
Gray
 Den / Living room -
569 Simple blue flooring simple blue flooring  1,500 Bells  375 Bells  Nook's Cranny
Blue
Blue
 Den / Living room -
581 Simple purple flooring simple purple flooring  1,500 Bells  375 Bells  Nook's Cranny
Purple
Purple
 Den / Living room -
582 Simple red flooring simple red flooring  1,500 Bells  375 Bells  Nook's Cranny
Red
Red
 Den / Living 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[edit]

The following furniture/interior items were formerly part of the Den HHA theme.

Furniture/interior items formerly classified as Den in Animal Crossing: New Horizons

Item Image Former HHA theme(s) Current HHA theme(s)
Autograph cards autograph cards School / Den Shop / Restaurant
Document stack document stack Den Office / Lab
Homework set homework set Den School / Child's room
Typewriter typewriter Office / Den Den / Retro
World map world map Den Child's room / School
Monochromatic tile flooring monochromatic tile flooring Den / Living room Facility / Office
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.
Leaf NH Icon cropped.png
Furniture
Types of furniture
Function Beds • Chairs • Clocks • Lights • Stereos • Storage units • Tables • Televisions • Flooring • Rugs • Wallpaper • Wardrobes
Collectibles Critter models • Diaries • Gyroids • Photos • Posters • NES games • Seasonal items • Art • Fossils • Bugs • Fish • Sea creatures • Shells
Concepts DIY (Customization Kit) • Fêng shui • Happy Home Academy • Lucky items • Groups
Collections
Series Alpine • Antique • Astro • Balloon • Bamboo • Blue • Bunny Day • Cabana • Cabin • Card • Cardboard • Cherry Blossoms • Cinnamoroll • Classic • Cool • Cute • Diner • Dreamy • Egg • Elegant • Exotic • Festivale • Festive • Flowers • Frozen • Fruits • Golden • Gorgeous • Gracie • Green • Harvest • Hello Kitty • Ice • Imperial • Iron • Ironwood • Kerokerokeroppi • Kiddie • Kiki & Lala • Log • Lovely • Nordic • Mario • Mermaid • Modern • Modern Wood • Moroccan • Motherly • Mush • My Melody • Patchwork • Pirate • Plaza • Polka-Dot • Pompompurin • Princess • Ranch • Rattan • Regal • Robo • Rococo • Shell • Simple • Sleek • Sloppy • Snowman • Spooky • Stars • Stripe • Sweets • Throwback • Tree's Bounty or Leaves • Turkey Day • Vintage • Wedding • Wooden • Wooden Block
Sets Apple • Artsy • Bear • Birthday • Bonsai • Bug Head • Cactus • Café • Castle • Chalkboard • Cherry • Chess • Citrus • Den • Dharma • Dr.'s Office • Drum • Figure • Fish • Flower • Frog • Gaming • Garden • Golf • Guitar • House Plant • Imperial Dining • Insect • Iron Garden • Kitchen • Lava Lamp • Lecture Hall • Lucky Cat • Lucky • Metal and Wood • Museum • Natural • Nintendo • Office • Office (modern) • Oil Drum • Orange • Painted Egg • Panda • Peach • Pear • Pet • Piggy Bank • Pine • Pine Tree • Red • Robot • Ruined • School • Sports Ring • Standee • Stone • String Section • Study • Terracotta Warriors • Totem Pole • Vase • Vending • Watermelon • Zen • Zen Garden
Themes Boxing • Chess • Construction • Creepy • Garden • Japanese • Mad Scientist • Mario • Mossy Garden • Nursery • Pirate Ship • Rockgarden • School • Sci-Fi • Soccer • Spa • Space • Western
Categories Art • Dolls • Instruments • Models • Plants
Related collections Astrology • Fueki • Kokuyo Camlin • Monster Hunter • 7-Eleven • Splatoon • The Legend of Zelda
Navigational lists
By game First generation (In Doubutsu no Mori • In Doubutsu no Mori+ • In Animal Crossing • In Doubutsu no Mori e+ • In Dòngwù Sēnlín) • In Wild World • In City Folk • In New Leaf • In Pocket Camp • In New Horizons (Housewares • Miscellaneous • Wall-mounted • Ceiling decor)
Colors
Pocket Camp collection sets • Category • Project
Retrieved from "https://nookipedia.com/w/index.php?title=Furniture/New_Horizons/Den&oldid=1127323"