Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Star sapphire]]
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=80182)
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=80182)
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_3 | 9 | const, const | 53 | 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
None| Item | Source is | Rare item |
|---|---|---|
| Item:Elegant silver circlet crested with a triangular star sapphire | Wolf cart | |
| Item:Gold and black star sapphire livery collar displaying a soulstone Imperial star | Merit Badges (4) , Merit Badges (3), Merit Badges (2) | true |
| Item:Gold neithrel band embellished with sapphires | Marelien's Memories (2) , Marelien's Memories (1), All Things Bardic (2), All Things Bardic (1) | |
| Weapon:Gold-hilted hunting sword set with a multi-faceted star sapphire pommelstone | Vishlan's Wares (Crossing), Vishlan's Wares (Crossing) | |
| Weapon:Inlaid battle axe with a felwood handle | Droughtman's Challenge 426/End loot | |
| Item:Blue star sapphire ring | ||
| Item:Burnished gold headpiece accented by cascading ocean-blue sapphires | ||
| Item:Carved crystal pick set with a star sapphire | ||
| Item:Delicate platinum circlet inlaid with golden filigree and set with a single star sapphire | ||
| Item:Gold neithrel band embellished with sapphires | ||
| Item:Oval black star sapphire | ||
| Item:Pair of hammered silver wristcuffs set with star sapphires in a wheel pattern | ||
| Item:Silver neithrel band embellished with sapphires | ||
| Item:Silver spiral pendant hung with a deep blue star sapphire teardrop | ||
| Item:Smoky grey nightweaver silk handbag clasped with a single star sapphire | ||
| Item:Snowflake-shaped sapphire pendant | ||
| Item:Twisted gold and silver necklace accented with star sapphires | ||
| Item:White gold pendant with an etched star sapphire set into a mirrored backing | ||
| Item:Masterfully crafted blued-steel hairpin weighted with darkened star sapphires | Allurana's Allures | |
| Item:Miniature cambrinth faenellica suspended from a twisted silver chain | Thaumaturgic Things (2) , Thaumaturgic Things (1) | |
| Item:Oval black star sapphire | Fallen Angels Clothing (2) , Drathrok's Duskruin 446/Incidental loot, Drathrok's Duskruin 442/Incidental loot, Drathrok's Duskruin 438/Incidental loot, Drathrok's Duskruin 435/Incidental loot, Drathrok's Duskruin 430/Incidental loot, Drathrok's Duskruin 426/Incidental loot | |
| Item:Pair of hammered silver wristcuffs set with star sapphires in a wheel pattern | Obscure Origins | |
| Item:Sanguine thealstone Bloodworm comet haloed in star sapphires | Limited Treasures (5) | |
| Item:Set of shiny silver spoons spangled with star sapphires and scarlet spinels | ||
| Item:Silver neithrel band embellished with sapphires | Marelien's Memories (2) , Marelien's Memories (1), All Things Bardic (2), All Things Bardic (1) | |
| Item:Silver spiral pendant hung with a deep blue star sapphire teardrop | Marelien's Memories (2) , Marelien's Memories (1) | |
| Silver tunic pin embellished with a tear-shaped star sapphire | ||
| Item:Silver-veined black marble mortar shaped like a panther | On the Mend (1) , Item:Midnight-black silk alchemist's kit clasped by a silver panther | true |
| Item:Silver-veined black marble pestle inset with a dark star sapphire teardrop | On the Mend (1) , Item:Midnight-black silk alchemist's kit clasped by a silver panther | true |
| Item:Simple silver choker set with an azure star sapphire | Item:Layered glass jewelry box with silver filigree fittings | |
| Item:Slender circlet of silver filigree set with an azure star sapphire | Item:Layered glass jewelry box with silver filigree fittings | |
| Item:Small gath mysanda cut from star sapphire | Hollow Eve Festival 443/Raffles | true |
| Item:Smoky grey nightweaver silk handbag clasped with a single star sapphire | Handsome Handbags | |
| Item:Snowflake-shaped sapphire pendant | Auction Tent - Ice Festival | true |
| Item:Snowflake-shaped silver pendant | Hollow Eve Festival 414/Raffles | |
| Item:Striking deep turquoise velvet choker with a trailing lace fringe | Damsel In This Dress (5) , Damsel In This Dress (3) | |
| Item:Sturdy iron forging hammer with a six-rayed star sapphire cabochon on its hilt | Hollow Eve Festival 417/Raffles | true |
| Item:Twisted gold and silver necklace accented with star sapphires | Desert Jewels, Desert Jewels | |
| Weapon:Antique swept-hilt rapier | ||
| Weapon:Bastard sword of mirror-finished steel with a star sapphire pommel | ||
| Weapon:Gold-hilted hunting sword set with a multi-faceted star sapphire pommelstone | ||
| Item:White gold pendant with an etched star sapphire set into a mirrored backing | House of the Floating Reed (shop) | |
| Item:Wide silver ring inlaid with alternating square-cut gems | Turialo's Haven (8) , Turialo's Haven (4), Turialo's Haven (2) |