Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Uses symbol::welkin]]
 |?Source is
 |?Rare item
 |format=table
 |limit=50
 |offset=10
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

Results 11 – 60 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Uses symbol::welkin]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0353",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::welkin]]

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_blob` AS t1
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
(
   (t1.o_hash='welkin')
  )
  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	Extra
1	SIMPLE	t2	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, p_id, o_hash, s_id_2	p_id	262	drwiki.t2.id, const	10	Using index condition
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 t2
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item
Bronze armband inlaid with a cambrinth avatar	Entrail Toss Arena (3) , Entrail Toss Arena (2), Entrail Toss Arena (1)	true
Bronze ritual drum	Drones and Drums
Cambrinth ankle cuff inlaid with black onyx welkins to spell DIVYAUSH	Forever Faithful (2) , Forever Faithful (1)
Cambrinth welkin armband	Mottled Metal
Carved brick hearth	Noble's Barn
Carved silverwood egg painted in gold leaf	Diamond Deities (3) , Diamond Deities (2), Diamond Deities (1)
Carved welkin-shaped ocarina	MegaSafari 413 game prizes , Hollow Eve Festival 439/Darkbox, Hollow Eve Festival 436/Darkbox, Basket of colored darts
Cerulean blue libation caddy with an embroidered flap	Edword's Accoutrements (4) , Edword's Accoutrements (3)
Clouded glass armband strung with a constellation of tiny stars	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Copper cowbell with a mischievous welkin handle	Joys of Noise (6)
Crimson libation caddy with an embroidered flap	Edword's Accoutrements (2)
Crystal-dusted cambrinth orb etched with the image of a dapper welkin at play	Bunglefoot's Tent (2) , Bunglefoot's Tent (1)	true
Dancing welkin pinata	In The Hollow (2)
Dark gold libation caddy with an embroidered flap	Edword's Accoutrements (2)
Diminutive platinum welkin amulet suspended from a heavy chain	Amulets by Liathe (3) , Amulets by Liathe (1)
Dusty blue libation caddy with an embroidered flap	Edword's Accoutrements (2)
Elaborate brocade clergy stole with various avatars hidden in the raised pattern	Bunglefoot's Tent (2) , Bunglefoot's Tent (1)	true
Elegantly carved necklace formed from interlocking crystal cubes	Magma Falls Mini-Festival Auction	true
Engraved tyrium ball-peen hammer accented with a leather-wrapped handle	Item:Polished haralun toolbox set with a simple gold lock , Item:Polished haralun toolbox set with a simple gold lock, Hollow Eve Festival 403/Auction, Guildfest 401/Auction	true
Faded canvas pack with a circular cambrinth emblem	Quest for Kanton's Dagger
Flowing gold skirt with rich embroidery	Trader Shop (Crossing)
Fuzzy silvery pajamas with feet	Sleepwalkers (4)
Glossy walnut gavel banded with etched brass	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Gold medallion symbolizing dedication to Kertigen	Tending the Fold (2) , Tending the Fold (1), Festival Pavilion (2), Festival Pavilion (1)
Golden scabbard decorated with braided black ties	Peaceful Intentions (2) , Peaceful Intentions (1)
Green muracite chisels stamped with a welkin	Tool as a Cucumber
Green muracite wood shaper stamped with a welkin	Tool as a Cucumber	true
Green-stained walnut bowl with carved handles	Tool as a Cucumber	true
Heavy red leather boots clasped with dull cambrinth buckles	Custorian's Creations (3) , Custorian's Creations (2)
Heavy wool cloak secured with a silver welkin-shaped clasp	Order of the White Rose/Gifts and prizes
Hickory light crossbow scorched with the image of a dancing welkin	Visions of Holiness (3)
Hollow Eve 439 gift	Sleeping Dragon Corn Maze 447/End loot , Sleeping Dragon Corn Maze 443/End loot, Ichea, Hollow Eve Festival 439	true
Holly pilgrim's badge painted with a merry welkin
Hunter green libation caddy with an embroidered flap	Edword's Accoutrements (2)
Icesteel forging hammer stamped with a grinning welkin	More Tool You	true
Illuminated prayer parchment	Nakuge's Scriptorium
Intricately embroidered robe of flowing nightsilk	Divinely Dressed
Item:Aged cherrywood humidor trimmed with a thin golden band
Item:Animal skeleton
Item:Anloral welkin pin
Item:Articulated platinum handfasting cord adorned with sparkling diamond and onyx beads
Item:Brilliant cerulean prayer rug emblazoned with a stately welkin working over a forge
Item:Bronze armband inlaid with a cambrinth avatar
Item:Bronze ritual drum
Item:Cambrinth ankle cuff inlaid with black onyx welkins to spell DIVYAUSH
Item:Cambrinth welkin armband
Item:Carved brick hearth
Item:Carved silverwood egg painted in gold leaf
Item:Cerulean blue libation caddy with an embroidered flap
Item:Crystal-dusted cambrinth orb etched with the image of a dapper welkin at play

Semantic search

Query log

Navigation menu

Search