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: [[Material type is::gems]]
 |?Rarity is=Rarity
 |?Uses color=Color(s)
 |format=table
 |limit=50
 |offset=5
 |sort=
 |order=asc
 |mainlabel=
 |sep=,
}}

Results 6 – 55 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Material type is::gems]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0289",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Material type is::gems]]

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='gems') AND t1.p_id=2022036)
  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
5

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	370		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

	Rarity	Color(s)
Alavern	quest	blue,green
Aldamalm (gem)	quest	green
Alexandrites	common	yellow,green,yellow-green,red,purple,purple-red
Alshabi stone	quest	orange,pink
Amber	common	yellow,orange,brown,blue,gren,red,white,clear
Ambergris	rare	black,grey,brown,beige,white,silver,yellow,orange
Amethysts	common	lavender,pale violet,deep purple,purple
Ametrine	quest	purple,yellow,orange
Amlothite	auction	lime,olive,green
Andalusite	common	yellow,white,red,brown,orange,green,brown-yellow
Andradite	common	black,green,yellow-green,yellow
Anloral	rare	blue
Aoustone	quest	blue,orange
Aquamarine	common	blue,blue-green,green
Asarenjan	quest	blue
Atulave	quest	grey
Aurora opal	quest	white,pink,blue,red,orange,green
Aurora tourmaline	quest	red,orange,indigo,blue
Autumn jasper	common	red,gold
Avene	quest	pink,red
Baroque pearl	common	white,pink,peach,lavender,blue,gold,yellow,black,grey,purple
Bearclaw emerald	quest	green,silver
Beryl	common	clear,blue,green,yellow,red,black
Black assassin's diamond	auction	black,red
Black diamond	rare	black,blue,purple,red
Black opal	common	black
Black ruby	common	black,red
Blackberry miajho	quest	purple-black
Bleeding heart jade	rare	white,red
Blood ruby	quest	red,blood-red,sanguine
Bloodgem	common	brown,red,blood-red,sanguine
Bloodmist garnet	quest	red
Bloodstones	common	green,red,yellow
Blue diamond	common	blue
Blue hawkseye	quest	blue
Bumblebee jasper	quest	orange,yellow,black
Canary diamond	common	yellow
Carnelians	common	orange,red,reddish-brown,brown,black
Celeste	rare	pale blue,blue
Cerith shell	quest	brown,grey,white,green
Chakrel	quest	red,orange,white
Chalcedonies	common	clear,white,grey,greyish-blue,blue,pale brown,brown,black,red,yellow,orange,green
Champagne diamond	quest	brown
Chaos chalcedony	quest	blue,red,gold,brown
Cherry opal	quest	red
Chocolate opal	quest	brown
Chrysoberyl	common	yellow,green,clear,yellowish-green,blue,red,orange,purple
Chrysoprase	common	green,apple-green,deep green
Cinacs	quest	red,grey,white,yellow,orange
Citrines	common	yellow,brown

Semantic search

Query log

Navigation menu

Search