Semantic search

Jump to navigation Jump to search
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
Debug output SQLStore
ASK Query
[[Uses material::Goldweave]]
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=265352)
  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
  30
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3o_id5const99Using where; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4drwiki.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
ItemSource isRare item
Item:Fuzzy panda cub snuggling a crimson silk blanketFashionable Panda (2) Fashionable Panda (1)
Item:Glittery goldweave purse in the shape of an enormous seven-pointed starPuffs of Glitter (2) Puffs of Glitter (1)
Item:Glorious goldweave doughnut purse drizzled with rainbow sapphire sprinklesPuffs of Glitter (2) Puffs of Glitter (1)
Item:Goldweave and silveress jester's hat with tiny platinum bellsCarpin Capers
Item:Goldweave back scabbard with loosely hanging electrum tiesPeaceful Intentions (2)
Item:Goldweave binding ornamented by tidal bloodstone jellyfishTaisidon Mystery 446/A'baya Esplanadetrue
Item:Goldweave bliaut lined with alabaster silkKnight at the Club (2) Knight at the Club (1)true
Item:Goldweave coin purse with two silveress arm strapsExcess Baggage (2)
Item:Goldweave jacket with carved ebony buttonsReturn to the Keep 431/Incidental loottrue
Item:Goldweave jester's tunic sewn with puce and olive silk diamondsCarpin Capers
Item:Goldweave mantle with a carved sunstar jasper claspIn The Snow (3) In The Snow (2)true
Item:Goldweave phoenix with fire whirl ruby eyesDrathrok's Duskruin 442/Incidental lootDrathrok's Duskruin 448/Incidental loot Drathrok's Duskruin 446/Incidental loottrue
Item:Hollow Eve 439 giftSleeping Dragon Corn Maze 447/End loot Sleeping Dragon Corn Maze 443/End lootIcheaHollow Eve Festival 439true
Item:Holy warrior's ceremonial standard edged in lustrous goldweaveLimited Treasures (4) Item:Legionnaire's sling bag tailored from pristine white dragonartrue
Item:Intricately beaded gold reticule clasped with a sunset opalEstate Holder Charity Auction 434true
Item:Flowing black scalene gown with a baroque goldweave corseted top
Item:Goldweave back scabbard with loosely hanging electrum ties
Item:Large bolt of goldweave
Item:Lustrous goldweave dress decorated at the hems with green jade beads
Item:Shimmering tea rose ballgown draped in layers of apricot and persimmon watersilk
Item:Supple goldweave saddle blanket embroidered with a fleur-de-lis pattern
Item:Vivid goldweave houppelande with flowing bell sleeves
Item:Jaspe money bag of goldweave coins embroidered with "No Pigpockets PLEASE!"This Little Piggy (4) This Little Piggy (2)This Little Piggy (1)
Item:Large bolt of goldweaveQuest for Kanton's Dagger Item:Deep red damask backpack embroidered with an array of iridescent threadItem:Deep red damask backpack embroidered with an array of iridescent thread
Item:Large goldweave-layered croissantThis Little Piggy (4) This Little Piggy (2)This Little Piggy (1)
Item:Large wedge of goldweave cheeseRatical Retreatstrue
Item:Long goldweave mantle embroidered with gold threadIn The Snow (3)true
Item:Lustrous evening gown sheathed in imbricated gold scalesLimited Treasures (4)
Item:Lustrous goldweave clothFit to be Tied (2)true
Item:Lustrous goldweave dress decorated at the hems with green jade beadsHide and Seek
Item:Lustrous goldweave locksmith's pouch with braided ialalhe tiesDroughtman's Challenge 426/End loot
Item:Lustrous goldweave lootpouch clasped with a dragon's heart rubyPremium token raffles
Item:Luxurious goldweave and silveress turban fettered with an elaborate broochNatural Beauty (2)
Item:Midnight madun dress shirt with frilled goldweave and shireli lace cuffsLimited Treasures (1)
Item:Miniature King Galpelus figurineSiegery Shop (5)
Item:Miniature flamewood panda cub snuggling a goldweave blanketFashionable Panda (2) Fashionable Panda (1)
Item:Miniature orichalcum-framed trader shop enclosed in goldweaveKitten Emporium (3) Kitten Emporium (2)
Item:Opulent goldweave gamantang overlaid with chiffon laceHashal's Haven
Item:Opulent goldweave kimono belted with a swathe of amethyst silktreasure maptrue
Item:Opulent goldweave merchant's greatcoat with geometric embroiderytreasure maptrue
Item:Opulent goldweave wings circumscribed within a framework of platinumSkyward Boundtrue
Item:Opulent thigh bag cut from goldweaveThryntyrlz BagMaker's Yurt (4)
Item:Pair of cobalt gauze pantaloons lined with goldweaveFarhana's Island Exquisites (2) Farhana's Island Exquisites (1)
Item:Pair of delicate goldweave waiku flower barrettesTildi's Flowers (6) Tildi's Flowers (4)
Item:Pair of onyx-hide sandals with goldweave straps
Item:Plain goldweave kimono layered over a deep purple silk under-robeSumptuous Silks (4)
Item:Plumette samite skirt layered over a goldweave underskirtProud as a Peacocktrue
Item:Prim goldweave clothier's pack laden with bolts of jewel-toned Elothean silk
Item:Quilted goldweave doublet lined with crimson silkSu Helmas 444: Make Haste!/Incidental loottrue
Item:Quilted goldweave doublet lined with purple silkSleeping Dragon Corn Maze 447/Incidental loot Sleeping Dragon Corn Maze 443/Incidental lootSleeping Dragon Corn Maze 439/Incidental lootSleeping Dragon Corn Maze 436/Incidental lootSleeping Dragon Corn Maze 432/Incidental lootSleeping Dragon Corn Maze 428/Incidental loot