Difference between revisions of "User:PanchamBro/Sandbox/Coconut"
From Nookipedia, the Animal Crossing wiki
< User:PanchamBro | Sandbox
PanchamBro (talk | contribs) |
PanchamBro (talk | contribs) m |
||
Line 5: | Line 5: | ||
| data-sort-value="{{{sell|}}}" | {{#if:{{{sell|}}}|{{Currency|Bells|{{{sell|}}}}}|Cannot be sold}} | | data-sort-value="{{{sell|}}}" | {{#if:{{{sell|}}}|{{Currency|Bells|{{{sell|}}}}}|Cannot be sold}} | ||
| {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{recipe-count|}}}"%'|no html}} | | {{#cargo_query:table=nh_recipe|fields=COUNT(*)|where=nh_recipe.materials LIKE '%"{{{recipe-count|}}}"%'|no html}} | ||
− | | {{#cargo_query:table=nh_recipe|fields=SUM | + | | {{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material1_num OR nh_recipe.material2_num OR nh_recipe.material3_num OR nh_recipe.material4_num OR nh_recipe.material5_num OR nh_recipe.material6_num))|where=nh_recipe.material1 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material2 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material3 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material4 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material5 LIKE '%"{{{recipe-total|}}}"%' OR nh_recipe.material6 LIKE '%"{{{recipe-total|}}}"%'|no html}} |
|-<</includeonly><noinclude></noinclude> | |-<</includeonly><noinclude></noinclude> |