Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Category:Warrior Mage titles]] [[Title subcategory is::spell]] [[Title:+]]
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
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=510420
AND (
(t4.o_hash='spell') AND t4.p_id=2021285)
AND (t6.smw_namespace=116)
)
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
100
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
`smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_object_ids` AS t6 ON t2.s_id=t6.smw_id) ON t0.smw_id=t2.s_id
WHERE
(t2.o_id=510420
AND (
(t4.o_hash='spell') AND t4.p_id=2021285)
AND (t6.smw_namespace=116)
)
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
100
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 383 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t2.s_id | 1 | Using where | |
1 | SIMPLE | t6 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | drwiki.t2.s_id | 1 | Using where; Distinct | |
1 | SIMPLE | t4 | ref | s_id, p_id, o_hash, s_id_2 | s_id | 8 | drwiki.t2.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneTitle | Title requirement |
---|---|
Title:Storm Warrior | Must be a Elf Must know the Rimefang spell Must know the Zephyr spell Must know the Lightning Bolt spell At least 400 in Attunement skill |
Title:Storm Weaver | At least 500 in Primary Magic skill Must know 3 spells from the Electricity Manipulation spellbook Must know 3 spells from the Water Manipulation spellbook Must know 3 spells from the Air Manipulation spellbook |
Title:Taisal Getha | 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:Tempest | At least 480 in Primary Magic skill Must know 5 spells from the Electricity Manipulation spellbook Must know 5 spells from the Water Manipulation spellbook Must know 5 spells from the Air Manipulation spellbook |
Title:Tidal Fist | At least 200 in Brawling skill Must know the Rising Mists spell |
Title:Typhoon | At least 235 in Primary Magic skill Must know 3 spells from the Air Manipulation spellbook |
Title:Water Adept | At least 120 in Primary Magic skill Must know 4 spells from the Water Manipulation spellbook |
Title:Water Cabalist | Must know 1 spells from the Water Manipulation spellbook Must know 0 spells from the Fire Manipulation spellbook |
Title:Watercaster | At least 40 in Primary Magic skill Must know 3 spells from the Water Manipulation spellbook |
Title:Wind Adept | At least 120 in Primary Magic skill Must know 4 spells from the Air Manipulation spellbook |
Title:Wind Crafter | At least 235 in Primary Magic skill Must know at least 2 spells from the Air Manipulation spellbook |
Title:Wind Dilettante | Must know at least 1 spells from the Air Manipulation spellbook Must know fewer than 2 spells in the Air Manipulation spellbook |
Title:Wind Fist | At least 200 in Brawling skill Must know the Tailwind spell |
Title:Windcaster | At least 40 in Primary Magic skill Must know 3 spells from the Air Manipulation spellbook |
Title:Zeng Getha | 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 |