User:Findar: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
drop_areas
drop_areas


|rarity_id                              = unique
items._pageID=maps._pageID,
                            maps.area_id=areas.id,


{{#cargo_query:
{{#cargo_query:
   tables=items, maps
   tables=items
  |join on=items._pageName=maps._pageName=maps.series=map_series.name
   |where = items.class_id="DivinationCard"  
   |where = items.class_id="DivinationCard"  
   |groupBy=items.name
   |group by=items.name
   |orderBy = map_series.ordinal DESC
   |format=dynamic table
  |fields=items.name, items.drop_areas, items.drop_areas_html
  |limit=25
  }}
 
{{#cargo_query:
  tables=items, maps,areas
  |join on=items._pageName=maps._pageName, maps.area_id=areas.id
  |where = items.class_id="Map" AND items.rarity_id!="unique"
  |group by = items.name
  |format=dynamic table
   |fields=items.name, items._pageName
   |fields=items.name, items._pageName
  |format=dynamic table
   |limit=25
   |limit=5000
   }}
   }}

Revision as of 08:41, 24 May 2023

Test Page

items._pageName=maps._pageName=maps.series=map_series.name

drop_areas

|rarity_id = unique


items._pageID=maps._pageID, 

                           maps.area_id=areas.id,
name drop areas drop areas html
name drop areas drop areas html
A Chilling Wind MapWorldsForbiddenWoods • MapWorldsColdRiver_ • MapWorldsFrozenCabins • MapWorldsSummit • MapWorldsGorge • MapWorldsIceberg [[Cold River Map|Cold River Map]] • [[Forbidden Woods Map|Forbidden Woods Map]] • [[Frozen Cabins Map|Frozen Cabins Map]] • [[Glacier Map|Glacier Map]] • [[Iceberg Map|Iceberg Map]] • [[Summit Map|Summit Map]]
A Dab of Ink 1_3_17_1 • MapWorldsScriptorium • MapWorldsMuseum • MapWorldsAcademy [[The Library|The Library]] • [[Academy Map|Academy Map]] • [[Museum Map|Museum Map]] • [[Scriptorium Map|Scriptorium Map]]
A Dusty Memory Synthesis_MapBoss • Synthesis_MapGuardian1 • Synthesis_MapGuardian2 • Synthesis_MapGuardian3 • Synthesis_MapGuardian4 [[Area:Synthesis~MapBoss|Cortex]] • [[Area:Synthesis~MapGuardian1|Altered Distant Memory]] • [[Area:Synthesis~MapGuardian2|Augmented Distant Memory]] • [[Area:Synthesis~MapGuardian3|Twisted Distant Memory]] • [[Area:Synthesis~MapGuardian4|Rewritten Distant Memory]]
A Familiar Call
A Fate Worse Than Death
A Modest Request
A Mother's Parting Gift 1_3_15 • 2_8_4 [[The Imperial Gardens|The Imperial Gardens]] • [[The High Gardens|The High Gardens]]
A Note in the Wind MapWorldsDrySea • MapWorldsDunes • MapWorldsDesertSpring • 2_9_4 • MapWorldsDesert [[The Oasis|The Oasis]] • [[Desert Map|Desert Map]] • [[Desert Spring Map|Desert Spring Map]] • [[Dry Sea Map|Dry Sea Map]] • [[Dunes Map|Dunes Map]]
A Sea of Blue MapWorldsMineralPools • MapWorldsCrystalOre • MapWorldsTortureChamber • MapWorldsGrotto • MapWorldsCitadel • MapWorldsZiggurat [[Citadel Map|Citadel Map]] • [[Crystal Ore Map|Crystal Ore Map]] • [[Grotto Map|Grotto Map]] • [[Mineral Pools Map|Mineral Pools Map]] • [[Primordial Blocks Map|Primordial Blocks Map]] • [[Ziggurat Map|Ziggurat Map]]
A Stone Perfected MapWorldsGrotto • MapWorldsWharf • MapWorldsFloodedMine • MapWorldsWaterways • MapWorldsVault • MapWorldsCoves • MapWorldsPeninsula • MapWorldsGeode [[Coves Map|Coves Map]] • [[Flooded Mine Map|Flooded Mine Map]] • [[Geode Map|Geode Map]] • [[Grotto Map|Grotto Map]] • [[Peninsula Map|Peninsula Map]] • [[Vault Map|Vault Map]] • [[Waterways Map|Waterways Map]] • [[Wharf Map|Wharf Map]]
Abandoned Wealth MapAtlasArsenal • MapAtlasReefUnique • MapWorldsShoreUnique [[Mao Kun|Mao Kun]]
Acclimatisation MapWorldsDesertSpring • MapWorldsDunes • MapWorldsDesert • MapWorldsDrySea [[Desert Map|Desert Map]] • [[Desert Spring Map|Desert Spring Map]] • [[Dry Sea Map|Dry Sea Map]] • [[Dunes Map|Dunes Map]]
Akil's Prophecy
Alivia's Grace MapWorldsAshenWood • MapWorldsSpiderForest • MapWorldsLair • MapWorldsThicket • MapWorldsDarkForest • MapWorldsForbiddenWoods • MapWorldsTropicalIsland • MapWorldsRamparts • MapWorldsStagnation • MapWorldsJungleValley • MapWorldsBrambleValley [[Ashen Wood Map|Ashen Wood Map]] • [[Bramble Valley Map|Bramble Valley Map]] • [[Dark Forest Map|Dark Forest Map]] • [[Forbidden Woods Map|Forbidden Woods Map]] • [[Jungle Valley Map|Jungle Valley Map]] • [[Lair Map|Lair Map]] • [[Ramparts Map|Ramparts Map]] • [[Spider Forest Map|Spider Forest Map]] • [[Stagnation Map|Stagnation Map]] • [[Thicket Map|Thicket Map]] • [[Tropical Island Map|Tropical Island Map]]
Alluring Bounty MapAtziri1 • MapAtziri2 [[The Apex of Sacrifice|The Apex of Sacrifice]] • [[The Alluring Abyss|The Alluring Abyss]]
Alone in the Darkness
Altered Perception
Ambitious Obsession
Anarchy's Price
Arrogance of the Vaal MapWorldsSunkenCity • MapWorldsAncientCity • MapWorldsVaalPyramid [[Ancient City Map|Ancient City Map]] • [[Sunken City Map|Sunken City Map]] • [[Vaal Pyramid Map|Vaal Pyramid Map]]
Assassin's Favour 1_3_5 • 2_8_8 • MapAtlasArcade • MapAtlasBazaar • MapAtlasQuay • MapWorldsAlleyways • MapWorldsBazaar • MapWorldsArcade • MapWorldsPort [[The Marketplace|The Marketplace]] • [[The Quay|The Quay]] • [[Alleyways Map|Alleyways Map]] • [[Arcade Map|Arcade Map]] • [[Bazaar Map|Bazaar Map]] • [[Port Map|Port Map]]
Assassin's Gift
Astral Protection MapWorldsMoonTemple [[Moon Temple Map|Moon Temple Map]]
Atziri's Arsenal MapWorldsVaalPyramidUnique • MapAtlasVaalPyramidUnique_ • MapAtlasSpiderLair_ [[Vaults of Atziri|Vaults of Atziri]]
Audacity MapAtziri1 [[The Apex of Sacrifice|The Apex of Sacrifice]]

