Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Oravir]]
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=47308)
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=47308)
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 | 128 | 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:Damite and oravir shrike charm | Guildfest 412/Auction | |
Item:Dark iron belt knife set with a small cloudstone in the pommel's center | Abandoned Dragon (2) | |
Item:Dark snakeskin boots with decorative toe caps | Knightly Attire (2) | |
Item:Dark-jeweled brooch trailing delicate platinum ribbons | Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot | |
Item:Delicate bracelet of interlocking striped seaperch | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Delicate oravir necklace embellished with an openwork pendant | Grisgonda's Gems and Jewels | |
Item:Delicate sigil folio adorned with tufts of mohair | Su Helmas 444: Make Haste!/Incidental loot | |
Item:Ebony scalene waistcoat with oravir buttons | Finer Things (4) , Finer Things (3) | |
Item:Ecosphere dangling from a braided chain | Item:Simple ecosphere | true |
Item:Exquisite haircomb twined in blossoms | Breaking and Entering/Bedroom loot | |
Item:Filigree earrings threaded with beads | Breaking and Entering/Bedroom loot | |
Item:Fine metal pins | Breaking and Entering/Work Room loot | false |
Item:Fragile blossom with delicate petals | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Frosted seaglass cowbell inlaid with sea-calves along the rim | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Gaethzen blossom with a short stem | Breaking and Entering/Sanctum loot | false |
Item:Glacial blue sheath dress with long sheer sleeves and a sharply plunging neckline | Natural Beauty (1) | |
Item:Gleaming oravir knight's chain displaying a tower-shaped soulstone | Inner Illuminations (3) | |
Template:HE2020Metals | ||
Item:Hammered toe bells in the shape of blossoms | Hollow Eve Festival 447/Game prizes , Hollow Eve Festival 443/Game prizes, Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | true |
Item:Heart-shaped filigree locket inlaid with chips | Breaking and Entering/Bedroom loot | |
Item:Heavy bracer patterned with geometric cambrinth symbols | Breaking and Entering/Sanctum loot | false |
Armor:Heavy fluted plate made from oravir-steel alloy and padded with electroweave | Conductive Contraptions | |
Item:Hollow Eve 399 gift | ||
Talk:Hollow Eve Festival 436/Game prizes | ||
Hollow Eve Festival 436/Game prizes/Material options | ||
Item:Interlocking miniature tridents | Hollow Eve Festival 443/Game prizes , Hollow Eve Festival 439/Game prizes, Hollow Eve Festival 436/Game prizes | |
Item:Iroko hautbois with oravir keys | Musiceum (3) , Musiceum (2), Musiceum (1) | |
Item:Burnished oravir flask studded with blood rubies | ||
Item:Glacial blue sheath dress with long sheer sleeves and a sharply plunging neckline | ||
Item:Hollow Eve 399 gift | ||
Item:Oravir nugget | ||
Item:Oravir prayer beads carved into miniature albatross | ||
Item:Oravir sliver | ||
Item:Oravir-bodiced gown of emerald green zerarin wool | ||
Item:Twisted oravir necklace fashioned to resemble wisteria vines | ||
Item:Jewelry pest | Mishli , Hollow Eve Festival 447 | true |
Item:Labyrinthine covellite armband adorned with oravir shards | ||
Item:Lacquered teak telescope with swirling moabi inlay | Moon Mage Conclaves | |
Armor:Lamellar hauberk made from oravir-steel alloy and secured with electroweave | Conductive Contraptions | |
Item:Large crystal prism suspended from a fine chain | Breaking and Entering/Sanctum loot | |
Weapon:Mahogany parry stick | ||
Weapon:Mechanical gladius bearing a spent ilmenite core slotted mechanism | Conductive Contraptions | |
Weapon:Mechanical greataxe bearing a spent ilmenite core slotted mechanism | Conductive Contraptions | |
Weapon:Mechanical mace bearing a spent ilmenite core slotted mechanism | Conductive Contraptions | |
Weapon:Mechanical sledgehammer bearing a spent ilmenite core slotted mechanism | Conductive Contraptions | |
Item:Metal scissors with wood handles | Breaking and Entering/Work Room loot | false |
Weapon:Miniature toy crossbow composed of wood | Breaking and Entering/Armory loot | |
Item:Narrow recipe box with hinges | Breaking and Entering/Kitchen loot | |
Item:Narrowly cut breeches of fine pale gabardine | Male Persuasion (3) , Male Persuasion (2) | |
Weapon:Oak parry stick carved with an oravir-inlaid lightning pattern | Drathrok's Duskruin 448/Incidental loot | true |