Difference between revisions of "Clothing/New Leaf/Ornate"
From Nookipedia, the Animal Crossing wiki
AlexBot2004 (talk | contribs) m |
PanchamBro (talk | contribs) (Adding other items with ornate style and list of villagers (broken until cargo table is properly refreshed)) |
||
Line 1: | Line 1: | ||
− | {{DISPLAYTITLE:List of ornate | + | {{DISPLAYTITLE:List of ornate items in {{NL|short|nolink}}}} |
− | The following is a '''list of | + | The following is a '''list of items''' in {{NL}} that have '''ornate''' as their style designation, followed by a list of villagers who either prefer or dislike this style. |
− | {{TableTop NL Clothing|name=Ornate | + | {{TableTop Multi|game=NL|name=Ornate items}} |
+ | {{#cargo_compound_query: | ||
+ | tables=nl_clothing; | ||
+ | group by=nl_clothing.en_name; | ||
+ | order by=nl_clothing.clothing_category_sort,nl_clothing.catalog_num; | ||
+ | fields=nl_clothing._pageName=page,nl_clothing.en_name=name,nl_clothing.image=image,CONCAT('Clothing')=type,nl_clothing.buy1_price=buy1-price,nl_clothing.buy1_wikitext=buy1,nl_clothing.sell,nl_clothing.availability1,nl_clothing.availability2,nl_clothing.availability3,nl_clothing.availability_rv=availability-rv; | ||
+ | where=style="Ornate"; | ||
+ | limit=96 | ||
+ | |tables=nl_furniture,nl_furniture_variation; | ||
+ | join on=nl_furniture_variation.en_name = nl_furniture.en_name; | ||
+ | group by=nl_furniture.en_name; | ||
+ | order by=nl_furniture.catalog_num; | ||
+ | fields=nl_furniture.en_name=name,nl_furniture_variation.image,CONCAT('Furniture')=type,nl_furniture.buy1_price=buy1-price,nl_furniture.buy1_wikitext=buy1,nl_furniture.sell,nl_furniture.availability1,nl_furniture.availability2,nl_furniture.availability3,nl_furniture.availability_rv=availability-rv; | ||
+ | where=style="Ornate"; | ||
+ | limit=96 | ||
+ | |tables=nl_interior; | ||
+ | group by=nl_interior.en_name; | ||
+ | order by=nl_interior.category_sort,nl_interior.catalog_num; | ||
+ | fields=nl_interior._pageName=page,nl_interior.en_name=name,nl_interior.image=image,CONCAT('Interior')=type,nl_interior.buy1_price=buy1-price,nl_interior.buy1_wikitext=buy1,nl_interior.sell,nl_interior.availability1,nl_interior.availability2,nl_interior.availability3,nl_interior.availability_rv=availability-rv; | ||
+ | where=style="Ornate"; | ||
+ | limit=6 | ||
+ | |format=template | ||
+ | |template=CargoDisplayNLMulti | ||
+ | |named args=yes | ||
+ | }} | ||
+ | {{TableFooter|note={{Community:ACNL Spreadsheet/Attribution}}}} | ||
+ | ==Favorites== | ||
+ | This is a list of villagers whose favorite style is ornate: | ||
+ | {{Columns-list| | ||
{{#cargo_query: | {{#cargo_query: | ||
− | table= | + | table=nl_villager |
− | |group by= | + | |group by=name |
− | |fields= | + | |fields=CONCAT( '[[File:', name, ' NL Villager Icon.png|32px|link=', _pageName, ']] [[', _pageName, '|', name, ']]' ) |
− | |where= | + | |where=favstyle="Ornate" |
− | |order by= | + | |order by=name_sort |
− | |format= | + | |format=ul |
− | | | + | |limit=399 |
− | + | }} | |
− | |||
}} | }} | ||
− | {{ | + | ==Least favorites== |
+ | This is a list of villagers whose least favorite style is ornate: | ||
+ | {{Columns-list| | ||
+ | {{#cargo_query: | ||
+ | table=nl_villager | ||
+ | |group by=name | ||
+ | |fields=CONCAT( '[[File:', name, ' NL Villager Icon.png|32px|link=', _pageName, ']] [[', _pageName, '|', name, ']]' ) | ||
+ | |where=leastfavstyle="Ornate" | ||
+ | |order by=name_sort | ||
+ | |format=ul | ||
+ | |limit=399 | ||
+ | }} | ||
+ | }} | ||
==Notes== | ==Notes== | ||
{{Note list}} | {{Note list}} | ||
− | + | [[Category:Items]] | |
+ | [[Category:Lists of furniture]] | ||
[[Category:Lists of clothing]] | [[Category:Lists of clothing]] |
Revision as of 01:16, December 27, 2022
The following is a list of items in Animal Crossing: New Leaf that have ornate as their style designation, followed by a list of villagers who either prefer or dislike this style.
Ornate items in Animal Crossing: New Leaf
Includes data sourced from the Data Spreadsheet for Animal Crossing: New Leaf, compiled by TimeSword3D, AlexBot2004, AlgebraManiacABC, Chubby Bub, Cuyler, HylianAngel, Kalina70, PanchamBro, SuperHamster, and vmario.
Favorites
This is a list of villagers whose favorite style is ornate:
Least favorites
This is a list of villagers whose least favorite style is ornate:
- Alice
- Angus
- Antonio
- Aurora
- Avery
- Benjamin
- Bill
- Chadder
- Charlise
- Chief
- Coco
- Curly
- Del
- Dobie
- Ellie
- Epona
- Erik
- Eunice
- Filbert
- Graham
- Grizzly
- Groucho
- Hans
- Hazel
- Hopkins
- Hornsby
- Jacob
- Jacques
- Jeremiah
- Kyle
- Lyman
- Mac
- Medli
- Moe
- O'Hare
- Olive
- Poncho
- Rex
- Ricky
- Rolf
- Rory
- Teddy
- Toby
- W. Link
- Wade
- Walker
- Wart Jr.
- Wolfgang
Notes
- ↑ Re-Tail sell price; if item can be sold at Timmy and Tommy's store, it is 80% of the sell price; if item can be sold to Leila at Tortimer Island, it is 5% of the sell price.