Template:BTDB2 cosmetic item list by id: Difference between revisions

Line 4:

|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|x20px]]") = Icon,

CONCAT(btdb2_cosmetic_items.name) = Name,

CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category

CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|x20px|link=", btdb2_cosmetic_categories._pageName, "]] [[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category

|where=btdb2_cosmetic_items.id = '{{{1|}}}' OR btdb2_cosmetic_items.id = '{{{2|}}}' OR btdb2_cosmetic_items.id = '{{{3|}}}' OR btdb2_cosmetic_items.id = '{{{4|}}}' OR btdb2_cosmetic_items.id = '{{{5|}}}' OR btdb2_cosmetic_items.id = '{{{6|}}}' OR btdb2_cosmetic_items.id = '{{{7|}}}' OR btdb2_cosmetic_items.id = '{{{8|}}}' OR btdb2_cosmetic_items.id = '{{{9|}}}' OR btdb2_cosmetic_items.id = '{{{10|}}}' OR btdb2_cosmetic_items.id = '{{{11|}}}' OR btdb2_cosmetic_items.id = '{{{12|}}}' OR btdb2_cosmetic_items.id = '{{{13|}}}' OR btdb2_cosmetic_items.id = '{{{14|}}}' OR btdb2_cosmetic_items.id = '{{{15|}}}' OR btdb2_cosmetic_items.id = '{{{16|}}}'

|where=btdb2_cosmetic_items.id = '{{{1|}}}' OR btdb2_cosmetic_items.id = '{{{2|}}}' OR btdb2_cosmetic_items.id = '{{{3|}}}' OR btdb2_cosmetic_items.id = '{{{4|}}}' OR btdb2_cosmetic_items.id = '{{{5|}}}' OR btdb2_cosmetic_items.id = '{{{6|}}}' OR btdb2_cosmetic_items.id = '{{{7|}}}' OR btdb2_cosmetic_items.id = '{{{8|}}}' OR btdb2_cosmetic_items.id = '{{{9|}}}' OR btdb2_cosmetic_items.id = '{{{10|}}}' OR btdb2_cosmetic_items.id = '{{{11|}}}' OR btdb2_cosmetic_items.id = '{{{12|}}}' OR btdb2_cosmetic_items.id = '{{{13|}}}' OR btdb2_cosmetic_items.id = '{{{14|}}}' OR btdb2_cosmetic_items.id = '{{{15|}}}' OR btdb2_cosmetic_items.id = '{{{16|}}}' OR btdb2_cosmetic_items.id = '{{{17|}}}' OR btdb2_cosmetic_items.id = '{{{18|}}}' OR btdb2_cosmetic_items.id = '{{{19|}}}' OR btdb2_cosmetic_items.id = '{{{20|}}}'

|order by=btdb2_cosmetic_categories.name

|format=table

@@ Line 4: / Line 4: @@
 |fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|x20px]]") = Icon,
 CONCAT(btdb2_cosmetic_items.name) = Name,
-CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category
+CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|x20px|link=", btdb2_cosmetic_categories._pageName, "]] [[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category
-|where=btdb2_cosmetic_items.id = '{{{1|}}}' OR btdb2_cosmetic_items.id = '{{{2|}}}' OR btdb2_cosmetic_items.id = '{{{3|}}}' OR btdb2_cosmetic_items.id = '{{{4|}}}' OR btdb2_cosmetic_items.id = '{{{5|}}}' OR btdb2_cosmetic_items.id = '{{{6|}}}' OR btdb2_cosmetic_items.id = '{{{7|}}}' OR btdb2_cosmetic_items.id = '{{{8|}}}' OR btdb2_cosmetic_items.id = '{{{9|}}}' OR btdb2_cosmetic_items.id = '{{{10|}}}' OR btdb2_cosmetic_items.id = '{{{11|}}}' OR btdb2_cosmetic_items.id = '{{{12|}}}' OR btdb2_cosmetic_items.id = '{{{13|}}}' OR btdb2_cosmetic_items.id = '{{{14|}}}' OR btdb2_cosmetic_items.id = '{{{15|}}}' OR btdb2_cosmetic_items.id = '{{{16|}}}'
+|where=btdb2_cosmetic_items.id = '{{{1|}}}' OR btdb2_cosmetic_items.id = '{{{2|}}}' OR btdb2_cosmetic_items.id = '{{{3|}}}' OR btdb2_cosmetic_items.id = '{{{4|}}}' OR btdb2_cosmetic_items.id = '{{{5|}}}' OR btdb2_cosmetic_items.id = '{{{6|}}}' OR btdb2_cosmetic_items.id = '{{{7|}}}' OR btdb2_cosmetic_items.id = '{{{8|}}}' OR btdb2_cosmetic_items.id = '{{{9|}}}' OR btdb2_cosmetic_items.id = '{{{10|}}}' OR btdb2_cosmetic_items.id = '{{{11|}}}' OR btdb2_cosmetic_items.id = '{{{12|}}}' OR btdb2_cosmetic_items.id = '{{{13|}}}' OR btdb2_cosmetic_items.id = '{{{14|}}}' OR btdb2_cosmetic_items.id = '{{{15|}}}' OR btdb2_cosmetic_items.id = '{{{16|}}}' OR btdb2_cosmetic_items.id = '{{{17|}}}' OR btdb2_cosmetic_items.id = '{{{18|}}}' OR btdb2_cosmetic_items.id = '{{{19|}}}' OR btdb2_cosmetic_items.id = '{{{20|}}}'
 |order by=btdb2_cosmetic_categories.name
 |format=table