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: [[Category:Clothing]]
 |?Work To Make
 |?Resource 1 Amount
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Clothing]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0277",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Clothing]]

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
`mr_smw_object_ids` AS t0
INNER JOIN
`mr_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=2865)
  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, o_id, s_id_2, o_id_2	o_id_2	5	const	56	100.00	Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	rimworld_wiki_new.t1.s_id	1	50.00	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Work To Make	Resource 1 Amount
Airwire headset	2,100	50
Array headset	2,100	50
Authority cap	1,500	25
Beret	4,000	35
Blindfold	1,200	20
Bowler hat	1,800	20
Broadwrap	1,800	30
Burka	4,000	60
Button-down shirt	2,700	45
Cape	16,000	80
Ceremonial hood	2,000	20
Coronet	8,000	50
Corset	12,000	45
Cowboy hat	1,800	25
Crown	12,000	75
Duster	10,000	80
Eltex helmet
Eltex robe
Eltex shirt
Eltex vest
Face mask	800	10
Flophat	1,200	20
Formal shirt	6,000	65
Formal vest	12,000	45
Gas mask	6,000	20
Headwrap	1,400	20
Heavy bandolier	3,500	75
Hood	6,000	50
Jacket	7,000	70
Kid pants	1,280	20
Kid parka	6,400	40
Kid romper	2,000	30
Kid shirt	1,280	20
Kid tribalwear	1,400	30
Lab coat	5,000	70
Ladies hat	6,000	50
Pants	1,600	40
Parka	8,000	80
Prestige robe	20,000	100
Psychic foil helmet
Ritual mask	3,000	25
Robe	5,000	80
Sash	1,000	25
Shadecone	1,800	25
Slave body strap	7,000	70
Slave collar	1,800	25
Slicecap	2,000	15
Stellic crown	0	85
T-shirt	1,600	40
Tailcap	1,400	20

Semantic search

Query log

Navigation menu

Search