Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Malachite]]
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=68586)
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
60
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=68586)
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
60
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 | 152 | 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:Earcuff | ||
Item:Elegant tiger maple cittern with an inlaid compass rose on the soundbox | ||
Item:Elongated mastiff skull | ||
Item:Engraved brass stylus wrapped in detailed malachite ivy | ||
Item:Gleaming metallic-red cinder beast with glittering onyx claws | ||
Item:Glossy malachite rose | ||
Item:Haedor | ||
Item:Hammered copper cigarillo case clasped by a malachite viper | ||
Item:Highly polished green malachite tailband | ||
Item:Intricately-painted ritual drum | ||
Item:Isael | ||
Item:Jangling golden hip-chain set with carved ivory roses | ||
Item:Large walrus hide case dyed a rich ebony hue | ||
Item:Malachite and ivory jar carved to resemble a water lily | ||
Item:Malachite bodhran charm hung from an ivory white silk ribbon | ||
Item:Malachite ring inset with the weasel of Huldah | ||
Item:Malachite viper's fang spellbook key | ||
Item:Nara'nsria | ||
Item:Patinated copper four-leaf clover studded with malachite | ||
Item:Pilonu | ||
Item:Platinum chain baleora bearing a claw pendant with a green malachite ball in its taloned grasp | ||
Item:Por'nidrel | ||
Item:Rectangular intarsia pendant depicting a waterfall in a forest | ||
Item:Ring (2) | ||
Item:Round intarsia pendant showing the sun shining over white-capped water | ||
Item:Shaman's drum with braided inlays of azurite-malachite along its rim | ||
Item:Silver spiral pendant hung with a rich green malachite teardrop | ||
Item:Silver-inlaid malachite neithrel band fitted with two silver chains | ||
Item:Simple white gold band | ||
Item:Smoky quartz jar with a leaf-shaped malachite stopper | ||
Item:Square intarsia pendant with an abstract geometric pattern | ||
Item:Striated malachite necklace with a carved amber sana'ati tree pendant | ||
Item:Sur'nidrel | ||
Item:Tailband (2) | ||
Item:Tansil | ||
Item:Teardrop earring | ||
Item:Warding beads | ||
Item:Wide bronze earcuff hung with strands of malachite oak leaves | ||
Item:Jade mortar inlaid with a malachite dragon with flame opal eyes | Order of the White Rose/Gifts and prizes | true |
Weapon:Jagged-edged flint dagger with a leather-wrapped hilt | Pointed Ramarck's | |
Item:Jangling golden hip-chain set with carved ivory roses | Tryllm's Wagon (1) , Rusty Barnacle, River Dreamer, Marsh Skipper | |
Item:Large walrus hide case dyed a rich ebony hue | Corik's Secret: Treasures of the Tomb/End loot | |
Item:Lovely handbag with a liquid silver sheen visible under a streaked jaspe overlay | Limited Treasures (1) | |
Item:Malachite and ivory jar carved to resemble a water lily | Wavecrester , Tropic Night, Mermaid's Fall, Cat's Ninth Life, Blood Bane | |
Item:Malachite ball in a silver wire cage | MegaSafari 413 game prizes , Basket of colored darts | |
Item:Malachite bodhran charm hung from an ivory white silk ribbon | Marelien's Memories (2) | |
Item:Malachite four-leaf clover trimmed with gold wire | Nahja's Knickknacks (4) | true |
Item:Malachite ring inset with the weasel of Huldah | Misenseor Goods (6) , Misenseor Goods (5), Misenseor Goods (4), Misenseor Goods (3), Misenseor Goods (2), Misenseor Goods (1) | |
Item:Malachite viper's fang spellbook key | Mystical Machinations | |
Item:Malachite-faced fireplace with gilt trim | Home for the Fireplace |