User:Dreddie/sandbox: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
==Vaal areas== | ==Vaal areas== | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=areas=normal,areas=vaal | tables=areas=normal,areas=vaal,monsters=bosses | ||
|join on=normal.vaal_area_ids HOLDS vaal.id | |join on=normal.vaal_area_ids HOLDS vaal.id,vaal.boss_monster_ids HOLDS bosses.metadata_id | ||
|fields=vaal.name, | |fields=concat('[[',vaal.name,'|', vaal.name,']]')=Name, | ||
group_concat('[[',normal.name,'|', normal.name,']]' SEPARATOR ", ")=FoundInArea | group_concat('[[',normal.name,'|', normal.name,']]' SEPARATOR ", ")=FoundInArea, | ||
group_concat('[[',bosses.name,'|', bosses.name,']]' SEPARATOR ", ")=Boss | |||
|where=normal.is_vaal_area="0" | |where=normal.is_vaal_area="0" | ||
and vaal.is_vaal_area="1" | |||
and bosses.is_boss="1" | |||
|group by=vaal.name | |group by=vaal.name | ||
}} | }} |
Revision as of 10:10, 14 August 2023
Vaal areas
Mastery queries
Mastery | Effects |
---|---|
Leech Mastery |
|
Mana Mastery |
|
Recovery Mastery |
|