Semantic search
Jump to navigation
Jump to search
Debug output SQLStore
ASK Query
[[Page type is::title]] [[Title category is::Category:Barbarian titles]] [[Title subcategory is::roar]]
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
INNER JOIN
`smw_di_blob` AS t7 ON t2.s_id=t7.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=497007)
AND (
(t7.o_hash='roar') AND t7.p_id=2021285)
)
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
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
INNER JOIN
`smw_di_blob` AS t7 ON t2.s_id=t7.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=497007)
AND (
(t7.o_hash='roar') AND t7.p_id=2021285)
)
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 | t7 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 262 | const, const | 111 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | drwiki.t7.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | s_id_3 | 13 | drwiki.t7.s_id, const, const | 1 | Using index; Distinct | |
1 | SIMPLE | t2 | ref | s_id, p_id, o_hash, s_id_2 | s_id | 8 | drwiki.t7.s_id, const | 1 | Using where; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:6Query-Depth:1
Errors and Warnings
NoneTitle | Title requirement |
---|---|
Title:Banshee | Must know Banshee's Wail |
Title:Battle Jester | Must know Insane Laughter At least 40 in Charisma |
Title:Battlehardened | Must know Caution of the Spider At least 40 in Charisma |
Title:Black Widow (Barbarian) | Must know Caution of the Spider At least 40 in Charisma |
Title:Boar | Must know Everild's Rage |
Title:Browbeater | Must know 3 Roars |
Title:Centaur | Must know Trothfang's Butchery |
Title:Deadly | Must know Death's Embrace |
Title:Death Slinger | Must know Death's Lullaby At least 40 in Charisma |
Title:Deathwright | Must know Death's Shriek Must know Death's Embrace Must know Death's Lullaby At least 45 in Charisma |
Title:Dread | Must know 8 Roars |
Title:Earthquake | Must know Anger the Earth At least 40 in Charisma |
Title:Earthshaker (Barbarian) | Must know Anger the Earth |
Title:Equalizer | Must know Weighted Justice |
Title:Fatal Fire | Must know Magic's Bane At least 40 in Charisma |
Title:Fatal Flame | Must know Mage's Lament At least 40 in Charisma |
Title:Fear Monger | Must know 8 Roars At least 40 in Charisma |
Title:Frenzy | At least 40 in Charisma Must know Tempestuous Fury |
Title:Furious | Must know Tempestous Fury |
Title:Grim | Must know Death's Lullaby |
Title:Grim Caller | Must know 9 Roars At least 40 in Charisma |
Title:Heartbreaker | Must know Death's Shriek |
Title:Horror | Must know 6 Roars |
Title:Immobilizer | Must know Banshee's Wail At least 40 in Charisma |
Title:Intimidator | Must know at least 5 Roars (not including Battle Cries) |
Title:Mage Bane | Must know Mage's Lament |
Title:Magic Bane | Must know Magic's Bane |
Title:Menace | Must know 4 Roars |
Title:Penetrator | Must know Death's Embrace At least 40 in Charisma |
Title:Primal Voice | Must know Kuniyo's Spirit Must know Everild's Rage Must know Trothfang's Butchery At least 45 in Charisma |
Title:Punisher | Must know 6 Roars At least 40 in Charisma |
Title:Rage | Must know 5 Roars |
Title:Relentless | Must know Slash the Shadows |
Title:Remorseless | Must know Death's Shriek At least 40 in Charisma |
Title:Ruthless | Must know Serpent's Hiss of Warning At least 40 in Charisma |
Title:Shadowbreaker | Must know Slash the Shadows At least 40 in Charisma |
Title:Spiteful | Must know Screech of Madness |
Title:Strong Arm | Must know 2 Roars |
Title:Student of Everild | Must know Everild's Rage At least 30 in Charisma |
Title:Student of Kuniyo | Must know Kuniyo's Spirit At least 30 in Charisma |
Title:Student of Trothfang | Must know Trothfang's Butchery At least 30 in Charisma |
Title:Terrible (Barbarian) | Must know 7 Roars At least 40 in Charisma |
Title:Terror | Must know at least 7 Roars (not including Battle Cries) |
Title:Banshee | Must know Banshee's Wail |
Title:Battle Jester | Must know Insane Laughter At least 40 in Charisma |
Title:Battlehardened | Must know Caution of the Spider At least 40 in Charisma |
Title:Black Widow (Barbarian) | Must be female Must know Caution of the Spider At least 40 in Charisma |
Title:Boar | Must know Everild's Rage |
Title:Browbeater | Must know 3 Roars |
Title:Centaur | Must know Trothfang's Butchery |