Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Gloomwood]]
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=209849)
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
20
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=209849)
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | index_merge | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id,o_id_3 | 5,9 | 197 | Using intersect(o_id,o_id_3); 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:Feathery seaweed fronds dappled with swirls | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes | |
Weapon:Fire-blackened ceremonial dagger etched with the word "Widowmaker" | Harawep Shrine 425 , Harawep Shrine 421 | |
Weapon:Folded tyrium and kertig katana with an elaborately watermarked blade | Hollow Eve Festival 399 Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red , Hollow Eve Festival 399/Auction, Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red | |
Item:Folding chair with a cushioned seat | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Fragile sea globe with a polished base | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Weapon:Gargantuan Be'ort war icon set atop a tortuous haft of gloomwood | Misenseor Goods (5) , Misenseor Goods (3) | |
Weapon:Glaes bardiche with a gloomwood handle | Halberdashery | |
Weapon:Glaes-bladed fan adorned with a gloomwood lily charm | Smaller Side of Life (3) | |
Item:Gloomglass mirror backed with gloomwood | Future is Now (4) | |
Item:Gloomwood Bardic Blood Knot tailband with a narrow cambrinth inlay | Dark Symphony (5) , Dark Symphony (4), Dark Symphony (3) | |
Weapon:Gloomwood arbalest with a polished steel lath | Ratchet Shack | |
Item:Gloomwood bassoon adorned with spectrolite spiders | Whimsical Winds (4) | |
Item:Gloomwood bassoon carved with tiny shrikes | Whimsical Winds (3) , Whimsical Winds (2) | |
Item:Gloomwood bed with posts carved to resemble leaning trees | Once Possessed (2) | |
Item:Gloomwood broom with thorned bristles | Hollow Eve Festival 414/Auction | |
Item:Gloomwood cane capped with a vulture's head | Eagle Eye (2) , Eagle Eye (1) | |
Item:Gloomwood cane set with a blue mistglass orb | Cute as a Button (2) | |
Weapon:Gloomwood crossbow with a steel lath | Ratchet Shack | |
Item:Gloomwood door with wrought iron banding | Two Doors Down (2) , Two Doors Down (1) | true |
Item:Gloomwood framed mirror | Clear Visions (1) | |
Item:Gloomwood kaleidoscope inlaid with silver | Clear Visions (1) | |
Item:Gloomwood katana sheath wrapped in braided shadesatin dyed a deep wine red | Hollow Eve Festival 399/Auction | |
Weapon:Gloomwood khuj with a dark purple blade | Uwresari's Exotic Wonders (1) | |
Weapon:Gloomwood khuj with er'qutrite inlay along the blade | Uwresari's Exotic Wonders (1) | |
Item:Gloomwood knitting needles | Snacky Happiness (2) | true |
Item:Gloomwood lens with clear glass | Vatari's Ritual Addiction, Vatari's Ritual Addiction (1) | |
Item:Gloomwood mirror inset with a demantoid garnet | Hollow Eve Festival 439/Raffles | |
Item:Gloomwood music box inlaid with a platinum cobweb | ||
Weapon:Gloomwood nightstick carved with tiny belladonna flowers | Flower Power (5) , Flower Power (4), Flower Power (3), Flower Power (2) | |
Item:Gloomwood ocarina carved into the likeness of a spider | true | |
Item:Gloomwood owl charm | Chizelli's Charms (4) | |
Weapon:Gloomwood parry stick carved in a series of skulls | Hollow Eve Festival 421/Raffles | |
Weapon:Gloomwood parry stick with a crow carved in low relief | ||
Weapon:Gloomwood parry stick with a raven carved in low relief | ||
Weapon:Gloomwood parry stick with a wolf carved in low relief | ||
Weapon:Gloomwood quarter staff inlaid with wrought iron bands | Hollow Eve Festival 406/Raffles | |
Weapon:Gloomwood rolling pin | Pita Pan (2) | true |
Weapon:Gloomwood skirmisher's lance with a leaf-shaped tyrium tip | Hollow Eve Festival 403 Auction, Hollow Eve Festival 403/Auction | |
Weapon:Gloomwood staff sling with spidersilk whipcords | Outrageous Fortune | |
Weapon:Gloomwood steppe crossbow with a steel prod | ||
Item:Gloomwood stylus with an intricately carved silversteel tip | Sketchy By Design (9) | |
Item:Gloomwood tankard with darkstone bindings | ||
Item:Gloomwood tea chest webbed in strands of chitinous tomiek | Tea For Tamsine (3) , Tea For Tamsine (2) | |
Item:Gloomwood telescope case with mistglass caps | Clear Visions (1) | |
Item:Gloomwood telescope inlaid with silver | Clear Visions (1) | |
Item:Gloomwood tome locket carved with a crude skull | By the Book | |
Shield:Gloomwood tower shield banded with tyrium | Uwresari's Exotic Wonders (1) | |
Item:Gloomwood toy sword | Just a Slice (2) | |
Item:Gloomwood violin with an elaborate witchclaw fret | Hollow Eve Festival 410/Raffles | |
Item:Gloomwood wall with matching baseboards | Wally's World of Walls (2) , Wally's World of Walls (1) | true |