Cargo query
Jump to navigation
Jump to search
Showing below up to 5 results in range #101 to #105.
| Skill | Claw | Dagger | Sword (1H) | Mace (1H) | Axe (1H) | Staff | Sword (2H) | Mace (2H) | Axe (2H) | Unarmed | Shield |
|---|---|---|---|---|---|---|---|---|---|---|---|
0 |
0 |
0 |
1 |
1 |
1 |
0 |
1 |
1 |
1 |
0 |
|
0 |
0 |
0 |
1 |
1 |
1 |
0 |
1 |
1 |
1 |
0 |
|
1 |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
0 |
0 |
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
0 |
0 |
{{#cargo_query:
tables=items, skill, skill_gems
|fields=CONCAT('[[', items.name, '|', items._pageName, ']]')=Skill,
CONCAT(item_class_id_restriction__FULL REGEXP "Claw")=Claw,
CONCAT(item_class_id_restriction__FULL REGEXP "Dagger")=Dagger,
CONCAT(item_class_id_restriction__FULL REGEXP "One Hand Sword")=Sword (1H),
CONCAT(item_class_id_restriction__FULL REGEXP "One Hand Mace|Sceptre")=Mace (1H),
CONCAT(item_class_id_restriction__FULL REGEXP "One Hand Axe")=Axe (1H),
CONCAT(item_class_id_restriction__FULL REGEXP "Staff")=Staff,
CONCAT(item_class_id_restriction__FULL REGEXP "Two Hand Sword")=Sword (2H),
CONCAT(item_class_id_restriction__FULL REGEXP "Two Hand Mace")=Mace (2H),
CONCAT(item_class_id_restriction__FULL REGEXP "Two Hand Axe")=Axe (2H),
CONCAT(item_class_id_restriction__FULL REGEXP "Unarmed")=Unarmed,
CONCAT(item_class_id_restriction__FULL REGEXP "Shield")=Shield
|where=class_id="Active Skill Gem"
AND skill_gems.gem_tags__FULL NOT REGEXP "Vaal"
AND item_class_id_restriction__FULL IS NOT NULL
AND NOT item_class_id_restriction__FULL REGEXP ".*Bow.*"
AND NOT item_class_id_restriction__FULL REGEXP ".*Wand.*"
|join on=items._pageID=skill._pageID, items._pageID=skill_gems._pageID
|format=auto
|offset=100
|limit=100
}}