|
|
| (11 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| − | This is the list of recipes in {{NH}} that may only be obtained throughout specific seasons or [[events]].
| + | #REDIRECT [[DIY_recipes#Lists_of_recipes]] |
| − | | |
| − | == Furniture ==
| |
| − | {{TableTop NH DIY}}
| |
| − | {{#cargo_query:
| |
| − | table=nh_recipe,nh_furniture,nh_furniture_variation
| |
| − | |join on=nh_furniture.en_name = nh_furniture_variation.en_name, nh_furniture.en_name = nh_recipe.en_name
| |
| − | |fields=nh_recipe.en_name=name,nh_furniture_variation.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_furniture.grid_size=gridsize,nh_furniture.sell
| |
| − | |group by=nh_furniture.en_name
| |
| − | |where=nh_recipe.materials LIKE '%Young Spring Bamboo%' OR nh_recipe.materials LIKE '%Cherry-Blossom Petal%' OR nh_recipe.materials LIKE '%Egg%' OR nh_recipe.materials LIKE '%Summer Shell%' OR nh_recipe.materials LIKE '%Acorn%' OR nh_recipe.materials LIKE '%Pine Cone%' OR nh_recipe.materials LIKE '%Mushroom%' OR nh_recipe.materials LIKE '%Maple Leaf%'
| |
| − | |order by=nh_recipe.serial_id
| |
| − | |format=template
| |
| − | |template=BarLinkDIY
| |
| − | |named args=yes
| |
| − | |limit=500
| |
| − | }}
| |
| − | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
| − | | |
| − | == Clothing ==
| |
| − | {{TableTop NH DIY}}
| |
| − | {{#cargo_query:
| |
| − | table=nh_recipe,nh_clothing,nh_clothing_variation
| |
| − | |join on=nh_clothing.en_name = nh_clothing_variation.en_name, nh_clothing.en_name = nh_recipe.en_name
| |
| − | |group by=nh_clothing.en_name
| |
| − | |fields=nh_recipe.en_name=name,nh_clothing_variation.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_clothing.sell
| |
| − | |where=nh_recipe.materials LIKE '%Young Spring Bamboo%' OR nh_recipe.materials LIKE '%Cherry-Blossom Petal%' OR nh_recipe.materials LIKE '%Egg%' OR nh_recipe.materials LIKE '%Summer Shell%' OR nh_recipe.materials LIKE '%Acorn%' OR nh_recipe.materials LIKE '%Pine Cone%' OR nh_recipe.materials LIKE '%Mushroom%' OR nh_recipe.materials LIKE '%Maple Leaf%'
| |
| − | |order by=nh_recipe.serial_id
| |
| − | |format=template
| |
| − | |template=BarLinkDIY
| |
| − | |named args=yes
| |
| − | |limit=500
| |
| − | }}
| |
| − | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
| − | | |
| − | == Interior ==
| |
| − | {{TableTop NH DIY}}
| |
| − | {{#cargo_query:
| |
| − | table=nh_recipe,nh_interior
| |
| − | |join on=nh_interior.en_name = nh_recipe.en_name
| |
| − | |group by=nh_interior.en_name
| |
| − | |fields=nh_recipe.en_name=name,nh_interior.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.materials LIKE '%Young Spring Bamboo%' OR nh_recipe.materials LIKE '%Cherry-Blossom Petal%' OR nh_recipe.materials LIKE '%Egg%' OR nh_recipe.materials LIKE '%Summer Shell%' OR nh_recipe.materials LIKE '%Acorn%' OR nh_recipe.materials LIKE '%Pine Cone%' OR nh_recipe.materials LIKE '%Mushroom%' OR nh_recipe.materials LIKE '%Maple Leaf%'
| |
| − | |order by=nh_recipe.serial_id
| |
| − | |format=template
| |
| − | |template=BarLinkDIY
| |
| − | |named args=yes
| |
| − | |limit=500
| |
| − | }}
| |
| − | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
| − | | |
| − | == Tools ==
| |
| − | {{TableTop NH DIY}}
| |
| − | {{#cargo_query:
| |
| − | table=nh_recipe,nh_tool,nh_tool_variation
| |
| − | |join on=nh_tool.en_name = nh_tool_variation.en_name, nh_tool.en_name = nh_recipe.en_name
| |
| − | |group by=nh_tool.en_name
| |
| − | |fields=nh_recipe.en_name=name,nh_tool_variation.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_tool.sell
| |
| − | |where=nh_recipe.materials LIKE '%Young Spring Bamboo%' OR nh_recipe.materials LIKE '%Cherry-Blossom Petal%' OR nh_recipe.materials LIKE '%Egg%' OR nh_recipe.materials LIKE '%Summer Shell%' OR nh_recipe.materials LIKE '%Acorn%' OR nh_recipe.materials LIKE '%Pine Cone%' OR nh_recipe.materials LIKE '%Mushroom%' OR nh_recipe.materials LIKE '%Maple Leaf%'
| |
| − | |order by=nh_recipe.serial_id
| |
| − | |format=template
| |
| − | |template=BarLinkDIY
| |
| − | |named args=yes
| |
| − | |limit=500
| |
| − | }}
| |
| − | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
