Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Agonite]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=1067693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
10
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246 AND t1.o_id=1067693)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_3 | 9 | const, const | 97 | Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Agonite halberd with a pronounced spike and a flamethorn haft | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite hauberk etched in rolling sand dunes outlined with glowing truegold | Drathrok's Duskruin 448/End Loot | true |
Agonite judge's gavel wrapped in pale crimson kirmiko | Drathrok's Duskruin 438/Incidental loot , Drathrok's Duskruin 430/Incidental loot | |
Agonite lamellar helm sculpted with the visage of a blazing phoenix | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Agonite longsword with a dragon fire opal set in the pommel | Sleeping Dragon Corn Maze 428/End loot | |
Agonite mace with a head cast in the shape of a frog | Sleeping Dragon Corn Maze 428/End loot | |
Agonite mace with a head cast in the shape of a grinning gargoyle | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite mail balaclava set with dragon fire opal eyes | Item:Dusky dreamweave backpack clasped with a shimmering dragon fire opal | true |
Agonite mail gloves firestained with gold and vermilion hues | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Agonite mail gloves tipped with dragon fire opal talons | Item:Dusky dreamweave backpack clasped with a shimmering dragon fire opal | true |
Agonite mail gloves with barghest claw tips | Drathrok's Duskruin 448/End Loot | true |
Agonite mail greaves patterned with dragon fire opal flames | Item:Dusky dreamweave backpack clasped with a shimmering dragon fire opal | true |
Agonite mail shirt layered over dusky dreamweave padding | Item:Dusky dreamweave backpack clasped with a shimmering dragon fire opal | true |
Agonite mask etched in rolling sand dunes outlined with glowing truegold | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite pin set with a delicate cluster of rikar crystals | Return to the Keep 431/Supply Wagon | |
Agonite plate gauntlets lined with firesilk padding | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | true |
Agonite plate mask firestained with gold and vermilion hues | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade, Taisidon Mystery 435/A'baya Esplanade | true |
Agonite predator's spear | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite sigilated ring with wavy edges | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot, Droughtman's Challenge 437/End loot | true |
Agonite spatha with a dragon fire opal set in the pommel | Sleeping Dragon Corn Maze 428/End loot | |
Agonite statuette of the Human Emperor Hermothius | Drathrok's Duskruin 430/Incidental loot | |
Agonite tasset etched in rolling sand dunes outlined with glowing truegold | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite vambraces etched in rolling sand dunes outlined with glowing truegold | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite vest etched in rolling sand dunes outlined with glowing truegold | Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Agonite warhorn shaped into a snarling wolf's head | Drathrok's Duskruin 426/Drathrok's Assemblage | |
Agonite-edged triangular sipar with various faces swirling across its surface | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot | |
Agonite-plated battle crossbow bound in smokewhorl | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot | true |
Armure tabard with sturdy vardite pauldrons | Owirvald Riverhaven Auction 427 , Item:Khiynit backpack with a vardite clasp | |
Articulated agonite toolstrap | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | true |
Barbed agonite tailband set with a large demon gaze agate | Weapon:Serrated agonite katavdar with wickedly barbed spikes , Drathrok's Duskruin 446/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot | true |
Canvas carryall pinned with an agonite map | Droughtman's Challenge 441/Raffle | |
Canvas sack pinned with an agonite ziggurat | Su Helmas 440: Entrapped/Raffle | true |
Chakrel blade-warrior amulet suspended from an agonite chain | Drathrok's Duskruin 426/Drathrok's Assemblage | |
Coiled black taipan covered in imbricated agonite scales | Droughtman's Challenge 444/End loot , Droughtman's Challenge 441/End loot, Droughtman's Challenge 437/End loot, Droughtman's Challenge 433/End loot, Droughtman's Challenge 430/End loot | true |
Crushing forgeheart iron meteor hammer brandishing anvil-sculpted heads | Drathrok's Duskruin 448/End Loot | true |
Dark agonite great helm patterned with stylized flames | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | |
Demonscale-shrouded chain balaclava pierced by countless agonite spines | Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true |
Dragon's tail flail with a firestained head of agonite | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | |
Dusky dreamweave backpack clasped with a shimmering dragon fire opal | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Sleeping Dragon Corn Maze 439/End loot, Sleeping Dragon Corn Maze 436/End loot, Sleeping Dragon Corn Maze 432/End loot, Sleeping Dragon Corn Maze 428/End loot | true |
Faded muslin backpack clasped with an agonite gargoyle medallion | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot | |
Felwood tanbo with morgawr bone inlaid agonite tips | House of the Revenant Fang 437/Shadowy Safehouse , House of the Revenant Fang 433/Shadowy Safehouse | |
Ferocious chakrel boar with sharp tusks | Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 448/Incidental loot , Drathrok's Duskruin 446/Incidental loot | true |
Firestained agonite armband draped in a series of six interlocking rings | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade | true |
Firestained agonite aventail covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Firestained agonite backplate covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Firestained agonite bola with braided onyx-hide ties | House of the Revenant Fang 437/Shadowy Safehouse | |
Firestained agonite breastplate covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Firestained agonite dome helm covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Firestained agonite fauld covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |
Firestained agonite gauntlets covered in an intricate asini reticulation | Drathrok's Duskruin 442/Drathrok's Assemblage, Drathrok's Duskruin 448/End Loot , Drathrok's Duskruin 446/Drathrok's Assemblage | true |