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: [[page type is::title]] [[title category is::Category:Warrior Mage titles]]
 |?=Title#-
 |?Title requirement
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=Title
 |searchlabel=... more titles
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[page type is::title]] [[title category is::Category:Warrior Mage titles]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0351",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Page type is::title]] [[Title category is::Category:Warrior Mage titles]]

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_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   (t2.o_hash='title') AND t2.p_id=2021236
   AND (t4.p_id=2021277 AND t4.o_id=510420)
  )
  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	Extra
1	SIMPLE	t4	ref	s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3	o_id	5	const	382	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

Title	Title requirement
Title:Aerial Doom	Must know the Tailwind spell Must know the Shockwave spell Must know the Thunderclap spell Must know the Vertigo spell At least 545 in Primary Magic skill At least 480 in Targeted Magic skill
Title:Aerial Fury	Must know 5 spells from the Air Manipulation spellbook At least 545 in Primary Magic skill At least 480 in Targeted Magic skill
Title:Aeromancer	Must know the Zephyr spell Must know the Tailwind spell Must know the Paeldryth's Wrath spell Must know the Shockwave spell Must know the Swirling Winds spell Must know the Vertigo spell Must know the Thunderclap spell
Title:Aes Getha	Must know the Fire Shards spell Must know the Fire Ball spell Must know the Dragon's Breath spell Must know the Mantle of Flame spell Must know the Fire Rain spell Must know the Ignite spell
Title:Aether Adept	At least 120 in Primary Magic skill Must know 4 spells from the Aether Manipulation spellbook
Title:Aether Cabalist	Must know 1 spells from the Aether Manipulation spellbook Must know 0 spells from the Electricity Manipulation spellbook
Title:Aether Crafter	Must know 2 spells from the Aether Manipulation spellbook At least 235 in Primary Magic skill
Title:Aether Dilettante	Must know 1 spells from the Aether Manipulation spellbook Must know fewer than 2 spells in the Aether Manipulation spellbook
Title:Aethercaster	At least 40 in Primary Magic skill Must know 3 spells from the Aether Manipulation spellbook
Title:Aethereal Fury	At least 545 in Primary Magic skill At least 480 in Targeted Magic skill Must know 5 spells from the Aether Manipulation spellbook
Title:Aethereal Lancer	Must know the Aether Lance spell
Title:Aethromancer	Must know the Ethereal Shield spell Must know the Aether Cloak spell Must know the Ward Break spell Must know the Ethereal Fissure spell Must know the Substratum spell
Title:Air Cabalist	Must know 1 spells from the Air Manipulation spellbook Must know 0 spells from the Earth Manipulation spellbook
Title:Apprentice Summoner	At least 20 in Primary Magic skill At least 10 in Engineering skill
Title:Archwizard	At least 8590 ranks in Magic Total w/TM
Title:Astute Mage	At least 20 in Primary Magic skill At least 30 in Targeted Magic skill
Title:Atrai Getha	Must know the Ethereal Shield spell Must know the Aether Cloak spell Must know the Ward Break spell Must know the Ethereal Fissure spell Must know the Substratum spell
Title:Battle Mage	At least 345 in Primary Magic skill At least 300 in highest Weapon skill At least 250 in 2nd highest Weapon skill
Title:Battlecaster	At least 40 in Primary Magic skill
Title:Blackfire Enthusiast	Must know at least 1 spells from the Blackfire Sorcery spellbook
Title:Burning Fist	At least 200 in Brawling skill Must know the Mantle of Flame spell
Title:Cloudshaper	At least 235 in Primary Magic skill Must know the Rising Mists spell
Title:Cold Witch	Must know the Frostbite spell Must know the Ice Patch spell Must know the Frost Scythe spell
Title:Cyclone (warrior mage)	At least 120 in Primary Magic skill Must know 2 spells from the Air Manipulation spellbook
Title:Den Rai Cambri	At least 925 in Primary Magic skill
Title:Earth Cabalist	Must know 1 spells from the Earth Manipulation spellbook Must know 0 spells from the Air Manipulation spellbook
Title:Earth Crafter	At least 235 in Primary Magic skill Must know 2 spells from the Earth Manipulation spellbook
Title:Earth Render	At least 235 in Primary Magic skill Must know the Tremor spell Must know the Stone Strike spell
Title:Earthen Doom	At least 545 in Primary Magic skill At least 480 in Targeted Magic skill Must know the Tremor spell Must know the Ring of Spears spell Must know the Fist of Stone spell Must know the Magnetic Ballista spell Must know the Stone Strike spell
Title:Earthen Fury	At least 545 in Primary Magic skill At least 480 in Targeted Magic skill Must know 5 spells from the Earth Manipulation spellbook
Title:Earthshaker (Warrior Mage)	At least 235 in Primary Magic skill Must know the Tremor spell
Title:Electrical Doom	At least 545 in Primary Magic skill At least 480 in Targeted Magic skill Must know the Arc Light spell Must know the Static Discharge spell Must know the Lightning Bolt spell Must know the Chain Lightning spell Must know the Gar Zeng spell Must know the Ball Lightning spell
Title:Electrical Fury	At least 545 in Primary Magic skill At least 480 in Targeted Magic skill Must know 5 spells from the Electricity Manipulation spellbook
Title:Electricity Cabalist	Must know 1 spells from the Electricity Manipulation spellbook Must know 0 spells from the Aether Manipulation spellbook
Title:Electricity Dilettante	Must know 1 spells from the Electricity Manipulation spellbook Must know fewer than 2 spells in the Electricity Manipulation spellbook
Title:Electrocaster	At least 40 in Primary Magic skill Must know 3 spells from the Electricity Manipulation spellbook
Title:Electromancer	Must know the Arc Light spell Must know the Tingle spell Must know the Lightning Bolt spell Must know the Chain Lightning spell Must know the Gar Zeng spell Must know the Grounding Field spell
Title:Elemancer	At least 80 in Primary Magic skill Must know 1 spells from the Aether Manipulation spellbook Must know 1 spells from the Electricity Manipulation spellbook Must know 1 spells from the Fire Manipulation spellbook Must know 1 spells from the Water Manipulation spellbook Must know 1 spells from the Earth Manipulation spellbook Must know 1 spells from the Air Manipulation spellbook
Title:Elemental Aegis	At least 345 in Primary Magic skill Must know the Ethereal Shield spell Must know the Swirling Winds spell Must know the Mantle of Flame spell Must know the Veil of Ice spell Must know the Aether Cloak spell Must know the Fortress of Ice spell Must know the Y'ntrel Sechra spell
Title:Elemental Artillerist	At least 250 in Targeted Magic skill Must know the Magnetic Ballista spell
Title:Elemental Bloodbath	At least 2400 in total magic skill Must know the Frostbite spell Must know the Thunderclap spell Must know the Tremor spell Must know the Chain Lightning spell Must know the Fire Rain spell
Title:Elemental Cataclysm	At least 3000 in total magic skill Must know the Frostbite spell Must know the Thunderclap spell Must know the Tremor spell Must know the Chain Lightning spell Must know the Fire Rain spell
Title:Elemental Cataphract	At least 500 in Primary Magic skill At least 300 in highest weapon skill At least 300 in highest armor skill At least 300 in Shield Usage skill At least 300 in Parry Ability skill Must know 3 spells from the Aether Manipulation spellbook Must know 3 spells from the Electricity Manipulation spellbook Must know 3 spells from the Fire Manipulation spellbook Must know 3 spells from the Water Manipulation spellbook Must know 3 spells from the Earth Manipulation spellbook Must know 3 spells from the Air Manipulation spellbook
Title:Elemental Catastrophe	At least 4000 in total magic skill Must know the Frostbite spell Must know the Thunderclap spell Must know the Tremor spell Must know the Chain Lightning spell Must know the Fire Rain spell
Title:Elemental Colossus	At least 1000 in Primary Magic skill At least 500 in highest weapon skill At least 500 in highest armor skill At least 500 in Shield Usage skill At least 500 in Parry Ability skill Must know 5 spells from the Aether Manipulation spellbook Must know 5 spells from the Electricity Manipulation spellbook Must know 5 spells from the Fire Manipulation spellbook Must know 5 spells from the Water Manipulation spellbook Must know 5 spells from the Earth Manipulation spellbook Must know 5 spells from the Air Manipulation spellbook
Title:Elemental Defender	At least 120 in Primary Magic skill Must know the Ethereal Shield spell Must know the Swirling Winds spell
Title:Elemental Enforcer	At least 300 in Primary Magic skill At least 200 in highest weapon skill At least 200 in highest armor skill At least 200 in Shield Usage skill At least 200 in Parry Ability skill Must know 2 spells from the Aether Manipulation spellbook Must know 2 spells from the Electricity Manipulation spellbook Must know 2 spells from the Fire Manipulation spellbook Must know 2 spells from the Water Manipulation spellbook Must know 2 spells from the Earth Manipulation spellbook Must know 2 spells from the Air Manipulation spellbook
Title:Elemental Juggernaut	At least 750 in Primary Magic skill At least 400 in highest weapon skill At least 400 in highest armor skill At least 400 in Shield Usage skill At least 400 in Parry Ability skill Must know 4 spells from the Aether Manipulation spellbook Must know 4 spells from the Electricity Manipulation spellbook Must know 4 spells from the Fire Manipulation spellbook Must know 4 spells from the Water Manipulation spellbook Must know 4 spells from the Earth Manipulation spellbook Must know 4 spells from the Air Manipulation spellbook
Title:Elemental Lady	At least 235 in Primary Magic skill Must know 3 spells from the Aether Manipulation spellbook Must know 3 spells from the Electricity Manipulation spellbook Must know 3 spells from the Fire Manipulation spellbook Must know 3 spells from the Water Manipulation spellbook Must know 3 spells from the Earth Manipulation spellbook Must know 3 spells from the Air Manipulation spellbook
Title:Elemental Liability	At least 1600 in total magic skill Must know the Frostbite spell Must know the Thunderclap spell Must know the Tremor spell Must know the Chain Lightning spell Must know the Fire Rain spell

Semantic search

Query log

Navigation menu

Search