Difference between revisions of "User:SuperHamster/Sandbox/Silver"

From Nookipedia, the Animal Crossing wiki
(Restore second table, rm cargo query)
(Re-add cargo query)
Line 116: Line 116:
 
|CF={{Ideal Furniture/|}}
 
|CF={{Ideal Furniture/|}}
 
|NL={{Ideal Gifts/|}}
 
|NL={{Ideal Gifts/|}}
|NH=
+
|NH={{#cargo_query:
 +
table=nh_clothing_variations,nh_clothing
 +
|join on=nh_clothing_variations.en_name = nh_clothing.en_name
 +
|fields=nh_clothing_variations.en_name=name,nh_clothing_variations.image=image,nh_clothing.buy1_wikitext=buy1,nh_clothing.availability1,nh_clothing.availability2
 +
|where=nh_clothing.vill_equip=1 AND nh_clothing.style='Simple' AND nh_clothing_variations.color1='' AND nh_clothing_variations.color2='' {{#if:|OR nh_clothing.vill_equip=1 AND nh_clothing.style='' AND nh_clothing_variations.color1='' AND nh_clothing_variations.color2=''|}} {{#if:|OR nh_clothing.vill_equip=1 AND nh_clothing.style='' AND nh_clothing_variations.color1='' AND nh_clothing_variations.color2='' {{#if:|OR nh_clothing.vill_equip=1 AND nh_clothing.style='' AND nh_clothing_variations.color1='' AND nh_clothing_variations.color2=''|}}|}}
 +
|order by=nh_clothing_variations.en_name
 +
|format=template
 +
|template=Ideal NH Gifts Navigate‎‎
 +
|named args=yes
 +
|limit=100
 +
}}
 
}}
 
}}
 
|}
 
|}

Revision as of 03:33, June 10, 2020