Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Red gold]]
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=53815)
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=53815)
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 | 133 | 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:Burnished glass sphere polished to a mirror-bright shine | Shimmer Shack (4) , Shimmer Shack (3), Shimmer Shack (2), Shimmer Shack (1) | |
Item:Charming bracelet of playful red gold kittens with slitted indakar eyes | Matter of Magik (3) , Matter of Magik (2), Matter of Magik (1) | |
Item:Charred gold ring with a broken soulstone centerpiece | Dark Knight | |
Item:Clear crystal pipe sculpted with red-tinted flames around the bowl | ||
Item:Copperwood rapier sheath ornamented with red gold filigree | Storms of Silk | |
Item:Crimson wool belt with a red gold buckle | Dress for Success (2) , Dress for Success (1) | true |
Item:Crystal cowbell with a red gold phoenix handle | Joys of Noise (6) | |
Item:Daring camocas chest binder diagonally striped with red gold and brass metallics | Split Personalities (3) , Item:Red gold music box with its gilding flaking to reveal wood corrupted by bone bits | |
Weapon:Dark steel katavdar embossed with a black-on-black niello dragon | Q'tahhl's Place (2) , Item:Dark steel tailband embossed with a black-on-black niello dragon, Item:Dark steel tailband embossed with a black-on-black niello dragon | true |
Item:Dark steel tailband embossed with a black-on-black niello dragon | Weapon:Dark steel katavdar embossed with a black-on-black niello dragon , Q'tahhl's Place (2), Weapon:Dark steel katavdar embossed with a black-on-black niello dragon | true |
Item:Deep amber necklace with a baroque pearl mermaid pendant | Paper Lion , Moveable Feast, Dusk-winged Duck | |
Item:Detailed blown-glass doll head suspended from a twisted red-gold chain | ||
Item:Diaphanous crimson silk voile sari draped over a skimpy golden lipka cotton skirt | Split Personalities (3) , Item:Red gold music box with its gilding flaking to reveal wood corrupted by bone bits | |
Item:Disturbingly diminutive phalanx crudely carved into a key | Split Personalities (3) , Item:Red gold music box with its gilding flaking to reveal wood corrupted by bone bits | |
Item:Dragonfire brocade prayer mat embroidered with a pale dragon skull | Tieheq with the Thirteen (4) , Tieheq with the Thirteen (3), Tieheq with the Thirteen (2), Tieheq with the Thirteen (1) | true |
Item:Firestorm velvet vest with red gold buttons | Clothes By Any Other Flame (2) | true |
Item:Flamboyant flame-shaped earring sculpted from red gold | Uwresari's Exotic Wonders (2) , Uwresari's Exotic Wonders (1) | |
Item:Frosted shot glass painted with bloody entrails dripping down the sides | Entrail Toss Arena (3) , Entrail Toss Arena (2) | |
Item:Graceful chakrel swan amulet hung from a braided red gold chain | Vishlan's Wares (1) , Burning Embers (1) | |
Item:Gracefully curved hairstick topped with vibrantly hued golden flag blooms | Tildi's Faire Flowers (2) | |
Item:Green satin vest with red-gold buttons | Trader Shop (Crossing) | |
Item:Grinning red gold skulls | Sketchy By Design (7) | |
Item:Heavy red gold bangles strung with large wooden beads | Turialo's Haven (7) | |
Item:Interlocking rosewood armband with an empty setting prominent on one panel | Empty Settings (1) | |
Item:Intricate red gold wristcuff | Grisgonda's Gems and Jewels | |
Item:Iridescent jade silk sarong pinned with bejeweled dragonflies | Clothing Shop (2) | |
Item:Animite hand wristlet accented with red gold sunrays | ||
Item:Baroque pearl earrings swaying from red gold anemone studs | ||
Item:Beautiful golden wedding ring crowned with a blooming red-gold rose | ||
Item:Blood-red leather sochi adorned with a tri-gold clasp | ||
Item:Bright orange leather talisman case accented with red jade | ||
Item:Broad red-gold wedding band engraved with a pair of resting warriors | ||
Item:Charming bracelet of playful red gold kittens with slitted indakar eyes | ||
Item:Charred gold ring with a broken soulstone centerpiece | ||
Item:Dark steel tailband embossed with a black-on-black niello dragon | ||
Item:Deep amber necklace with a baroque pearl mermaid pendant | ||
Item:Detailed blown-glass doll head suspended from a twisted red-gold chain | ||
Item:Dragonfire brocade prayer mat embroidered with a pale dragon skull | ||
Item:Flamboyant flame-shaped earring sculpted from red gold | ||
Item:Flowing uaro's'sugi of vivid lava samite with a long beaded fringe | ||
Item:Frosted shot glass painted with bloody entrails dripping down the sides | ||
Item:Graceful chakrel swan amulet hung from a braided red gold chain | ||
Item:Green satin vest with red-gold buttons | ||
Item:Heavy red gold bangles strung with large wooden beads | ||
Item:Interlocking rosewood armband with an empty setting prominent on one panel | ||
Item:Large bolt of dragonfire brocade fabric | ||
Item:Large bolt of lava samite fabric | ||
Item:Large pearl circlet with a dangling water opal teardrop in front | ||
Item:Large red gold pendant shaped to resemble an open rose | ||
Item:Lava samite prayer mat emblazed with an anvil |