User:KickahaOta/sandbox/prophecies: Difference between revisions
< User:KickahaOta | sandbox
KickahaOta (talk | contribs) (Removed cost to seal) |
KickahaOta (talk | contribs) (Added flavour text) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=items, prophecies | tables=items, prophecies | ||
|fields=items._pageName=Name, | |fields=items._pageName=Name, CONCAT("''", items.flavour_text, "''")=Flavour Text, prophecies.prediction_text=Prediction, CONCAT(prophecies.objective)=Objective, CONCAT(prophecies.reward)=Reward | ||
|where=prophecies._pageName=items._pageName AND items.drop_enabled | |where=prophecies._pageName=items._pageName AND items.drop_enabled | ||
|join on=items._pageName = prophecies._pageName | |join on=items._pageName = prophecies._pageName | ||
Latest revision as of 21:21, 3 December 2021
No results