Semantic search
Jump to navigation
Jump to search
Query-Depth:1Adventure Time: Hey Ice King! Why’d you steal our garbage?!! (Jul 20, 2012 Nintendo DS prototype) by Tikal. Adventure Time: Hey Ice King! Why’d you steal our garbage?!! (Jun 19, 2012 prototype) by Tikal. Adventure Time: Hey Ice King! Why’d you steal our garbage?!! (Jun 30, 2012 prototype) by Tikal. Adventure Time: Hey Ice King! Why’d you steal our garbage?!! (May 11, 2012 prototype) by Heboyi Adventure Time: The Secret of the Nameless Kingdom (Oct 28, 2014 prototype) by Null Adventure Time: The Secret of the Nameless Kingdom (Sep 22, 2014 prototype) by Funtimeandrefoxy Aeon Flux (Jun 27, 2005 prototype) by Cut Into Fourteen Pieces Aeon Flux (Nov 18, 1996 prototype) by Cut Into Fourteen Pieces Aeon Flux (Oct 11, 2005 prototype) by Cut Into Fourteen Pieces Affinix Software by Glitchedblood Agartha (Apr 17, 2001 prototype) by Sega Dreamcast Info Agartha (Mar 9, 2001 prototype) by Hairygarlic Age of Empires (Aug 15, 1997 prototype) by Nex Age of Empires 2 - Age of Kings (Feb 22, 1999 prototype) by Слава України Age of Empires 2 - Age of Kings (Jul 17, 1998 prototype) by Слава України Age of Empires 2 - Age of Kings (July 1, 1999 prototype) by Слава України Age of Empires 2 - Age of Kings (June 2, 1999 prototype) by Слава України Age of Empires 2 - Age of Kings (June 30, 1999 prototype) by Слава України Age of Empires 2 - Age of Kings (May 13, 1999 prototype) by Слава України Age of Empires: The Rise of Rome (Aug 5, 1998 prototype) by Слава України Age of Empires: The Rise of Rome (Sep 15, 1998 prototype) by Слава України Aggressive Inline (Aug 21, 2002 prototype) by Funtimeandrefoxy Aggressive Inline (Mar 2, 2002 prototype) by Lemurboy12 Aggressive Inline (Mar 3, 2002 prototype) by Lemurboy12 AgustinCordes by Glitchedblood Aidyn Chronicles: The First Mage (Apr 10, 2001 prototype) by Lemurboy12 Aidyn Chronicles: The First Mage (Dec 5, 2000 Prototype) by Lemurboy12 Aidyn Chronicles: The First Mage (Feb 1, 2001 Debug) by Hector Ceromus Aidyn Chronicles: The First Mage (Mar 2, 2001 prototype) by Lemurboy12 Air Sea Battle (Robert Coppock Demo) by Missile Airlock (prototype) by Tikal. Ajshell1 by Glitchedblood Akuji: The Heartless (Nov 11, 1998 prototype) by Hwd45 Akuu Senki Raijin (Oct 14, 1987 prototype) by Skrybe Aladdin (Aug 13, 1993 prototype) by Lilithdesign388 Aladdin (Chicago C.E.S demo) by Billscat-socks Aladdin (SNES prototype) by Lemurboy12 Alan Wake (Jan 11, 2010 prototype) by Funtimeandrefoxy Alan Wake (The Writer DLC Sep 15, 2010 prototype) by Funtimeandrefoxy Alchy by Glitchedblood Alcoatjez by Glitchedblood Alex Handy by Lemurboy12 AlexKVideos1 by Glitchedblood Alfred Chicken (Dec 3, 2001 prototype) by Cut Into Fourteen Pieces Alfred Chicken (SNES prototype) by Tikal. Ali Kirb by Lilithdesign388 Alice: Madness Returns (Nov 17, 2010 Prototype) by Cooper941 AliciaBurrito by Lilithdesign388 Alien 3 (ANTHROX prototype) by Lemurboy12 Alien 3 (Apr 30, 1993 prototype) by Tikal.
Debug output SQLStore
ASK Query
[[:+]] [[Page creator::!Drx]] [[Page creator::!Evilhamwizard]] [[Page creator::!Hidden Palace]]
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_object_ids` AS t2
INNER JOIN
(`smw_di_wikipage` AS t3
INNER JOIN
`smw_object_ids` AS t5 ON t3.o_id=t5.smw_id) ON t2.smw_id=t3.s_id
INNER JOIN
(`smw_di_wikipage` AS t6
INNER JOIN
`smw_object_ids` AS t8 ON t6.o_id=t8.smw_id) ON t2.smw_id=t6.s_id
INNER JOIN
(`smw_di_wikipage` AS t9
INNER JOIN
`smw_object_ids` AS t11 ON t9.o_id=t11.smw_id) ON t2.smw_id=t9.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (t3.p_id=4245
AND (t5.smw_sortkey!='Drx')
)
AND (t6.p_id=4245
AND (t8.smw_sortkey!='Evilhamwizard')
)
AND (t9.p_id=4245
AND (t11.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
115
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_object_ids` AS t2
INNER JOIN
(`smw_di_wikipage` AS t3
INNER JOIN
`smw_object_ids` AS t5 ON t3.o_id=t5.smw_id) ON t2.smw_id=t3.s_id
INNER JOIN
(`smw_di_wikipage` AS t6
INNER JOIN
`smw_object_ids` AS t8 ON t6.o_id=t8.smw_id) ON t2.smw_id=t6.s_id
INNER JOIN
(`smw_di_wikipage` AS t9
INNER JOIN
`smw_object_ids` AS t11 ON t9.o_id=t11.smw_id) ON t2.smw_id=t9.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (t3.p_id=4245
AND (t5.smw_sortkey!='Drx')
)
AND (t6.p_id=4245
AND (t8.smw_sortkey!='Evilhamwizard')
)
AND (t9.p_id=4245
AND (t11.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
115
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t3 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | p_id | 4 | const | 50526 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t6 | 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.t3.s_id | 1 | Using where | |
1 | SIMPLE | t9 | 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.t3.s_id | 1 | Using where | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t3.s_id | 1 | Using where | |
1 | SIMPLE | t5 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t3.o_id | 1 | Using where; Using index; Distinct | |
1 | SIMPLE | t8 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t6.o_id | 1 | Using where; Using index; Distinct | |
1 | SIMPLE | t11 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t9.o_id | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
None