Editing DIY recipes/Fall
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 10: | Line 10: | ||
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,nh_recipe.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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 | |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.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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.materials LIKE '%Acorn%' AND nh_recipe.materials NOT LIKE '%Maple Leaf%' OR nh_recipe.materials LIKE '%Pine Cone%' AND nh_recipe.materials NOT LIKE '%Maple Leaf%' | |where=nh_recipe.materials LIKE '%Acorn%' AND nh_recipe.materials NOT LIKE '%Maple Leaf%' OR nh_recipe.materials LIKE '%Pine Cone%' AND nh_recipe.materials NOT LIKE '%Maple Leaf%' | ||
|order by=nh_recipe.num | |order by=nh_recipe.num | ||
Line 25: | Line 26: | ||
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,nh_recipe.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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 | |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.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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.materials LIKE '%Mushroom%' AND nh_recipe.diy_availability1_note LIKE '%Mushroom Season%' | |where=nh_recipe.materials LIKE '%Mushroom%' AND nh_recipe.diy_availability1_note LIKE '%Mushroom Season%' | ||
|order by=nh_recipe.num | |order by=nh_recipe.num | ||
Line 42: | Line 44: | ||
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,nh_recipe.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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 | |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.buy1_price=buy1-price,nh_recipe.buy1_wikitext=buy1,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.materials LIKE '%Maple Leaf%' | |where=nh_recipe.materials LIKE '%Maple Leaf%' | ||
|order by=nh_recipe.num | |order by=nh_recipe.num |