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: <q> <q>[[Uses symbol::Dragonfire amber]]</q>  OR  <q>[[Uses material::Dragonfire amber]]</q> </q>
 |?Source is
 |?Rarity is
 |format=table
 |limit=50
 |offset=10
 |sort=
 |order=asc
 |mainlabel=Item
 |default=None yet
 |sep=,&nbsp;
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "<q> <q>[[Uses symbol::Dragonfire amber]]<\/q>  OR  <q>[[Uses material::Dragonfire amber]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0233",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses symbol::Dragonfire amber]] OR [[Uses material::Dragonfire amber]]

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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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	ALL	PRIMARY				41		Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.id	1		Using where

Auxilliary Tables

Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 INNER JOIN `t3` AS t3 ON t2.p_id=t3.id WHERE (t2.o_hash='Dragonfire amber')
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_wikipage` AS t4 WHERE t4.p_id=2021246 AND t4.o_id=188157
Temporary table t3
Recursively computed hierarchy for element(s) (2021227).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021227 LIMIT 1

Query Metrics

Query-Size:4
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rarity is
Gold-inlaid sword tied with a cascading black scarf	Dark Defenders (2)
Gold-veined black marble fireplace with frosted glass doors	Grate Expectations
Gorgeous dragonwood torque fitted with large segments of dragonfire amber	Tildi's Blooms (4)
Item:Barbaric adderwood circlet deeply inset with dragonfire amber whorls
Item:Clear glass dome sheltering a Queen-of-the-night lily sculpted from dragonfire amber
Item:Dragonfire amber engagement ring with a delicate platinum inlay
Item:Platinum wedding ring set with smooth dragonfire amber
Item:Regal dragonfire amber wedding band inset with azure diamonds
Item:Set of lavishly carved dragonfire amber combs
Item:Severely pointed dragonwood torque inset with dragonfire amber slashes
Item:Smooth dragonwood ring wound with a thin strand of dragonfire amber
Item:Twisting adderwood tailband inset with dragonfire amber markings
Jagged-edged bastard sword with a smooth dragonfire amber pommel	Wyrmtongue's Wares, Wyrmtongue's Wares
Jewelry pest	Mishli , Hollow Eve Festival 447	gift
Light throwing axe with a dragonfire amber on the pommel	Sleeping Dragon Corn Maze 447/End loot , Aesthene's Close 449/End Loot	end loot
Necklace holding a complex dragonfire amber and rose gold pendant	Bacon Man's Birthday Bash 419/Pig Maze
Opulent gold tankard set with dragonfire amber cabochon	Taisidon Safari 420 Game Prizes , Deluxe Safari 417 Game Prizes
Platinum wedding ring set with smooth dragonfire amber	Wyrmtongue's Wares, Wyrmtongue's Wares
Regal dragonfire amber wedding band inset with azure diamonds	Wyrmtongue's Wares, Wyrmtongue's Wares
Scale-embossed leather mask set with dragonfire amber	Sleeping Dragon Corn Maze 425/End loot , Sleeping Dragon Corn Maze 421/End loot
Set of lavishly carved dragonfire amber combs	Sumptuous Silks (3) , Sumptuous Silks (2)
Severely pointed dragonwood torque inset with dragonfire amber slashes	Wyrmtongue's Wares, Wyrmtongue's Wares
Smooth dragonwood ring wound with a thin strand of dragonfire amber	Wyrmtongue's Wares, Wyrmtongue's Wares
Sparkling black crystal flask with a dragonfire amber stopper	Droughtman's Challenge 444/Incidental loot , Droughtman's Challenge 441/Incidental loot, Droughtman's Challenge 437/Incidental loot
Tall pair of dragonfire amber icesilk knee boots side-buckled with Elven gold	Limited Treasures (1)
Twisting adderwood tailband inset with dragonfire amber markings	Wyrmtongue's Wares, Wyrmtongue's Wares
Vibrant array of silk snapdragons embellished with dragonfire amber	Fashionable Panda (1)
Weapon:Blued-steel sabre with a carved dragonfire amber pommel
Weapon:Jagged-edged bastard sword with a smooth dragonfire amber pommel
Wide dragonwood armband interlaced with dragonfire amber	Finer Things (4) , Finer Things (3)
Wide platinum wristcuff set with a dragonfire amber

Semantic search

Query log

Navigation menu

Search