Difference between revisions of "User:SuperHamster/Sandbox/Green"
From Nookipedia, the Animal Crossing wiki
|
|
Line 1: |
Line 1: |
− | {{TableTop NH DIY}}
| + | |
− | {{#cargo_query:
| |
− | table=nh_recipes,nh_furniture,nh_furniture_variations
| |
− | |join on=nh_recipes.en_name = nh_furniture.en_name, nh_furniture.en_name = nh_furniture_variations.en_name
| |
− | |fields=nh_recipes.en_name=name,nh_furniture_variations.image,nh_recipes.diy_availability1=availability1,nh_recipes.diy_availability2=availability2,nh_recipes.material1_num=material1n,nh_recipes.material1,nh_recipes.material2_num=material2n,nh_recipes.material2,nh_recipes.material3_num=material3n,nh_recipes.material3,nh_recipes.material4_num=material4n,nh_recipes.material4,nh_recipes.material5_num=material5n,nh_recipes.material5,nh_recipes.material6_num=material6n,nh_recipes.material6,nh_furniture.grid_size=gridsize,nh_furniture.sell
| |
− | |group by=nh_furniture.en_name
| |
− | |where=nh_recipes.materials LIKE '%Weeds%'
| |
− | |order by=nh_recipes.serial_id
| |
− | |format=template
| |
− | |template=BarLinkDIY
| |
− | |named args=yes
| |
− | |limit=500
| |
− | }}
| |
− | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}}
| |
Revision as of 21:04, July 27, 2020