Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses symbol::lightning]]OR[[Uses material::Lightning]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
110
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
110
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 349 | Using temporary; Using filesort | ||||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.id | 1 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='lightning')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=67850 - Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Grey hip pouch accented with storm clouds in crystal beading | Repurposed Shipments (2) , Repurposed Shipments (1), Hide and Seek | true |
Item:Hammered silver wristcuff set with a cabochon stormfire topaz | Sindah's Silk Sensations (3) , Sindah's Silk Sensations (2) | |
Item:Heavily-brocaded dark grey satin sash | Shh'oi Mhhg | |
Item:Heavy black baladrana with gold embroidery trim | Silken Seams (2) , Silken Seams (1) | |
Item:Heavy cambrinth armband (aniek) | Tieheq with the Thirteen (2) , Tieheq with the Thirteen (1) | |
Item:Heavy cambrinth armband (meraud) | Idon Abide the Ten (3) , Idon Abide the Ten (2), Idon Abide the Ten (1) | |
Weapon:Ice-blue two-headed hammer marked with silver-inlaid lightning bolts | Hollow Eve Festival 410/Auction | |
Item:Inky black Tokka deck split by a sinuous bolt of lightning | Tokka Painter's Hut | |
Item:Inky black silk prayer cloth embroidered in golden thread with a wide-eyed horned owl | Sputkin's Splendors (5) , Sputkin's Splendors (4), Sputkin's (3) | |
Item:Inky black silk robe decorated with flashes of silver embroidery | It's Elemental, It's Elemental (2) , It's Elemental | |
Item:Inscribed calavarite brooch | Museum of Imperial History | false |
Item:Anklet of interlocked lightning bolts surrounding tiny cambrinth clouds | ||
Item:Articulated gold bracer studded with cambrinth lightning bolts | ||
Item:Black and silver plaid kilt fastened by a silver lightning bolt pin | ||
Item:Black leather vest fastened with tiny silver lightning bolts | ||
Item:Black prayer mat stitched with a forked bolt of bluefire velvet lightning | ||
Item:Black prayer mat stitched with a three bolts of bluefire velvet lightning | ||
Item:Black silk cord strung with a golden bolt of forked lightning | ||
Item:Black silk cord strung with three gold lightning bolts | ||
Item:Black silk robe embroidered with an intricate pattern of silver lightning bolts and trimmed with a ruff of grey owl feathers | ||
Item:Blue-violet watersilk kimono with a rich bluefire velvet under-robe | ||
Item:Blue-violet watersilk kimono with a rich starfire velvet under-robe | ||
Item:Bouquet of Scarlet Panther lilies arranged in a flame-etched glass vase | ||
Item:Burgundy brocade gem pouch with a golden lightning bolt clasp | ||
Item:Cambrinth Meraud idol | ||
Item:Cambrinth ring etched with storm clouds and lightning bolts | ||
Item:Collarless jet batiste shirt | ||
Item:Cushion-cut stormfire topaz pendant on a slim platinum chain | ||
Item:Dark grey silk gown with jagged platinum lightning bolts dangling at the low neckline | ||
Item:Dark grey silk ribbon strung with a smoky quartz shark | ||
Item:Dark leather grooming kit closed with a silver lightning bolt | ||
Item:Darkened silver ring inlaid with bolts of cambrinth lightning | ||
Item:Deep ebony prayer tapestry embroidered with a spidery web of lightning | ||
Item:Delicate cambrinth-studded silver chain bracelet with an intricate platinum clasp | ||
Item:Ebony spidersilk pouch fastened with a silver lightning charm | ||
Item:Elaborate storm-grey dress fringed with iridescent blue lace | ||
Item:Firestained silver band intricately engraved with whorls of storm clouds | ||
Item:Flowing dark spidersilk robes with golden embroidery | ||
Item:Forging hammer with a lightning bolt shaped head | ||
Item:Gleaming gold badge etched with the phrase "The wrath of the sky is a killing bolt!" | ||
Item:Gleaming platinum badge etched with the phrase "I call forth the lightning to vanquish my foes!" | ||
Item:Glistening aquamarine shaped like a lightning bolt | ||
Item:Gold Bardic Spirit Knot hairstick engraved with lightning bolts | ||
Item:Gold Bardic Spirit Knot pendant hung from an embroidered velvet choker | ||
Item:Gold neithrel band fastened by matching lightning bolt chains | ||
Item:Golden lockpick shaped like a bolt of lightning | ||
Item:Golden wedding ring enhanced with elaborate engravings | ||
Item:Grey clay jar | ||
Item:Grey hip pouch accented with storm clouds in crystal beading | ||
Item:Heavy black baladrana with gold embroidery trim |