Difference between revisions of "DIY recipes/Jock"
From Nookipedia, the Animal Crossing wiki
m (Text replacement - "|join on=nh_interior.category_sort,nh_interior.en_name" to "|join on=nh_interior.en_name") |
m (Text replacement - "|group by=nh_interior.category_sort,nh_interior.en_name" to "|group by=nh_interior.en_name") |
||
| Line 38: | Line 38: | ||
table=nh_recipe,nh_interior | table=nh_recipe,nh_interior | ||
|join on=nh_interior.en_name = nh_recipe.en_name | |join on=nh_interior.en_name = nh_recipe.en_name | ||
| − | |group by= | + | |group by=nh_interior.en_name |
|fields=nh_recipe.en_name=name,nh_recipe.image,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6,nh_interior.grid_size=gridsize,nh_interior.sell | |fields=nh_recipe.en_name=name,nh_recipe.image,nh_recipe.diy_availability1=availability1,nh_recipe.diy_availability2=availability2,nh_recipe.material1_num=material1n,nh_recipe.material1,nh_recipe.material2_num=material2n,nh_recipe.material2,nh_recipe.material3_num=material3n,nh_recipe.material3,nh_recipe.material4_num=material4n,nh_recipe.material4,nh_recipe.material5_num=material5n,nh_recipe.material5,nh_recipe.material6_num=material6n,nh_recipe.material6,nh_interior.grid_size=gridsize,nh_interior.sell | ||
|where=nh_recipe.diy_availability1 LIKE '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%' | |where=nh_recipe.diy_availability1 LIKE '%Jock%' OR nh_recipe.diy_availability2 LIKE '%Jock%' | ||
Revision as of 10:24, September 13, 2020
This is the list of the recipes in Animal Crossing: New Horizons that may be obtained from Jock villagers while they are crafting in their homes, or via Message Bottle.
Furniture
Recipes in Animal Crossing: New Horizons
| # | Item | Image | Type | Buy price | Available from | Materials |
|---|---|---|---|---|---|---|
| - | [[|Simple DIY workbench]] | 
|
Not for sale |  Jock villager Nintendo |
 5× Hardwood 1× Iron nugget | |
| - | [[|Wild log bench]] | 
|
Not for sale | Jock villager |
8× Hardwood | |
| - | [[|Plain wooden shop sign]] | 
|
Not for sale | Jock villager |
 6× Wood | |
| - | [[|Mountain standee]] | 
|
Not for sale | Jock villager |
4× Wood 5× Softwood | |
| - | [[|Tree standee]] | 
|
Not for sale | Jock villager |
5× Wood 8× Softwood | |
| - | [[|Trophy case]] | 
|
Not for sale | Jock villager |
24× Hardwood 3× Gold nugget 6× Iron nugget | |
| - | [[|Doghouse]] | 
|
Not for sale | Jock villager |
10× Wood 7× Hardwood | |
| - | [[|Wooden field sign]] | 
|
Not for sale | Jock villager |
6× Softwood 2× Hardwood | |
| - | [[|Firewood]] | 
|
Not for sale | Jock villager |
8× Wood | |
| - | [[|Fossil doorplate]] | 
|
Not for sale | Jock villager |
 1× Fossil 2× Stone | |
| - | [[|Kettlebell]] | 
|
Not for sale | Jock villager |
5× Iron nugget | |
| - | [[|Barbell]] | 
|
Not for sale | Jock villager |
10× Iron nugget | |
| - | [[|Iron frame]] | 
|
Not for sale | Jock villager |
20× Iron nugget | |
| - | [[|Golden samurai suit]] | 
|
Not for sale | Jock villager |
2× Gold nugget 1× Samurai suit | |
| - | [[|Gold-nugget mining car]] | 
|
Not for sale | Jock villager |
3× Gold nugget 1× Mining car | |
| - | [[|Jungle wall]] | 
|
Not for sale | Jock villager |
 15× Clump of weeds 3× Wood 3× Hardwood 3× Softwood | |
| - | [[|Pear wardrobe]] | 
|
Not for sale |  Tom Nook Jock villager |
 10× Pear 5× Wood | |
| - | [[|Pear bed]] | 
|
Not for sale | Tom Nook Jock villager |
10× Pear 6× Softwood | |
| - | [[|Beekeeper's hive]] | 
|
Not for sale | Jock villager |
 3× Wasp nest 5× Wood | |
| - | [[|Oil-barrel bathtub]] | 
|
Not for sale | Jock villager |
 1× Oil barrel 1× Campfire 2× Stone | |
| - | [[|Skateboard wall rack]] | 
|
Not for sale | Jock villager |
 3× Skateboard 2× Hardwood | |
| - | [[|Stacked bottle crates]] | 
|
Not for sale | Jock villager |
 2× Bottle crate 1× Wood | |
| - | [[|Bamboo stopblock]] | 
|
Not for sale | Jock villager |
 3× Bamboo piece | |
| - | [[|Bamboo drum]] | 
|
Not for sale | Jock villager |
3× Bamboo piece 2× Softwood | |
| - | [[|Bamboo wall decoration]] | 
|
Not for sale | Jock villager |
1× Bamboo piece | |
| - | [[|Tulip surprise box]] | 
|
Not for sale | Jock villager |
 5× Red tulips 3× Softwood |
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.
Clothing
Recipes in Animal Crossing: New Horizons
| # | Item | Image | Type | Buy price | Available from | Materials |
|---|---|---|---|---|---|---|
| - | [[|Firewood]] |
|
Not for sale | Jock villager |
8× Wood | |
| - | [[|Log pack]] | 
|
Not for sale | Jock villager |
3× Wood 5× Hardwood | |
| - | [[|Leaf]] | 
|
Not for sale | Jock villager |
5× Clump of weeds | |
| - | [[|Pear umbrella]] | 
|
Not for sale | Jock villager |
7× Pear | |
| - | [[|Pear hat]] | 
|
Not for sale | Jock villager |
5× Pear | |
| - | [[|Pear dress]] | 
|
Not for sale | Jock villager |
8× Pear |
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
Recipes in Animal Crossing: New Horizons
| # | Item | Image | Type | Buy price | Available from | Materials |
|---|---|---|---|---|---|---|
| - | [[|Firewood]] |
|
Not for sale | Jock villager |
8× Wood | |
| - | [[|Stacked-wood wall]] | 
|
Not for sale | Jock villager |
15× Hardwood | |
| - | [[|Jungle wall]] |
|
Not for sale | Jock villager |
15× Clump of weeds 3× Wood 3× Hardwood 3× Softwood | |
| - | [[|Jungle flooring]] | 
|
Not for sale | Jock villager |
10× Clump of weeds 10× Clay | |
| - | [[|Pear wall]] | 
|
Not for sale | Jock villager |
20× Pear | |
| - | [[|Pear rug]] | 
|
Not for sale | Jock villager |
6× Pear | |
| - | [[|Honeycomb wall]] | 
|
Not for sale | Jock villager |
6× Wasp nest | |
| - | [[|Honeycomb flooring]] | 
|
Not for sale | Jock villager |
5× Wasp nest | |
| - | [[|Sandy-beach flooring]] | 
|
Not for sale | Jock villager |
 1× Sea snail 1× Venus comb 1× Sand dollar 1× Coral 1× Giant clam 1× Cowrie |
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.
