Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is 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: [[ItemID::+]]
 |?ItemID
 |?Weight
 |?ItemType=Type
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=Item Name
 |searchlabel=Uh oh. Looks like we reached maximum capacity of this query. Contact site admin to fix.
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[ItemID::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0268",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[ItemID::+]]

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.p_id='771')
  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, s_id_2, p_id	p_id	4	const	862	100.00	Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	k24628_mediawiki_1.t1.s_id	1	50.01	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:1

Errors and Warnings

None

Item Name	ItemID	Weight	Type
Arcane Mold	87	3	Resource
Artificer Apron	a119	60	Cape
Artificer Apron Part	k127	10	Piece of Equipment
Artificer Apron Recipe	r127	10	Recipe (Item)
Artisan Frame	30	3	Resource
Artisan Mold	38	3	Resource
Ash Rosemary	53	1	Resource
Assagane	78	1	Resource
Assassin Vine	63	1	Resource
Assault Cape	a100	50	Cape
Assault Cape Part	k100	10	Piece of Equipment
Assault Cape Recipe	r100	10	Recipe (Item)
Astrulic	65	1	Resource
Azure Stabilizer	p32	1	Consumable
Azure murky potion	tw2		Consumable
Ball (8ball)	??		Misc
Ball (Baseball)	??		Misc
Ball (Basketball)	??		Misc
Ball (Cookie)	??		Misc
Ball (Fish Cake)	??		Misc
Ball (Soccerball)	??		Misc
Ball (Tennisball)	??		Misc
Bard's Cape	a41	10	Cape
Bat	h18		Misc
Bat Beast	h39		Misc
Battle Knife	w14	180	Weapon
Bauxite	11	2	Resource
Bitter Meat	f10		Resource
Black Arbalest	w115		Weapon
Black Arbalest part	k162		Piece of Equipment
Black Arbalest recipe	r164		Recipe (Item)
Black Morningstar	w98	220	Weapon
Black Morningstar Part	k98	10	Piece of Equipment
Black Morningstar Recipe	r98	10	Recipe (Item)
Blacksmith Frame	29	3	Resource
Blacksmith Mold	37	3	Resource
Blank Valentine Card	bvc		Misc
Blank Valentine Silver Card	bvcs		Consumable
Blessed Cloak	a73	30	Cape
Blessed Cloak Part	k61	10	Piece of Equipment
Blessed Cloak Recipe	r61	10	Recipe (Item)
Blood	h17		Misc
Blood Fiend	h34		Misc
Blue trap	tr5		Misc
Bodkin Arrow	522	0	Consumable
Bodkin Arrows Pack	523	10	Misc
Bone	04	1	Resource
Bone (Halloween 2023)	h19		Misc
Bone Club	w24	180	Weapon
Bone Powder	21	1	Resource

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Get involved

Special Pages

Tools