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: [[Category:Weapons]] [[Is combat type::Light Crossbow]]
 |?Appraised cost is
 |format=table
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |mainlabel=
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:Weapons]] [[Is combat type::Light Crossbow]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0766",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:Weapons]] [[Is combat type::Light Crossbow]]

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_fpt_inst` AS t2
INNER JOIN
`t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   ((t4.o_hash='Light Crossbow') AND t4.p_id=2021216)
  )
  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
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t3	ALL	PRIMARY				8	Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	drwiki.t3.id	95	Using index
1	SIMPLE	t4	ref\|filter	s_id, p_id, o_hash, s_id_2	s_id\|o_hash	8\|258	drwiki.t2.s_id, const	1 (0%)	Using where; Using rowid filter
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	drwiki.t2.s_id	1	Using where

Auxilliary Tables

Temporary table t3
Recursively computed hierarchy for element(s) (28288).
SELECT s_id FROM `smw_fpt_subc` WHERE o_id=28288 LIMIT 1

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

	Appraised cost is
Dark khor'vela pelletbow tessellated with a murder of eerie black crows	6,250,000 Kronars5,000,000 Lirums <br />4,510,000 Dokoras <br />6,250 LTBpoints <br />6,250 Tickets <br />6,250 Scrips <br />
Darkspine flight crossbow with a carved ophidian-capped stock	437 Kronars349.6 Lirums <br />315.339 Dokoras <br />0.437 LTBpoints <br />0.437 Tickets <br />0.437 Scrips <br />
Darkstone light crossbow with an iron-shod stock	2,312,500 Kronars1,850,000 Lirums <br />1,668,700 Dokoras <br />2,312.5 LTBpoints <br />2,312.5 Tickets <br />2,312.5 Scrips <br />
Deep black crossbow engraved with a skull and crossbones along the stock	102 Kronars81.6 Lirums <br />73.603 Dokoras <br />0.102 LTBpoints <br />0.102 Tickets <br />0.102 Scrips <br />
Deep green locust crossbow with a carved stock	75,000 Kronars60,000 Lirums <br />54,120 Dokoras <br />75 LTBpoints <br />75 Tickets <br />75 Scrips <br />
Double-strung shadowbark latchbow set with black assassin's diamonds
Double-strung spiritwood latchbow with a reinforced stock	750,000 Kronars600,000 Lirums <br />541,200 Dokoras <br />750 LTBpoints <br />750 Tickets <br />750 Scrips <br />
Double-strung spiritwood lockbow with orichalcum tips	1,275,000 Kronars1,020,000 Lirums <br />920,040 Dokoras <br />1,275 LTBpoints <br />1,275 Tickets <br />1,275 Scrips <br />
Dragonwood crossbow with a carved stock	1,406,250 Kronars1,125,000 Lirums <br />1,014,750 Dokoras <br />1,406.25 LTBpoints <br />1,406.25 Tickets <br />1,406.25 Scrips <br />
Dull black assassin's repeating crossbow	150,000 Kronars120,000 Lirums <br />108,240 Dokoras <br />150 LTBpoints <br />150 Tickets <br />150 Scrips <br />
Dusk-hued light crossbow with its limbs tipped by tiny animite nightingales
Ebonwood crossbow carved to resemble a lithe panther	12,500 Kronars10,000 Lirums <br />9,020 Dokoras <br />12.5 LTBpoints <br />12.5 Tickets <br />12.5 Scrips <br />
Ebony repeater crossbow with a silver dagger latch
Elm lockbow with a bronze mechanism	223,130 Kronars178,504 Lirums <br />161,010.608 Dokoras <br />223.13 LTBpoints <br />223.13 Tickets <br />223.13 Scrips <br />
Elothean silverwillow crossbow	7,500 Kronars6,000 Lirums <br />5,412 Dokoras <br />7.5 LTBpoints <br />7.5 Tickets <br />7.5 Scrips <br />
Enameled copper-handled crossbow	312 Kronars249.6 Lirums <br />225.139 Dokoras <br />0.312 LTBpoints <br />0.312 Tickets <br />0.312 Scrips <br />
Enameled ivory-gripped crossbow	312 Kronars249.6 Lirums <br />225.139 Dokoras <br />0.312 LTBpoints <br />0.312 Tickets <br />0.312 Scrips <br />
Finely polished haon lockbow	178,118 Kronars142,494.4 Lirums <br />128,529.949 Dokoras <br />178.118 LTBpoints <br />178.118 Tickets <br />178.118 Scrips <br />
Finely polished hoan lockbow	178,118 Kronars142,494.4 Lirums <br />128,529.949 Dokoras <br />178.118 LTBpoints <br />178.118 Tickets <br />178.118 Scrips <br />
Finivire light crossbow with haledroth mechanism	3,750 Kronars3,000 Lirums <br />2,706 Dokoras <br />3.75 LTBpoints <br />3.75 Tickets <br />3.75 Scrips <br />
Finivire light crossbow wrapped in strips of dreamweave	1,750,000 Kronars1,400,000 Lirums <br />1,262,800 Dokoras <br />1,750 LTBpoints <br />1,750 Tickets <br />1,750 Scrips <br />
Flame maple latchbow with a coyote-shaped stock	173,777 Kronars139,021.6 Lirums <br />125,397.483 Dokoras <br />173.777 LTBpoints <br />173.777 Tickets <br />173.777 Scrips <br />
Flame maple latchbow with a ram-shaped stock	173,777 Kronars139,021.6 Lirums <br />125,397.483 Dokoras <br />173.777 LTBpoints <br />173.777 Tickets <br />173.777 Scrips <br />
Flame maple latchbow with a wolf-shaped stock	173,768 Kronars139,014.4 Lirums <br />125,390.989 Dokoras <br />173.768 LTBpoints <br />173.768 Tickets <br />173.768 Scrips <br />
Forester's crossbow	52,500 Kronars42,000 Lirums <br />37,884 Dokoras <br />52.5 LTBpoints <br />52.5 Tickets <br />52.5 Scrips <br />
Gloomwood steppe crossbow with a steel prod	150,000 Kronars120,000 Lirums <br />108,240 Dokoras <br />150 LTBpoints <br />150 Tickets <br />150 Scrips <br />
Gracefully curved lirisan pelletbow tipped with Taisidon emeralds	1,437,500 Kronars1,150,000 Lirums <br />1,037,300 Dokoras <br />1,437.5 LTBpoints <br />1,437.5 Tickets <br />1,437.5 Scrips <br />
Hemlock sniper's crossbow wrapped in shadow-hued silks	333,087 Kronars266,469.6 Lirums <br />240,355.579 Dokoras <br />333.087 LTBpoints <br />333.087 Tickets <br />333.087 Scrips <br />
Hhr'ibu	312 Kronars249.6 Lirums <br />225.139 Dokoras <br />0.312 LTBpoints <br />0.312 Tickets <br />0.312 Scrips <br />
Hhr'ibu engraved with a darkened knotwork maze of cobras and kingsnakes along the stock	312 Kronars249.6 Lirums <br />225.139 Dokoras <br />0.312 LTBpoints <br />0.312 Tickets <br />0.312 Scrips <br />
Hickory crossbow with a steel prod
Hickory light crossbow scorched with the image of a dancing welkin
Highly polished crossbow accented with ivory teeth tipped in gold (1)	20,025 Kronars16,020 Lirums <br />14,450.04 Dokoras <br />20.025 LTBpoints <br />20.025 Tickets <br />20.025 Scrips <br />
Highly polished crossbow accented with ivory teeth tipped in gold (2)	81,250 Kronars65,000 Lirums <br />58,630 Dokoras <br />81.25 LTBpoints <br />81.25 Tickets <br />81.25 Scrips <br />
Horn-limbed sturdy stonebow inlaid with a drunken ram along its oaken tiller
Hunter's crossbow dyed a deep forest green
Hunter's crossbow with a pearl-inlaid stock	143,750 Kronars115,000 Lirums <br />103,730 Dokoras <br />143.75 LTBpoints <br />143.75 Tickets <br />143.75 Scrips <br />
Iron-gripped mahogany crossbow with an oxen-horn prod	12,500 Kronars10,000 Lirums <br />9,020 Dokoras <br />12.5 LTBpoints <br />12.5 Tickets <br />12.5 Scrips <br />
Ironwood crossbow with ivory endtips	61,687 Kronars49,349.6 Lirums <br />44,513.339 Dokoras <br />61.687 LTBpoints <br />61.687 Tickets <br />61.687 Scrips <br />
Ironwood crossbow with steel fittings
Ivory-inlaid crossbow	24,968 Kronars19,974.4 Lirums <br />18,016.909 Dokoras <br />24.968 LTBpoints <br />24.968 Tickets <br />24.968 Scrips <br />
Ke'nag pelletbow with several notches carved along the stock	166,231 Kronars132,984.8 Lirums <br />119,952.29 Dokoras <br />166.231 LTBpoints <br />166.231 Tickets <br />166.231 Scrips <br />
Korograth-hide slingbow with dragonwood handles	4,125,000 Kronars3,300,000 Lirums <br />2,976,600 Dokoras <br />4,125 LTBpoints <br />4,125 Tickets <br />4,125 Scrips <br />
Laminated oak and horn crossbow with a blued steel cranequin	18,750 Kronars15,000 Lirums <br />13,530 Dokoras <br />18.75 LTBpoints <br />18.75 Tickets <br />18.75 Scrips <br />
Lavish cloudbark crossbow pave-set with Dalterein diamonds
Layered tei'oloh crossbow with a silk-wrapped ebony stock
Layered tei'oloh crossbow with a silk-wrapped witchclaw stock	653,950 Kronars523,160 Lirums <br />471,890.32 Dokoras <br />653.95 LTBpoints <br />653.95 Tickets <br />653.95 Scrips <br />
Lever-drawn light crossbow	650 Kronars520 Lirums <br />469.04 Dokoras <br />0.65 LTBpoints <br />0.65 Tickets <br />0.65 Scrips <br />
Lifesculpted shadowbark pelletbow wrought as a razor-fanged dungeon rat	5,000,000 Kronars4,000,000 Lirums <br />3,608,000 Dokoras <br />5,000 LTBpoints <br />5,000 Tickets <br />5,000 Scrips <br />
Light crossbow	312 Kronars249.6 Lirums <br />225.139 Dokoras <br />0.312 LTBpoints <br />0.312 Tickets <br />0.312 Scrips <br />

Semantic search

Query log

Navigation menu

Search