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: | ||
− | {{DISPLAYTITLE:List of recipes obtained from big sister | + | {{DISPLAYTITLE:List of recipes obtained from big sister villager in {{NH|short|nolink}}}} |
This is a '''list of [[DIY]] recipes''' in {{NH}} that can be obtained from [[big sister]] villagers, either while they are crafting in their homes or from a [[Message Bottle]]. | This is a '''list of [[DIY]] recipes''' in {{NH}} that can be obtained from [[big sister]] villagers, either while they are crafting in their homes or from a [[Message Bottle]]. | ||
Line 5: | Line 5: | ||
{{#cargo_query: | {{#cargo_query: | ||
table=nh_recipe | table=nh_recipe | ||
− | |fields=nh_recipe._pageName=pagename,nh_recipe.en_name=name,nh_recipe.num=num,nh_recipe.image,nh_recipe.type,nh_recipe.diy_availability1=availability1 | + | |fields=nh_recipe._pageName=pagename,nh_recipe.en_name=name,nh_recipe.num=num,nh_recipe.image,nh_recipe.type,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 |
+ | |order by=nh_recipe.type,nh_recipe.num,nh_recipe.en_name | ||
|where=nh_recipe.diy_availability1 LIKE '%Big sister%' OR nh_recipe.diy_availability2 LIKE '%Big sister%' | |where=nh_recipe.diy_availability1 LIKE '%Big sister%' OR nh_recipe.diy_availability2 LIKE '%Big sister%' | ||
|order by=nh_recipe.num | |order by=nh_recipe.num |