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=563
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
Abaddon, Lord of Avernus/Borrowed Time#Abaddon, Lord of AvernusAggron Stonebreaker, Ogre Magi/Multicast#Aggron Stonebreaker, Ogre MagiAiushtha, Enchantress/Impetus#Aiushtha, EnchantressAkasha, Queen of Pain/Sonic Wave#Akasha, Queen of PainAlleria, Windrunner/Focus Fire#Alleria, WindrunnerAtropos, Bane Elemental/Fiend's Grip#Atropos, Bane ElementalAurel Vlaicu, Gyrocopter/Call Down#Aurel Vlaicu, GyrocopterBalanar, Night Stalker/Darkness#Balanar, Night StalkerBarathrum, Spiritbreaker/Nether Strike#Barathrum, SpiritbreakerBoush, Tinker/Laser#Boush, TinkerBoush, Tinker/Heat Seeking Missile#Boush, TinkerCairne Bloodhoof, Tauren Chieftain/Earth Splitter#Cairne Bloodhoof, Tauren ChieftainChen, Holy Knight/Hand of God#Chen, Holy KnightChen, Holy Knight/Holy Persuasion#Chen, Holy KnightCrixalis, Sand King/Epicenter#Crixalis, Sand KingDarkterror, Faceless Void/Chronosphere#Darkterror, Faceless VoidDazzle, Shadow Priest/Weave#Dazzle, Shadow PriestDemnok Lannik, Warlock/Rain of Chaos#Demnok Lannik, WarlockDirge, Undying/Flesh Golem#Dirge, UndyingDragonus, Skywrath Mage/Mystic Flare#Dragonus, Skywrath MageEredar, Shadow Demon/Demonic Purge#Eredar, Shadow DemonEzalor, Keeper of the Light/Spirit Form#Ezalor, Keeper of the LightEzalor, Keeper of the Light/Illuminate#Ezalor, Keeper of the LightFurion, Prophet/Wrath of Nature#Furion, ProphetHarbinger, Obsidian Destroyer/Sanity's Eclipse#Harbinger, Obsidian DestroyerHuskar, Sacred Warrior/Life Break#Huskar, Sacred WarriorIcarus, Phoenix/Supernova#Icarus, PhoenixIsh'kafel, Dark Seer/Wall of Replica#Ish'kafel, Dark SeerJakiro, Twin Head Dragon/Macropyre#Jakiro, Twin Head DragonKael, Invoker/Invoke#Kael, InvokerKaldr, Ancient Apparition/Ice Blast#Kaldr, Ancient ApparitionKaolin, Earth Spirit/Magnetize#Kaolin, Earth SpiritKel'Thuzad, Lich/Chain Frost#Kel'Thuzad, LichLesale Deathbringer, Venomancer/Poison Nova#Lesale Deathbringer, VenomancerLeshrac the Malicious, Tormented Soul/Pulse Nova#Leshrac the Malicious, Tormented SoulLina Inverse, Slayer/Laguna Blade#Lina Inverse, SlayerLion, Demon Witch/Finger of Death#Lion, Demon WitchLucifer, Doom Bringer/Doom#Lucifer, Doom BringerLuna Moonfang, Moon Rider/Eclipse#Luna Moonfang, Moon RiderMangix, Pandaren Brewmaster/Primal Split#Mangix, Pandaren BrewmasterMeepo, Geomancer/Divided We Stand#Meepo, GeomancerMogul Kahn, Axe/Culling Blade#Mogul Kahn, AxeNortrom, Silencer/Curse of the Silent#Nortrom, SilencerNortrom, Silencer/Global Silence#Nortrom, SilencerPuck, Faerie Dragon/Dream Coil#Puck, Faerie DragonPudge, Butcher/Dismember#Pudge, ButcherPugna, Oblivion/Life Drain#Pugna, OblivionPurist Thunderwrath, Omniknight/Guardian Angel#Purist Thunderwrath, OmniknightRaigor Stonehoof, Earthshaker/Echo Slam#Raigor Stonehoof, EarthshakerRattletrap, Clockwerk Goblin/Hookshot#Rattletrap, Clockwerk Goblin