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: [[Has item property::container]] [[Worn in slot::upper arm]]
 |?Noun is=Container Type
 |?Interior length is=L
 |?Interior width is=W
 |?Interior height is=H
 |?Weight capacity is=Weight Limit
 |?Source is=Source
 |?Appraised cost is=Appraised Cost
 |format=table
 |limit=50
 |offset=100
 |sort=
 |order=asc
 |mainlabel=
}}

Results 101 – 113 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Has item property::container]] [[Worn in slot::upper arm]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1545",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Has item property::container]] [[Worn in slot::upper arm]]

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 t2
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   (t2.o_hash='container') AND t2.p_id=2021204
   AND (
   (t4.o_hash='upper arm') AND t4.p_id=2021193)
  )
  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
100

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t4	index_merge	s_id, p_id, o_hash, s_id_2	o_hash,p_id	258,262		141	Using intersect(o_hash,p_id); Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t4.s_id	1	Using where
1	SIMPLE	t2	ref	s_id, p_id, o_hash, s_id_2	s_id	8	drwiki.t4.s_id, const	1	Using where; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:4
Query-Depth:1

Errors and Warnings

None

	Container Type	L	W	H	Weight Limit	Source	Appraised Cost
Thick rawhide arm pouch with claw marks down the front	pouch	2	2	2	150	Beyond the Barrier: The Devastation of Lyras/Incidental Loot	3,750 Kronars3,000 Lirums <br />2,706 Dokoras <br />3.75 LTBpoints <br />3.75 Tickets <br />3.75 Scrips <br />
Threadbare satin pouch tied with tattered ribbons	pouch	2	2	2	150	Limited Treasures (2)
Tiny black leather wrist purse with silvery silk fringe	purse	2	2	2	150	Hide and Silk (3)	27,716 Kronars22,172.8 Lirums <br />19,999.866 Dokoras <br />27.716 LTBpoints <br />27.716 Tickets <br />27.716 Scrips <br />
Tooled leather arm quiver	quiver	7	1	1	60	Shieldwright's Traveling Mercantile	4,375 Kronars3,500 Lirums <br />3,157 Dokoras <br />4.375 LTBpoints <br />4.375 Tickets <br />4.375 Scrips <br />
Verdant leather arm quiver tooled with twining vines	quiver	1	1	1	60	Jhiskar's Provisions (1)	5,000 Kronars4,000 Lirums <br />3,608 Dokoras <br />5 LTBpoints <br />5 Tickets <br />5 Scrips <br />
Weathered leather coin purse with beaded ties	purse					Beyond the Barrier: The Devastation of Lyras/End loot	187,500 Kronars150,000 Lirums <br />135,300 Dokoras <br />187.5 LTBpoints <br />187.5 Tickets <br />187.5 Scrips <br />
Wide glass armband stained to resemble slices of fresh watermelon	armband					Turialo's Haven (8)
Wide glass armband with an empty gem socket	armband					Turialo's Haven (6) Turialo's Haven (5) Turialo's Haven (3)
Wispy gossamer poke	poke	2	2	2	150	Hollow Eve Festival 410/Raffles
Withered grey faenrae reaver pelt arm pouch with braided black hair drawstrings	pouch					Performance Portage (2) Performance Portage (1)
Worn kidskin pouch	pouch	3	3	3	200	Hollow Eve Festival 410/Auction	13,750,000 Kronars11,000,000 Lirums <br />9,922,000 Dokoras <br />13,750 LTBpoints <br />13,750 Tickets <br />13,750 Scrips <br />
Worn leather arm sheath tooled with the image of a cobra wrapped around a sword	sheath	4	1	1	60	Fenwyrthie's Curio Shop	1,562 Kronars1,249.6 Lirums <br />1,127.139 Dokoras <br />1.562 LTBpoints <br />1.562 Tickets <br />1.562 Scrips <br />
Wrapped iron armband set with glittering bloodgems	armband	4	1	1	60	Hollow Eve Festival 406/Raffles	6,250 Kronars5,000 Lirums <br />4,510 Dokoras <br />6.25 LTBpoints <br />6.25 Tickets <br />6.25 Scrips <br />

Semantic search

Query log

Navigation menu

Search