Template:BTDB2 cosmetic item list by id: Difference between revisions
No edit summary |
mNo edit summary |
||
| Line 7: | Line 7: | ||
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | |join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | ||
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "| | |fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|x20px]]") = Icon, | ||
CONCAT(btdb2_cosmetic_items.name) = Name, | CONCAT(btdb2_cosmetic_items.name) = Name, | ||
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"| | 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|}}}' | |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|}}}' | ||