Semantische Suche
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, idst7.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_bool` AS t2
INNER JOIN
`smw_di_bool` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
(`smw_di_wikipage` AS t7
INNER JOIN
`smw_object_ids` AS idst7 ON idst7.smw_id=t7.o_id) ON t0.smw_id=t7.s_id
WHERE
(
(t2.o_value=1) AND t2.p_id=568
AND (
(t4.o_value=1) AND t4.p_id=577)
)
AND (t7.p_id=556)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
idst7.smw_sort ASC
LIMIT
55
OFFSET
0
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t7 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 4 | const | 470 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t2 | ref | s_id, o_value | s_id | 8 | db_dswiki.t7.s_id, const | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_value | s_id | 8 | db_dswiki.t7.s_id, const | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | db_dswiki.t7.s_id | 1 | Using where | |
1 | SIMPLE | idst7 | eq_ref | PRIMARY, smw_id | PRIMARY | 4 | db_dswiki.t7.o_id | 1 |
Query-Depth:1
Aggron Stonebreaker, Ogre Magi/Bloodlust#Aggron Stonebreaker, Ogre MagiAiushtha, Enchantress/Nature's Attendants#Aiushtha, EnchantressAkasha, Queen of Pain/Sonic Wave#Akasha, Queen of PainAlleria, Windrunner/Windrunner#Alleria, WindrunnerAlleria, Windrunner/Focus Fire#Alleria, WindrunnerAtropos, Bane Elemental/Fiend's Grip#Atropos, Bane ElementalAuroth, the Winter Wyvern/Winter's Curse#Auroth, the Winter WyvernAuroth, the Winter Wyvern/Cold Embrace#Auroth, the Winter WyvernAzgalor, Pit Lord/Pit of Malice#Azgalor, Pit LordBarathrum, Spiritbreaker/Greater Bash#Barathrum, SpiritbreakerBoush, Tinker/March of the Machines#Boush, TinkerBradwarden, Centaur Warchief/Return#Bradwarden, Centaur WarchiefChen, Holy Knight/Holy Persuasion#Chen, Holy KnightChen, Holy Knight/Hand of God#Chen, Holy KnightClinkz, Bone Fletcher/Searing Arrows#Clinkz, Bone FletcherDarchrow, Enigma/Black Hole#Darchrow, EnigmaDarkterror, Faceless Void/Time Lock#Darkterror, Faceless VoidDarkterror, Faceless Void/Chronosphere#Darkterror, Faceless VoidDazzle, Shadow Priest/Weave#Dazzle, Shadow PriestDazzle, Shadow Priest/Shallow Grave#Dazzle, Shadow PriestDemnok Lannik, Warlock/Shadow Word#Demnok Lannik, WarlockDemnok Lannik, Warlock/Rain of Chaos#Demnok Lannik, WarlockDirge, Undying/Flesh Golem#Dirge, UndyingGondar, Bounty Hunter/Jinada#Gondar, Bounty HunterGondar, Bounty Hunter/Track#Gondar, Bounty HunterHuskar, Sacred Warrior/Inner Vitality#Huskar, Sacred WarriorHuskar, Sacred Warrior/Life Break#Huskar, Sacred WarriorIcarus, Phoenix/Supernova#Icarus, PhoenixIo, Guardian Wisp/Overcharge#Io, Guardian WispJin'zakk, Batrider/Flaming Lasso#Jin'zakk, BatriderKardel Sharpeye, Dwarven Sniper/Assassinate#Kardel Sharpeye, Dwarven SniperKel'Thuzad, Lich/Frost Armor#Kel'Thuzad, LichKrobelus, Death Prophet/Exorcism#Krobelus, Death ProphetLanaya, Templar Assassin/Meld#Lanaya, Templar AssassinLanaya, Templar Assassin/Psi Blades#Lanaya, Templar AssassinLesale Deathbringer, Venomancer/Poison Sting#Lesale Deathbringer, VenomancerLesale Deathbringer, Venomancer/Poison Nova#Lesale Deathbringer, VenomancerMagnus, Magnataur/Reverse Polarity#Magnus, MagnataurMagnus, Magnataur/Empower#Magnus, MagnataurMercurial, Spectre/Spectral Dagger#Mercurial, SpectreMercurial, Spectre/Haunt#Mercurial, SpectreMirana Nightshade, Priestess of the Moon/Moonlight Shadow#Mirana Nightshade, Priestess of the MoonMogul Kahn, Axe/Berserker's Call#Mogul Kahn, AxeMogul Kahn, Axe/Culling Blade#Mogul Kahn, AxeN'aix, Lifestealer/Feast#N'aix, LifestealerNerif, Oracle/False Promise#Nerif, OracleNevermore, Shadow Fiend/Presence of the Dark Lord#Nevermore, Shadow FiendNevermore, Shadow Fiend/Requiem of Souls#Nevermore, Shadow FiendNortrom, Silencer/Global Silence#Nortrom, SilencerPudge, Butcher/Dismember#Pudge, Butcher