Semantic search
Jump to navigation
Jump to search
Query-Depth:1Ace Combat X: Skies of Deception (Aug 16, 2006 prototype) by Hidden Palace Ace Combat Zero: The Belkan War (Jun 1, 2006 prototype) by Der Dingo Ace Combat: Assault Horizon (Aug 23, 2011 prototype) by Hidden Palace Ace Combat: Assault Horizon (Aug 30, 2011 prototype) by Funtimeandrefoxy Ace Combat: Assault Horizon (Jul 11, 2011 prototype) by Slycooper124 Aces of the Galaxy (Apr 14, 2008 prototype) by Funtimeandrefoxy Aces of the Galaxy (Feb 22, 2008 prototype) by Hidden Palace Acey by Glitchedblood Acolyte (Prototype) by Hidden Palace Action Bass (Jun 21, 2000 prototype) by Hidden Palace Action Fighter (Prototype) by Hidden Palace Actionauts (Jun 22, 1984 prototype) by Missile Active Life: Explorer (Jun 9, 2010 prototype) by Lemurboy12 Active Life: Magical Carnival (Debug prototype) by Lemurboy12 Active Life: Magical Carnival (Nov 7, 2011 prototype) by Hidden Palace Activision Classics (Jul 27, 1998 prototype) by Hidden Palace Addams Family Values (Early SNES Prototype) by Hidden Palace Addams Family Values (Mega Drive Prototype) by Hidden Palace Addams Family Values (Prototype) by Hidden Palace Aden34 by Glitchedblood Adian no Tsue (Oct 29, 1986 prototype) by Tikal. Advance Wars (iQue prototype) by Togemet2 Advanced Daisenryaku - Deutsch Dengeki Sakusen (Mar 7, 1991 prototype) by Hidden Palace Advanced Dungeons & Dragons: Heroes of the Lance (prototype) by Tikal. Advanced Dungeons & Dragons: Hillsfar (Prototype) by Hidden Palace Advent Rising (Apr 22, 2005 prototype) by Hidden Palace Advent Rising (Feb 16, 2005 prototype) by Hidden Palace Adventure Island II (Prototype) by ANobodyFromCanada Adventure Island III (Prototype) by Hidden Palace Adventure Time: Hey Ice King! Why’d you steal our garbage?!! (Jul 20, 2012 Nintendo 3DS prototype) by Tikal. Adventure 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 Adventures in the Magic Kingdom (Early prototype) by Hidden Palace Adventures in the Magic Kingdom (Prototype) by Hidden Palace Adventures of Dr. Franken (Prototype) by Hidden Palace Adventures to Go! (Jun 12, 2009 prototype) by Hidden Palace Aegis Wing (Mar 20, 2007 prototype) by Hidden Palace Aeon Flux (Aug 13, 2005 prototype) by Hidden Palace 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 Aero Elite: Combat Academy (Dec 12, 2002 prototype) by Hidden Palace Aero the Acro-Bat (Game Boy Advance prototype) by Hidden Palace Aero the Acro-Bat 2 (Aug 8, 1994 prototype) by Hidden Palace Aero-Cross (Nov 26, 2010 prototype) by Hidden Palace AeroGauge (Japanese demo) by Hidden Palace
Debug output SQLStore
ASK Query
[[:+]] [[Page creator::!Drx]] [[Page creator::!Evilhamwizard]]
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) 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 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
215
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) 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 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
215
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 | 50515 | 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 | 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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
None