Editing Clothing/New Leaf/Ornate

{{DISPLAYTITLE:List of ornate clothing in {{NL|short|nolink}}}}
The following is a '''list of clothing''' in {{NL}} that have '''ornate''' as their style designation.

{{TableTop NL Clothing|name=ornate clothing}}

{{#cargo_query:
table=nl_clothing
|group by=nl_clothing.en_name
|fields=nl_clothing._pageName=pagename,catalog_num=catalog-num,en_name=name,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,availability3,availability_rv=availability-rv,color1,color2,theme1,theme2,theme3,style,gender,category
|where=style='Ornate'
|order by=nl_clothing.clothing_category_sort,nl_clothing.catalog_num
|format=template
|template=CargoDisplayNLClothing
|named args=yes
|limit=40
}}

{{TableFooter|note={{Community:ACNL Spreadsheet/Attribution}}}}

==Notes==
{{Note list}}

{{Navbox Fashion}}
[[Category:Lists of clothing]]
@@ Line 1: / Line 1: @@
-{{DISPLAYTITLE:List of ornate items in {{NL|short|nolink}}}}
+{{DISPLAYTITLE:List of ornate clothing in {{NL|short|nolink}}}}
-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.
+The following is a '''list of clothing''' in {{NL}} that have '''ornate''' as their style designation.
-{{TableTop Multi|game=NL|name=Ornate items}}
+{{TableTop NL Clothing|name=ornate clothing}}
-{{#cargo_compound_query:
-tables=nl_clothing;
+{{#cargo_query:
-group by=nl_clothing.en_name;
+table=nl_clothing
-order by=nl_clothing.clothing_category_sort,nl_clothing.catalog_num;
+|group by=nl_clothing.en_name
-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;
+|fields=nl_clothing._pageName=pagename,catalog_num=catalog-num,en_name=name,image,buy1_price=buy1-price,buy1_wikitext=buy1,sell,availability1,availability2,availability3,availability_rv=availability-rv,color1,color2,theme1,theme2,theme3,style,gender,category
-where=style="Ornate";
+|where=style='Ornate'
-limit=96
+|order by=nl_clothing.clothing_category_sort,nl_clothing.catalog_num
-|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,nl_furniture.en_name;
-fields=nl_furniture._pageName=pagename,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
+|template=CargoDisplayNLClothing
 |named args=yes
+|limit=40
 }}
 {{TableFooter|note={{Community:ACNL Spreadsheet/Attribution}}}}
-==Favorites==
-This is a list of villagers whose 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=favstyle="Ornate"
-|order by=name_sort
-|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==
 {{Note list}}
-[[Category:Items]]
+{{Navbox Fashion}}
-[[Category:Lists of furniture]]
 [[Category:Lists of clothing]]