Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Acenite]]
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=593841)
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
0
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=593841)
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
0
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 | 50 | 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 |
---|---|---|
Item:Acenite and cambrinth armband in the shape of an icy blue-scaled leviathan | Inventor's Worktable | |
Item:Acenite circlet of intricately wrought icicles dripping damilyo pearls | Inventor's Worktable | |
Item:Acenite hip-chain woven to resemble a spider's web | ||
Item:Acenite neithrel band bearing tiny saffron topaz geshiloira blooms along its chains | Bardic Journey (6) | true |
Item:Acenite reliquary with enameled sides | Only The Holy (2) | true |
Item:Acenite scroll case with blue gold end caps | House of the Revenant Fang 423/Shadowy Safehouse | |
Item:Acenite sea unicorn with a glittering tail of coralite | Ritual Addiction | |
Item:Acenite spork with a trio of chocolate opals set atop its gently rounded handle | Tildi's Flowers (7) , Item:Spherical poke fashioned from a hollowed out coconut shell | |
Item:Acenite-framed milk glass case | Shimmer Shack (4) , Shimmer Shack (3) | |
Item:Black gold Bardic Spirit Knot hairstick engraved with acenite geshiloira blossoms | Bardic Journey (6) | |
Item:Black lotusweave vest featuring matching pockets | Thryntyrlz BagMaker's Yurt (4) | |
Item:Bone-white acenite calling card dispenser | Crimson Crane Couriers (2) | false |
Item:Carved acenite wedding torque | Finer Things (4) , Finer Things (3) | |
Shield:Ceremonial shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Shield:Circular shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Item:Cloth-of-gold waistcoat with acenite toggles | Finer Things (4) , Finer Things (3) | |
Item:Dainty acenite rat pin with its mouth gaping in a yawn | Drathrok's Duskruin 422/Incidental loot , Drathrok's Duskruin 421/Incidental loot | |
Item:Ecosphere dangling from a braided chain | Item:Simple ecosphere | true |
Item:Engraved acenite phylactery set on a leather strap | Only The Holy (2) | true |
Armor:Enveloping swordsman's cowl banded with light grey accents | Item:Swordsman's pack fortified with a multitude of leather straps | true |
Item:Filigreed pair of rencate and acenite dustanjis earcuffs | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Fine acenite earcuff embossed with metal ingots | Turialo's Haven (10) | |
Item:Four-strand necklace of stephanotis blossoms sculpted from winter white acenite | Tildi's Blooms (4) , Tildi's Blooms (3) | |
Item:Fragile milk glass torque draping acenite chains scattered with rainbow sapphires | Shimmer Shack (4) , Shimmer Shack (3) | |
Item:Gold and ivory tartan greatkilt with an acenite pin | Finer Things (4) , Finer Things (3) | |
Item:Heavy vardite coffee mug stamped with the image of a regal dragon's head | Limited Treasures (2) | |
Item:Iridescent covellite nose stud set with a tiny water lily | Tildi's Faire Flowers (2) | |
Shield:Kite shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Item:Opaque white acenite triangle | Musiceum (7) , Musiceum (6), Musiceum (5) | |
Item:Ornamented acenite pyx with a matching lid | Only The Holy (2) | true |
Shield:Oval shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Item:Pair of mango-hued faesilk boots wrapped in eye-searing lime green silk | Give 'Em the Boot (8) | |
Shield:Polished battle shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Shield:Polished small shield engraved with shesegri etchings | House of the Revenant Fang 437/Incidental loot , House of the Revenant Fang 433/Incidental loot | |
Item:Pristine white brocatelle baldric accented with firestained acenite buckles | Shard Theater Faire 419 raffles | |
Item:Scruffy jadeleaf arm pouch with an acenite clasp | Su Helmas 444: Make Haste!/Incidental loot | true |
Item:Sculpted windsteel bracer graced with delicate acenite blossoms | Tildi's Faire Flowers (2) | |
Item:Small ring box of white acenite | Shimmer Shack (4) , Shimmer Shack (3) | |
Item:Smooth acenite lockpick case | Sketchy By Design (7) | |
Item:Smooth acenite ring shaped like a kraken with knotted tentacles | Drogor Shrine | |
Item:Soft purple leather harness displaying graceful aquamarine wings | Bacon Man's Birthday Bash 419/Pig Maze | |
Item:Strips of rawhide leather beaded with carved white acenite | Turialo's Haven (10) | |
Item:Sturdy linen mining shirt adorned with acenite buttons | Turialo's Haven (10) | |
Armor:Stylish swordsman's longcoat secured by interwoven straps and acenite buckles | Item:Swordsman's pack fortified with a multitude of leather straps | true |
Weapon:Tomiek elbow spikes webbed in acenite | Accents for the Arachnophile (7) | |
Weapon:Tomiek knee spikes webbed in acenite | Accents for the Arachnophile (7) | |
Item:Twisted acenite wedding torque | Finer Things (4) , Finer Things (3) | |
Item:Two-tone puppeteer's trunk checkered in glittering diamond shapes | Shard Theater Faire 419 | |
Item:Verdant camlet rucksack | Thryntyrlz BagMaker's Yurt (4) | |
Item:Wide acenite commitment ring molded around a single rainbow sapphire | Item:Small ring box of white acenite , Shimmer Shack (4), Shimmer Shack (3) |