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: [[Item type is::Perfume||Cologne]]
 |?Source is
 |?Rare item
 |?Is incomplete
 |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": "[[Item type is::Perfume||Cologne]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0368",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Item type is::Perfume||Cologne]]

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
INNER JOIN
`t2` AS t2 ON t1.p_id=t2.id
INNER JOIN
`t3` AS t3 ON t1.o_id=t3.id) ON t0.smw_id=t1.s_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	Extra
1	SIMPLE	t3	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id_3	5	drwiki.t3.id	1
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t1.s_id	1	Using where
1	SIMPLE	t2	eq_ref	PRIMARY	PRIMARY	4	drwiki.t1.p_id	1	Distinct

Auxilliary Tables

Temporary table t2
Recursively computed hierarchy for element(s) (2021226).
SELECT s_id FROM `smw_fpt_subp` WHERE o_id=2021226 LIMIT 1
Temporary table t3
INSERT IGNORE INTO `t3` (id) VALUES (131490)
INSERT IGNORE INTO `t3` (id) VALUES (1427822)

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Item	Source is	Rare item	Is incomplete
Delicate cobalt glass flask	Tropic Night , Mermaid's Fall, Harper's Song, Cat's Ninth Life, Blood Bane, Backfence Gossip		true
Delicate perfume bottle with a peach-shaped stopper	The Parfumerie	false
Desert-rose perfume	Dahl Aeliy Provisions and Wares		true
Eluned's breath cologne	Madame Orris' Perfumerie		true
Elven crown cologne	Madame Orris' Perfumerie
Faceted glass vial tinted a mossy green hue	The Parfumerie	false
Fiery red perfume bottle covered in gold filigree	The Parfumerie	false
Forest song cologne	Madame Orris' Perfumerie		true
Glass cologne bottle fit with a spruce stopper	Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot		true
Glass perfume bottle fit with a sandalwood stopper	Sleeping Dragon Corn Maze 447/Incidental loot , Sleeping Dragon Corn Maze 443/Incidental loot, Sleeping Dragon Corn Maze 439/Incidental loot, Sleeping Dragon Corn Maze 436/Incidental loot, Sleeping Dragon Corn Maze 432/Incidental loot		true
Glazed green stoneware flask	Paper Lion , Moveable Feast, Dusktide Rising, Dark Nighttrawler		true
Golden panther perfume	Madame Orris' Perfumerie		true
Green quartz bottle	Uramih's Perfumerie		true
Hodierna's fire cologne	Madame Orris' Perfumerie		true
Iridescent glass perfume bottle capped with a shooting comet	Su Helmas 444: Make Haste!/Incidental loot , Su Helmas 440: Entrapped/Incidental loot, Su Helmas 438: The Forbidden Temple/Incidental loot, Su Helmas 434: The Forbidden Temple/Incidental loot	true
Item:Baking earth cologne			true
Item:Black quartz bottle			true
Item:Blue quartz bottle			true
Item:Brown quartz bottle			true
Item:Bubbled sapphire glass vial			true
Item:Cloudy jade glass vial			true
Item:Crackled red stoneware flask			true
Item:Delicate cobalt glass flask			true
Item:Desert spice perfume			true
Item:Desert-rose perfume			true
Item:Eluned's breath cologne			true
Item:Forest song cologne			true
Item:Glazed green stoneware flask			true
Item:Green quartz bottle			true
Item:Lavender-oil perfume			true
Item:Pink and black painted vial			true
Item:Sylvan spice perfume			true
Item:Water-lily perfume			true
Kermarian moon water	Madame Orris' Perfumerie		true
Lavender-oil perfume	Dahl Aeliy Provisions and Wares		true
Muddy brown jar painted with the image of a swamp	The Parfumerie	false
Murky black jar with a sandalwood stopper	The Parfumerie	false
Murky green vial wrapped with strips of well-oiled leather	The Parfumerie	false
Oceanic blue jar painted with the image of a galleon	The Parfumerie	false
Opalescent black vial with a charred wood stopper	The Parfumerie	false
Opalescent glass perfume bottle engraved with delicate jasmine petals	The Parfumerie	false
Opalescent perfume bottle fit with a gladiolus-shaped stopper	Return to the Keep 431/Incidental loot		true
Pale lavender perfume bottle with a taffelberry-shaped stopper	The Parfumerie	false
Pink and black painted vial	Adashjkah's Perfumes		true
Red quartz bottle	Uramih's Perfumerie		true
Silver breeze perfume	Madame Orris' Perfumerie		true
Small porcelain vial shaped like a white rose	Hollow Eve Festival 425/Raffles		true
Small vial composed of bubbled glass	The Parfumerie	false
Sweet innocence perfume	Madame Orris' Perfumerie		true
Sylvan spice perfume	Madame Orris' Perfumerie		true

Semantic search

Query log

Navigation menu

Search