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: <q>[[BoolQuest::true]] [[QuestValleyMorning::true]] OR  <q>[[QuestValleyDay::true]]</q>  OR  <q>[[QuestValleyEvening::true]]</q>  OR  <q>[[QuestValleyNight::true]]</q> </q>
 |?ItemID=ID
 |?QuestValleyMorning=Morning
 |?QuestValleyDay=Day
 |?QuestValleyEvening=Evening
 |?QuestValleyNight=Night
 |format=table
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |mainlabel=Item
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[BoolQuest::true]] [[QuestValleyMorning::true]] OR  [[QuestValleyDay::true]]<\/q>  OR  [[QuestValleyEvening::true]]<\/q>  OR  [[QuestValleyNight::true]]<\/q> <\/q>",
    "query_source": "SMWSQLStore",
    "query_time": "0.0469",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[BoolQuest::true]] [[QuestValleyMorning::true]] OR [[QuestValleyDay::true]] OR [[QuestValleyEvening::true]] OR [[QuestValleyNight::true]]

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
`t1` AS t1 ON t0.smw_id=t1.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
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ALL	PRIMARY				164	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.id	1	50.01	Using where

Auxilliary Tables

Temporary table t1
  INSERT IGNORE INTO `t1` SELECT DISTINCT t3.s_id FROM `smw_di_bool` AS t3 INNER JOIN `smw_di_bool` AS t5 ON t3.s_id=t5.s_id WHERE (t3.o_value='1') AND t3.p_id='799' AND ((t5.o_value='1') AND t5.p_id='810')
  INSERT IGNORE INTO `t1` SELECT DISTINCT t7.s_id FROM `smw_di_bool` AS t7 WHERE (t7.o_value='1') AND t7.p_id='811'
  INSERT IGNORE INTO `t1` SELECT DISTINCT t9.s_id FROM `smw_di_bool` AS t9 WHERE (t9.o_value='1') AND t9.p_id='812'
  INSERT IGNORE INTO `t1` SELECT DISTINCT t11.s_id FROM `smw_di_bool` AS t11 WHERE (t11.o_value='1') AND t11.p_id='813'

Query Metrics

Query-Size:10
Query-Depth:1

Errors and Warnings

None

Item	ID	Morning	Day	Evening	Night
Divine Shoes Recipe	r57	true	false	false	false
Doom Warglaive Part	k105		true
Doomblade Sword Recipe	r20	true	false	false	false
Dragon Seed	57	false	false	false	true
Durable Cloak Recipe	r60	true	true	true	true
Eglalica	71	true	true	true
Ephijora	47	true	true	true	false
Flammia Nut	66	true	true	true	false
Ghost Armor Recipe	r43	true	false	false	false
Ghost Boots Recipe	r45	false	false	false	true
Ghost Dagger Recipe	r31	false	false	true	false
Ghost Gloves Recipe	r46	false	true	false	false
Ghost Helmet Recipe	r44	false	false	false	true
Giant Boots Part	k136		true
Giant Gauntlets part	k137				true
Giant Shield part	k140	true
Gonitro	80				true
Griffin Armor Part	k83	false	false	true	false
Griffin Boots Part	k85	false	false	false	true
Griffin Helmet Recipe	r84	false	false	false	true
Guard's Spear Recipe	r22	true	true	true	false
Guisarme Part	k95	false	true	false	false
Guisarme Recipe	r95	true	false	false	false
Hardener	18	false	false	false	true
Heartstriker Bow Part	k108		true
Hunter Armor Recipe	r11	true	true	true	false
Hunter Boots Recipe	r13	false	false	false	true
Hunter Bow Recipe	r03	false	false	false	true
Hunter Dagger Recipe	r05	true	true	true	false
Hunter Gloves Recipe	r14	false	false	false	true
Hunter Helmet Recipe	r12	true	true	true	false
Ilaves	46	true	true	true	false
Imperial Axe Recipe	r28	true	true	true	false
Indissoluble Cloak Recipe	r126	true	false	false	false
Iron Ore	08	true	true	true	true
King's Defender Recipe	r23	false	false	true	false
Leather	20	true	true	true	false
Lightbane Katana Recipe	r104	true
Lightning Bow Recipe	r26	false	false	false	true
Lion Armor Recipe	r47	false	false	true	false
Lion Boots Recipe	r49	false	false	true	false
Lion Gloves Recipe	r50	false	false	true	false
Lion Helmet Recipe	r48	false	true	false	false
Lion Knife Recipe	r32	false	true	false	false
Love Creeper	42	true	true	true	false
Maccunut	56	false	false	false	true
Macrider	73				true
Magic Stone	13	true	true	true	true
Maiming Bulawa Part	k99	false	false	false	true
Majestic Robe part	k143		true

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Get involved

Special Pages

Tools