Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Uses material::Thornweave]]
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=432420)
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=432420)
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 | 97 | 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:Cobalt blue thornweave backpack with silver embossed straps | Hero to Go (4) | true |
Item:Crimson silk shirt with a standing collar patterned in thornweave | Hollow Eve Festival 436/Raffles | |
Item:Dark brown thornweave kimono embroidered with a stalking tiger | Raw Silk (2) , Raw Silk (1) | true |
Item:Dark green thornweave apron with deep pockets | Garden of Plenty | true |
Item:Dark slippers with tall heels of amethyst and platinum | Natural Beauty (1) | |
Item:Dark thornweave bag with a pure white alerce skull clasp | Hollow Eve Festival 414/Auction | |
Item:Dark thornweave hat with a wide brim accented by a preserved black rose | Turialo's Haven (8) | |
Item:Dark thornweave waistcoat with a lined jaspe back | Gear Shop (3) | |
Item:Deep green thornweave pouch | Sketchy By Design (7) | |
Item:Dramatically full-skirted sanguine thornweave gown tessellated with black ravens | Limited Treasures (1) | |
Item:Dusky thornweave pack | Kasine's Gauntlet | |
Item:Ebon thornweave caftan with flared sleeves | Huldah Shrine prizes 421 , Huldah Shrine prizes 410 | |
Item:Elaborate thornweave belt dyed in midnight hues of black and purple | Turialo's Haven (8) | |
Item:Enveloping shroud of dark thornweave | Hollow Eve Festival 425/Raffles | |
Item:Exquisite lilac silveress court gown accented with plum brocade ribbons | Damsel In This Dress (3) | |
Item:Flowing floor-length gown made of dark red thornweave | Dark Dalliance (2) | true |
Item:Flowing twilight-hued shroud trailing tattered remnants of pallid wildlace | Tildi's Blooms (4) , Item:Abyssal black bag webbed in fragile silver-tinged wildlace | |
Item:Formal-cut black thornweave jacket with niello buttons | Kilt From Scratch | true |
Item:Gloomy black tea towel netted witih spidersilk filaments | Tea For Tamsine (3) , Tea For Tamsine (2) | |
Item:High-collared thornweave cotehardie embellished by a spray of mournblooms | Limited Treasures (3) | |
Item:Hollow Eve 439 gift | Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439 | true |
Item:Ink-hued thornweave corset possessing scintillating semi-sheer bloodlace panels | Limited Treasures (6) | true |
Item:Inky thornweave rucksack debossed with a luminous blued moonsilver dragon | Limited Treasures (4) | |
Item:Ebon thornweave caftan with flared sleeves | ||
Item:Lavishly embroidered deep blackberry thornweave ballgown | ||
Item:Pale green jaalmin ballgown whimsically layered over magnolia white thornweave | ||
Item:Refined sheath dress of claret cire with a long trailing skirt | ||
Item:Somber onyx-hued mourning gown sparsely adorned with darkstone and jet | ||
Item:Strapless gown of translucent Albarian lace over twilight thornweave | ||
Item:Violet thornweave houppelande overlaid with white marquisette | ||
Item:Jet-black thornweave skirt adorned with dangling night diamonds | Dark Dalliance (2) | true |
Item:Large shrike's bounty blossom fashioned from richly hued thornweave | Tildi's Blooms (3) , Tildi's Blooms (2), Tildi's Blooms (1) | |
Item:Lavishly embroidered deep blackberry thornweave ballgown | Natural Beauty (1) | |
Item:Length of pale gold thornweave | ||
Item:Length of tan thornweave fabric | Sindah's Silk Sensations (3) | |
Item:Length of thornweave fabric | Hollow Eve Festival 410/Raffles , Boggle Blast (3), Boggle Blast (2) | |
Item:Length of wine-dark thornweave embroidered with iridescent rainbow roses | 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, Sleeping Dragon Corn Maze 432/Incidental loot | true |
Item:Lush midnight-toned thornweave cloak with a shrike's eye sapphire clasp | Limited Treasures (3) | |
Item:Maroon thornweave cloak with a platinum clasp | In The Snow (3) | true |
Item:Matte black thornweave cloak with heavy like-tone embroidery along the hem | Male Persuasion (3) , Male Persuasion (2) | |
Item:Matte charcoal saddle blanket composed of thornweave | Limited Treasures (3) , Item:Ice-veined leather saddlebag clasped with silversteel | |
Item:Midnight-black thornweave crafting satchel clasped with a Dwarven iron hammer | Which Craft (2) | |
Item:Midnight-blue thornweave wallet edged in silver stitching | Hollow Eve Festival 439/Raffles | |
Item:Midnight-toned thornweave trousers with brushed silver buttons | Limited Treasures (3) | |
Item:Miniature harlequin partially transmuted into a grotesque atramentous crow | Item:Spacious flat-top travel trunk plastered with numerous faded sideshow posters , Limited Treasures (1) | |
Item:Mist grey thornweave waistcoat with tel'athi toggles | Finer Things (4) , Finer Things (3) | |
Item:Moss green thornweave khandur closed by sungold-capped toggles | Limited Treasures (2) | |
Item:Mossy green thornweave bodice edged with copper-infused Gnomish kochos | Limited Treasures (5) | |
Item:Night black thornweave pouch clasped with a darkstone shrike | Sketchy By Design (7) | |
Item:Night-black thornweave rosette embroidered with a scarlet shrike's bounty blossom |