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 color::rose]]
 |?Rare item
 |?Source is=Source
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
}}

Results 1 – 50 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[uses color::rose]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0296",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Uses color::rose]]

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 ON t0.smw_id=t1.s_id
WHERE
(
   (t1.o_hash='rose') AND t1.p_id=2021248)
  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
0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, p_id, o_hash, s_id_2	p_id	262	const, const	363		Using index condition; 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:2
Query-Depth:1

Errors and Warnings

None

	Rare item	Source
Ammolite dolphin icon affixed to a base of Imperial coral	true	Taisidon Mystery 446/A'baya Esplanade Taisidon Mystery 443/A'baya Esplanade Taisidon Mystery 439/A'baya Esplanade Taisidon Mystery 435/A'baya Esplanade
Antique rosewood canopy bed		Dragon's Horde
Armbands		Brigetta's Tanned Goods (obsolete)
Armor		Brigetta's Tanned Goods (obsolete)
Armor:Armbands
Armor:Armor
Armor:Blued chain coif crested with a fire-gilded king snake circlet
Armor:Breastplate
Armor:Brigandine
Armor:Helm
Armor:Leathers (1)
Armor:Legbands (1)
Armor:Neckguard
Armor:Pair of finely crafted plate gauntlets with dangling onyx pig charms
Armor:Tasset
Armor:Vest
Array of sungold sunbursts		Given By The Sun
Austere love token band formed from sungold		Given By The Sun
Backpack		Zerek's General Store Marachek's General Store Dokker's Workshop Brigetta's Tanned Goods (obsolete) Bayanzi Gherkrish and Sons Ahnglor's General Store
Backtube		Zerek's General Store Brigetta's Tanned Goods (obsolete)
Bandana		Brigetta's Tanned Goods (obsolete)
Beaded strands of intricately carved Imperial coral		Tildi's Flowers (7)
Bejeweled green gold shalyria vines looped into delicate spirals		Tildi's Blooms (2) Tildi's Blooms (1)
Belt (2)		Brigetta's Tanned Goods (obsolete)
Blob made from sparkly spun glitter ribbons		Tildi's Blooms (4) Tildi's Blooms (3) Tildi's Blooms (2)
Blued chain coif crested with a fire-gilded king snake circlet		Edword's Accoutrements (1)
Boots (1)		Brigetta's Tanned Goods (obsolete)
Braided golden thumb ring inlaid with a silver seven-pointed star
Braided tri-gold wedding ring set with an amaranth Eu's promise crystal		Graimairo Wares (5) Graimairo Wares (4) Graimairo Wares (3)
Breastplate		Brigetta's Tanned Goods (obsolete)
Brigandine		Raven's Mask and Leatherworks Brigetta's Tanned Goods (obsolete)
Brightwork greatsword scabbard with a fire-gilded king snake wrapped down its length		Edword's Accoutrements (4) Edword's Accoutrements (2) Edword's Accoutrements (1)
Burnished eye mask composed of sungold		Given By The Sun
Carved rose quartz earrings		Trader Shop (Muspar'i) Trader Shop (Crossing)
Carved rose quartz jar		Inner Beauty
Chainmail mesh anklet constructed from sungold		Given By The Sun
Channel-quilted rose suede tunic cut to hug the figure		Women at Arms Annex (3) Women at Arms Annex (2) Women at Arms (2)
Charming tapestry carpetbag patterned with sprawling cabbage roses		Return to the Keep 423/Supply Wagon
Chunky rose gold ring formed by a mermaid grasping her own tail	true	Drogor Shrine
Clinging ivory farandine gown with a rose marquisette bodice		Damsel In This Dress (2)
Cloak (2)		Brigetta's Tanned Goods (obsolete)
Cloak adorned in three bejeweled moons surrounded by diamond shards		Weather Beaters (2) Weather Beaters (1)
Cloak adorned with an enraged dragon breathing flames of blood-red rubies		Weather Beaters (2) Weather Beaters (1)
Cloak appliqued with the image of a blazing forge		Weather Beaters (2) Weather Beaters (1)
Cloak clasped with a fiercely clawed lion's paw carved from ivory		Weather Beaters (2) Weather Beaters (1)
Cloak covered in an overlapping pattern of shaded silk leaves		Weather Beaters (2) Weather Beaters (1)
Cloak depicting a proud unicorn standing in a field of jadice flowers		Weather Beaters (2) Weather Beaters (1)
Cloak enhanced by a jeweled caravan perched on a pile of platinum coins		Weather Beaters (2) Weather Beaters (1)
Cloak trimmed in a border of jeweled musical notes		Weather Beaters (2) Weather Beaters (1)
Cloak with a clasp		Sew It Seems (2) Sew It Seems (1)

Semantic search

Query log

Navigation menu

Search