Difference between revisions of "User:PanchamBro/Sandbox/Coconut"
From Nookipedia, the Animal Crossing wiki
< User:PanchamBro | Sandbox
PanchamBro (talk | contribs) |
PanchamBro (talk | contribs) |
||
| 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(nh_recipe. | + | | {{#cargo_query:table=nh_recipe|fields=SUM(nh_recipe.material1 + nh_recipe.material2 + nh_recipe.material3 + nh_recipe.material4 + nh_recipe.material5 + nh_recipe.material6)|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> | ||