More...

name _pageName
name _pageName
Abomination Map Map:Abomination Map (Necropolis)
Academy Map Map:Academy Map (Affliction)
Acid Caverns Map Map:Acid Caverns Map (Affliction)
Alleyways Map Map:Alleyways Map (Ancestor)
Ancient City Map Map:Ancient City Map (Affliction)
Arachnid Nest Map Map:Arachnid Nest Map (Affliction)
Arachnid Tomb Map Map:Arachnid Tomb Map (Ancestor)
Arcade Map Map:Arcade Map (Affliction)
Arena Map Map:Arena Map (Affliction)
Arid Lake Map Map:Arid Lake Map (Affliction)
Armoury Map Map:Armoury Map (Archnemesis)
Arsenal Map Map:Arsenal Map (Archnemesis)
Ashen Wood Map Map:Ashen Wood Map (Affliction)
Atoll Map Map:Atoll Map (Affliction)
Barrows Map Map:Barrows Map (Ancestor)
Basilica Map Map:Basilica Map (Affliction)
Bazaar Map Map:Bazaar Map (Affliction)
Beach Map Map:Beach Map (Ancestor)
Belfry Map Map:Belfry Map (Archnemesis)
Bog Map Map:Bog Map (Affliction)
Bone Crypt Map Map:Bone Crypt Map (Affliction)
Bramble Valley Map Map:Bramble Valley Map (Affliction)
Burial Chambers Map Map:Burial Chambers Map (Affliction)
Cage Map Map:Cage Map (Affliction)
Caldera Map Map:Caldera Map (Affliction)

More...

Retrieved from "https://www.poewiki.net/index.php?title=User:Findar&oldid=1356718"