Editing DIY recipes/Big sister
From Nookipedia, the Animal Crossing wiki
Warning: You are not logged in.
Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
Warning: You are not logged in.
Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit. Except in cases of vandalism, please add a reason for undoing the edit in the edit summary.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
− | + | This is the list of the recipes in {{NH}} that may be obtained from [[Sisterly]] villagers while they are crafting in their homes. | |
− | This is | ||
+ | == Furniture == | ||
{{TableTop NH DIY}} | {{TableTop NH DIY}} | ||
{{#cargo_query: | {{#cargo_query: | ||
− | table=nh_recipe | + | table=nh_recipe,nh_furniture |
− | | | + | |join on=nh_furniture.en_name = nh_recipe.en_name |
− | |where=nh_recipe.diy_availability1 LIKE '% | + | |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_furniture.grid_size=gridsize,nh_furniture.sell |
− | |order by=nh_recipe. | + | |group by=nh_furniture.en_name |
+ | |where=nh_recipe.diy_availability1 LIKE '%Sisterly%' OR nh_recipe.diy_availability2 LIKE '%Sisterly%' | ||
+ | |order by=nh_recipe.serial_id | ||
|format=template | |format=template | ||
− | |template= | + | |template=BarLinkDIY |
|named args=yes | |named args=yes | ||
|limit=500 | |limit=500 | ||
Line 15: | Line 17: | ||
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
− | + | == Clothing == | |
+ | {{TableTop NH DIY}} | ||
+ | {{#cargo_query: | ||
+ | table=nh_recipe,nh_clothing | ||
+ | |join on=nh_clothing.en_name = nh_recipe.en_name | ||
+ | |group by=nh_clothing.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_clothing.sell | ||
+ | |where=nh_recipe.diy_availability1 LIKE '%Sisterly%' OR nh_recipe.diy_availability2 LIKE '%Sisterly%' | ||
+ | |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_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 '%Sisterly%' OR nh_recipe.diy_availability2 LIKE '%Sisterly%' | ||
+ | |order by=nh_recipe.serial_id | ||
+ | |format=template | ||
+ | |template=BarLinkDIY | ||
+ | |named args=yes | ||
+ | |limit=500 | ||
+ | }} | ||
+ | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} |