Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Heartstring lace||Heartstring]]
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
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246)
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
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=2021246)
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 | t3 | ALL | PRIMARY | 2 | Using temporary; Using filesort | ||||
1 | SIMPLE | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id_2 | 5 | drwiki.t3.id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t1.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (1028097)
INSERT IGNORE INTO `t3` (id) VALUES (1325301)
Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NoneItem | Source is | Rare item |
---|---|---|
Item:Frilly heartstring lace garter buckled with a honeycomb opal | Aesthene's Close 441/Vault, Aesthene's Close 449/End Loot , Aesthene's Close 445/Vault | true |
Item:Gigantic taffelberry-black tart bag with heartstring lace panels | Limited Treasures (5) | |
Item:Glossy glitvire footbrush with a heartstring-lace wrapped handle | Limited Treasures (4) , Item:Intricately woven berry picking basket with polished glitvire handles | |
Item:Knee-length trousers belted by a single cord of heartstring lace | Smaller Side of Life (3) | |
Item:Large heartstring lace skunk with wide-set aurora opal eyes | Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot, Droughtman's Challenge 433/Incidental loot, Droughtman's Challenge 430/Incidental loot | |
Item:Lilac heartstring lace ball strung with tiny silver bells | Ratical Retreats | |
Item:Petite shoulder tote embroidered with a large daisy | Smaller Side of Life (3) | |
Item:Picnic basket lined with silk | Sleeping Dragon Corn Maze 436/Incidental loot | |
Item:Ribbon-stripe dining table elegantly draped with a heartstring lace tablecloth | Exquisite Treasures | true |
Item:Short-sleeved white cotton shirt with silver-infused Gnomish kocho toggles | Smaller Side of Life (3) | |
Item:Smokewood picnic basket trimmed with heartstring lace | Item:Smokewood picnic basket trimmed with heartstring lace , Sleeping Dragon Corn Maze 447/Incidental loot, Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot | |
Item:Sparkly periwinkle ballgown with an outrageously full skirt | All That Glitters | true |
Item:Strip of heartstring lace | Finest Box of Gems (2) , Finest Box of Gems (1) | |
Item:Whimsical gold jaspe sundress trimmed with heartstring lace | Damsel In This Dress (5), Damsel In This Dress (5) | |
Item:White petalette knee socks trimmed with heartstring lace | Limited Treasures (3) , Item:Fetching cobalt turbaurs dirndl with intricate romantic ballad peony applique | |
Item:Wine-hued baldric trimmed with heartstring lace | treasure map | true |
Item:Wispy heartstring lace bridal veil dotted with stephanotis blossoms | Wedding Belles (2) , Wedding Belles (1) |