Difference between revisions of "Clothing/New Horizons/Colorful"
From Nookipedia, the Animal Crossing wiki
< Clothing | New Horizons
m (Vmario97 moved page List of Colorful Items in Animal Crossing: New Horizons to Clothing/New Horizons/Colorful: Text replacement - "List of (.*) Items in Animal Crossing: New Horizons" to "Clothing/New Horizons/$1") |
|||
| Line 1: | Line 1: | ||
| − | {{ | + | {{TableTop NH Clothing|name=Colorful clothing}} |
{{#cargo_query: | {{#cargo_query: | ||
| − | table=nh_clothing_variation | + | table=nh_clothing,nh_clothing_variation |
|join on=nh_clothing_variation.en_name = nh_clothing.en_name | |join on=nh_clothing_variation.en_name = nh_clothing.en_name | ||
| − | |fields= | + | |fields=nh_clothing.en_name=name,nh_clothing_variation.variation,nh_clothing_variation.image,nh_clothing.buy1_price=buy1-price,nh_clothing.buy1_wikitext=buy1,nh_clothing.sell,nh_clothing.availability1,nh_clothing.availability2,nh_clothing.style1,nh_clothing.style2,nh_clothing.label1,nh_clothing.label2,nh_clothing.label3,nh_clothing.label4,nh_clothing.label5 |
|where=color1='Colorful' OR color2='Colorful' | |where=color1='Colorful' OR color2='Colorful' | ||
| − | |order by= | + | |order by=nh_clothing.category_sort,nh_clothing.en_name |
|format=template | |format=template | ||
|template=BarLinkClothing | |template=BarLinkClothing | ||
|named args=yes | |named args=yes | ||
| − | |limit= | + | |limit=5000 |
}} | }} | ||
{{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | {{TableFooter|note={{Community:ACNH Spreadsheet/Attribution}}}} | ||
| + | |||
| + | ==Favorites== | ||
| + | This is a list of villagers whose favorite color is Colorful: | ||
| + | {{Columns-list| | ||
| + | {{#cargo_query: | ||
| + | table=nh_villager | ||
| + | |group by=name | ||
| + | |fields=CONCAT( '[[File:', name, ' NH Villager Icon.png|x32px]][[', _pageName, '|', name, ']]' ) | ||
| + | |where=fav_color1='Colorful' OR fav_color2='Colorful' | ||
| + | |order by=name | ||
| + | |format=ul | ||
| + | |limit=398 | ||
| + | }} | ||
| + | }} | ||
Revision as of 02:41, August 27, 2020
Colorful clothing in Animal Crossing: New Horizons
Template:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothingTemplate:BarLinkClothing
| # | Item | Image | Buy price | Sell price | Available from | Style | Label theme(s) |
|---|
Includes data sourced from the Data Spreadsheet for Animal Crossing New Horizons, compiled and edited by 6480, noizhub, Ricky, chaiinchomp, saberslime, robotic_scarab, mollumisc, sunmarsh, kyrokey, obstinateRixatrix, jackiwi, Zalex, SuperHamster, kait, hyuum, Azarro, Czarcasm, cinnamon_swirlix, astronomyfortwo, Welcius, glowtopia, BriKun, Alyrei, dodocodes.com, StevieCoops, sneeze, Shiny190, TwistedPeach, LavaToaster, capstone, vmario, rocklamp, Alexis, Aeon, and PanchamBro.
Favorites
This is a list of villagers whose favorite color is Colorful:
