Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Cinnabar]]
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=83199)
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=83199)
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 | 5 | const | 56 | Using where; 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:Cinnabar mirror depicting a Rakash with glittery gold fur | Taisidon Mystery 446/A'baya Esplanade , Taisidon Mystery 443/A'baya Esplanade, Taisidon Mystery 439/A'baya Esplanade | true |
Item:Cinnabar ring inset with the shrew of Kerenhappuch | Misenseor Goods (6) , Misenseor Goods (5), Misenseor Goods (4), Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1) | |
Item:Cinnabar tambourine threaded with vermilion ribbon through starburst-shaped notches | Jyngle's Jangles | |
Item:Cinnabar-rubbed ivory nguru | Graimairo Wares (2) , Graimairo Wares (1) | |
Item:Cowled brown cassock with hundreds of cinnabar moths clinging to its folds | Akaterina's Cassocks | |
Item:Deep crimson felt quiver with a sunburst of cinnabar and fire coral | Zaldi Taipa Bowyer | |
Item:Floor-length sackcloth cloak with a thick cinnabar coins-shaped clasp | Item:Sturdy sackcloth backpack decorated with twin coins patches | |
Item:Grey ambergris warhorn etched with cinnabar-rubbed nagas | Bardic Journey (4) | |
Item:Hollow Eve 399 gift | ||
Item:Black felt hawking pouch beaded with a sunburst of cinnabar and amber | ||
Item:Burnished gold vertebral fetish strung on bone-beaded cord | ||
Item:Cinnabar ring inset with the shrew of Kerenhappuch | ||
Item:Cinnabar-rubbed ivory nguru | ||
Item:Cowled brown cassock with hundreds of cinnabar moths clinging to its folds | ||
Item:Deep crimson felt quiver with a sunburst of cinnabar and fire coral | ||
Item:Hollow Eve 399 gift | ||
Item:Pale gold fletching pouch with a beaded sunburst of cinnabar and fire coral | ||
Item:Red-lacquer carving case with a cinnabar shrew clasp | ||
Item:Russet gem pouch with a cinnabar spoon charm | ||
Item:Warding beads | ||
Item:Large bowl painted with blossoms | Breaking and Entering/Kitchen loot | false |
Item:Long stirring rod tinted with colored hues | Breaking and Entering/Work Room loot | false |
Weapon:Narrow carving knife with a polished hilt | Breaking and Entering/Work Room loot | false |
Item:Necklace of woodpecker bone flutes etched with cinnabar-washed lidless eyes | ||
Item:Necromancer cinnabar | Item:Weathered ilomba chest with vardite hinges | |
Item:Pair of cardinal-red boots with a cinnabar coins insignia | Item:Sturdy sackcloth backpack decorated with twin coins patches | |
Item:Pale gold fletching pouch with a beaded sunburst of cinnabar and fire coral | Zaldi Taipa Bowyer, Zaldi Taipa Bowyer | |
Weapon:Polished scimitar with a leather-wrapped hilt bearing a circular cambrinth medallion (3) | Bardic Journey, Bardic Journey (7) | |
Item:Razaksel charm bracelet dangling polished cinnabar discs | Inventor's Worktable | |
Item:Red-lacquer carving case with a cinnabar shrew clasp | Altared Visions | |
Item:Russet gem pouch with a cinnabar spoon charm | Premium raffles | |
Item:Rustic mortar | Breaking and Entering/Kitchen loot | false |
Item:Rustic pestle | Breaking and Entering/Kitchen loot | false |
Shield:Red kite shield inlaid with cinnabar and opal highlights | ||
Weapon:Silverbirch saddle bow wrapped with flaxen horsehair braided through carved cinnabar beads | Zaldi Taipa Bowyer, Zaldi Taipa Bowyer | |
Item:Sinuous cocobolo bracelet engraved with numerous draconaeia blossoms | Tildi's Blooms (2) | |
Item:Small amulet with roughly carved edges | Breaking and Entering/Sanctum loot | |
Item:Smooth cinnabar jar affixed with a tiny decorative label | Sheer Beauty, Sheer Beauty | |
Item:Spiked cambrinth circlet inlaid with cinnabar seastars | Drogor Shrine | true |
Item:Stained sackcloth pants with a cinnabar coins buckle | Item:Sturdy sackcloth backpack decorated with twin coins patches | |
Weapon:Tamarisk plains bow with a cascade of silvery goshawk feathers and cinnabar beads dangling from the grip | Zaldi Taipa Bowyer, Zaldi Taipa Bowyer | |
Item:Tiered chains of brine shark teeth interspersed with driftwood rounds | Hair Apparent (2) | |
Item:Warding beads | Jahtinit's Corner , Item:Carved cedar warding bead box, Item:Carved cedar warding bead box | |
Weapon:Silverbirch saddle bow wrapped with flaxen horsehair braided through carved cinnabar beads | ||
Weapon:Tamarisk plains bow with a cascade of silvery goshawk feathers and cinnabar beads dangling from the grip | ||
Item:Wide leather war belt stamped with a cinnabar coins | Item:Sturdy sackcloth backpack decorated with twin coins patches |