Semantic search
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_number` AS t2
INNER JOIN
(`smw_di_wikipage` AS t4
INNER JOIN
`smw_object_ids` AS t6 ON t4.o_id=t6.smw_id) ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id=5789
AND (t4.p_id=4245
AND (t6.smw_sortkey!='Hidden Palace')
))
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
17
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t2 | ref | s_id, p_id, p_id_2, s_id_2 | p_id | 4 | const | 1006 | Using temporary; Using filesort | |
1 | SIMPLE | t4 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 8 | const, hp_wiki_new.t2.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t2.s_id | 1 | Using where | |
1 | SIMPLE | t6 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t4.o_id | 1 | Using where; Using index; Distinct |
Query-Depth:1
ANOKristi9344 (User edit countThis property is a special property in this wiki.: 1, User:ANOKristi9344), ANobodyFromCanada (User edit countThis property is a special property in this wiki.: 56, User:ANobodyFromCanada), ARandomGuy231 (User edit countThis property is a special property in this wiki.: 34, User:ARandomGuy231), AShadeofJeremy (User edit countThis property is a special property in this wiki.: 1, User:AShadeofJeremy), AXEAX (User edit countThis property is a special property in this wiki.: 1, User:AXEAX), Aahai79e (User edit countThis property is a special property in this wiki.: 49, User:Aahai79e), Aaron772929 (User edit countThis property is a special property in this wiki.: 1, User:Aaron772929), Ace of DiscaL (User edit countThis property is a special property in this wiki.: 1, User:Ace of DiscaL), AceKombat (User edit countThis property is a special property in this wiki.: 1, User:AceKombat), Acoustictyre (User edit countThis property is a special property in this wiki.: 6, User:Acoustictyre), Adam (User edit countThis property is a special property in this wiki.: 1, User:Adam), Adiguvicx (User edit countThis property is a special property in this wiki.: 9, User:Adiguvicx), Admin0000 (User edit countThis property is a special property in this wiki.: 3, User:Admin0000), Adriancho74 (User edit countThis property is a special property in this wiki.: 259, User:Adriancho74), Aeritha (User edit countThis property is a special property in this wiki.: 10, User:Aeritha), AeroWhistler (User edit countThis property is a special property in this wiki.: 2, User:AeroWhistler), Aesthez (User edit countThis property is a special property in this wiki.: 8, User:Aesthez), Ajthenoob (User edit countThis property is a special property in this wiki.: 3, User:Ajthenoob), Alag (User edit countThis property is a special property in this wiki.: 1, User:Alag), Albertvaka (User edit countThis property is a special property in this wiki.: 1, User:Albertvaka), Aleksey369 (User edit countThis property is a special property in this wiki.: 1, User:Aleksey369), Alevat (User edit countThis property is a special property in this wiki.: 8, User:Alevat), Alex (User edit countThis property is a special property in this wiki.: 4, User:Alex), Alex Kosoy (User edit countThis property is a special property in this wiki.: 16, User:Alex Kosoy), Alexander29 (User edit countThis property is a special property in this wiki.: 1, User:Alexander29), AlexandraLandrum (User edit countThis property is a special property in this wiki.: 1, User:AlexandraLandrum), Alexboanta3107 (User edit countThis property is a special property in this wiki.: 8, User:Alexboanta3107), Alexparr (User edit countThis property is a special property in this wiki.: 1, User:Alexparr), Alieneer (User edit countThis property is a special property in this wiki.: 2, User:Alieneer), Alikirb (User edit countThis property is a special property in this wiki.: 5, User:Alikirb), AllThingsGaming6 (User edit countThis property is a special property in this wiki.: 9, User:AllThingsGaming6), Alphawolf (User edit countThis property is a special property in this wiki.: 3, User:Alphawolf), Amdcrash (User edit countThis property is a special property in this wiki.: 2, User:Amdcrash), Amfea2 (User edit countThis property is a special property in this wiki.: 1, User:Amfea2), Ammoar (User edit countThis property is a special property in this wiki.: 1, User:Ammoar), Amzy (User edit countThis property is a special property in this wiki.: 3, User:Amzy), Anchorman (User edit countThis property is a special property in this wiki.: 4, User:Anchorman), Andlabs (User edit countThis property is a special property in this wiki.: 4, User:Andlabs), AndreaRitsu (User edit countThis property is a special property in this wiki.: 1, User:AndreaRitsu), Anotherage (User edit countThis property is a special property in this wiki.: 1, User:Anotherage), Antonio 01996 (User edit countThis property is a special property in this wiki.: 16, User:Antonio 01996), Aplolwow (User edit countThis property is a special property in this wiki.: 1, User:Aplolwow), Ar675 (User edit countThis property is a special property in this wiki.: 4, User:Ar675), Archivemonk (User edit countThis property is a special property in this wiki.: 16, User:Archivemonk), Archiver337 (User edit countThis property is a special property in this wiki.: 3, User:Archiver337), Arcorann (User edit countThis property is a special property in this wiki.: 2, User:Arcorann), Arctic Circle System (User edit countThis property is a special property in this wiki.: 64, User:Arctic Circle System), Armadylo (User edit countThis property is a special property in this wiki.: 81, User:Armadylo), Arrows (User edit countThis property is a special property in this wiki.: 5, User:Arrows), Arthur&JohnnyDude67 (User edit countThis property is a special property in this wiki.: 1, User:Arthur&JohnnyDude67)