Tears of Themis Wiki/New Content: Difference between revisions
From Tears of Themis Wiki
imported>Harmonea (+link to new lounge page) |
imported>Harmonea (Cards -> hoyo ML order) |
||
Line 26: | Line 26: | ||
<div class="new-content-header">Newest Cards</div> | <div class="new-content-header">Newest Cards</div> | ||
{{#invoke:CargoQuery|main | {{#invoke:CargoQuery|main | ||
|q?tables=Card | |q?tables=Card,OrderByCase=CardCase,OrderByCase=MLCase | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', rarity, '<br/>"', cardName, '"')=text | |q?join=Card.featuredCharacter=MLCase.maleLead,Card.rarity=CardCase.cardRarity | ||
|q?fields=name=name,CONCAT(featuredCharacterShortName, ' ', Card.rarity, '<br/>"', cardName, '"')=text | |||
|q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | |q?where=releaseDate>="{{#var:latestCardReleaseDate}}" | ||
|q?orderBy= | |q?orderBy=CardCase.orderCase ASC, MLCase.orderCase ASC | ||
|template=Card icon | |template=Card icon | ||
}} | }} |