Semantic search
Jump to navigation
Jump to search
Query-Depth:1Worms 2 (Sep 5, 1997 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed III (Sep 8, 2012 prototype) by Funtimeandrefoxy Need for Speed Underground (Aug 28, 2003 prototype) by Earthphoenix Assassin's Creed: Rogue (Jul 22, 2014 prototype) by Funtimeandrefoxy Assassin's Creed: Rogue (May 10, 2014 prototype) by Funtimeandrefoxy Assassin's Creed: Rogue (May 2, 2014 prototype) by Funtimeandrefoxy Dragon Ball Z: The Legacy of Goku II (Jan 31, 2003 prototype) by Terra Snewstorm Dragon Ball Z: The Legacy of Goku II (Jan 25, 2003 prototype) by Terra Snewstorm WipEout Fusion (Oct 14, 2001 prototype) by Julien Raidercast by Lemurboy12 Assassin's Creed: Rogue (Apr 26, 2014 prototype) by Funtimeandrefoxy Assassin's Creed: Rogue (Apr 11, 2014 prototype) by Funtimeandrefoxy Sega Logo and Hardware Demonstration (LOGODEMO prototype) by MDTravis Sega Logo and Hardware Demonstration (LALA prototype) by MDTravis Monster Hunter (Jul 18, 1993 prototype) by MDTravis Relentless (Oct 1993 prototype) by MDTravis Monster Hunter (Prototype) by MDTravis Monster Hunter (Dec 28, 1992 prototype) by MDTravis Contra 4 (May 12, 2007 prototype C) by Prototector Contra 4 (May 12, 2007 prototype B) by Prototector Contra 4 (May 12, 2007 prototype A) by Prototector Contra 4 (May 5, 2007 prototype) by Prototector Contra 4 (May 2, 2007 prototype C) by Prototector Contra 4 (May 2, 2007 prototype B) by Prototector Contra 4 (May 2, 2007 prototype A) by Prototector Contra 4 (April 29, 2007 prototype C) by Prototector Contra 4 (April 29, 2007 prototype B) by Prototector Contra 4 (April 29, 2007 prototype A) by Prototector Contra 4 (April 25, 2007 prototype C) by Prototector Contra 4 (April 25, 2007 prototype B) by Prototector Contra 4 (April 25, 2007 prototype A) by Prototector Contra 4 (April 22, 2007 prototype C) by Prototector Contra 4 (April 22, 2007 prototype B) by Prototector Contra 4 (April 22, 2007 prototype A) by Prototector Contra 4 (April 20, 2007 prototype A) by Prototector RalliSport Challenge 2 (Jan 6, 2004 prototype) by UNKNOWNED TOCA Race Driver 3 (AU Review prototype) by UNKNOWNED DiRT (prototype) by UNKNOWNED Shift 2: Unleashed (Mar 2, 2011 prototype) by UNKNOWNED Need for Speed Underground 2 (Sep 27, 2004 prototype) by UNKNOWNED Battlefield 2: Modern Combat (prototype) by UNKNOWNED Assassin's Creed: Brotherhood (Oct 9, 2010 prototype) by Funtimeandrefoxy PlayStation 3 Prototypes Megalot by Lilithdesign388 Assassin's Creed: Rogue (Apr 5, 2014 prototype) by Funtimeandrefoxy Assassin's Creed: Brotherhood (EU Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed: Brotherhood (USA Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed: Rogue (Apr 1, 2014 prototype) by Kabojnk Assassin's Creed: Brotherhood (Apr 18, 2011 17 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed: Brotherhood (Apr 18, 2011 10 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed: Brotherhood (Apr 16, 2011 multiplayer prototype) by Funtimeandrefoxy Assassin's Creed: Brotherhood (Apr 15, 2011 multiplayer prototype) by Funtimeandrefoxy SCE Cambridge 2009 Backup Disc by Chunkinator Fear Effect: Inferno (Apr 16, 2003 Prototype) by Missile Contra 4 (April 20, 2007 prototype B) by Prototector Contra 4 (April 20, 2007 prototype C) by Prototector Contra 4 (April 18, 2007 prototype C) by Prototector Contra 4 (April 18, 2007 prototype B) by Prototector Contra 4 (April 18, 2007 prototype A) by Prototector Contra 4 (April 4, 2007 prototype C) by Prototector Contra 4 (April 4, 2007 prototype B) by Prototector Contra 4 (April 4, 2007 prototype A) by Prototector Contra 4 (March 29, 2007 prototype C) by Prototector Contra 4 (March 29, 2007 prototype B) by Prototector Contra 4 (March 29, 2007 prototype A) by Prototector Contra 4 (March 25, 2007 prototype C) by Prototector Contra 4 (March 25, 2007 prototype B) by Prototector Contra 4 (March 25, 2007 prototype A) by Prototector Contra 4 (March 8, 2007 prototype C) by Prototector Contra 4 (March 8, 2007 prototype B) by Prototector Contra 4 (March 8, 2007 prototype A) by Prototector Contra 4 (February 12, 2007 prototype C) by Prototector Contra 4 (February 12, 2007 prototype B) by Prototector Contra 4 (February 12, 2007 prototype A) by Prototector Contra 4 (February 5, 2007 prototype) by Prototector Drahcir xdk by Dink Blood Wake (Aug 18, 2001 prototype) by Dink Crimson Skies: High Road to Revenge (Aug 7, 2001 prototype) by Dink Tumble (Apr 01, 2010 prototype) by Catsus Tumble (Mar 26, 2010 prototype) by Catsus Rain0x06 by Rain0x06 Assassin's Creed IV: Black Flag (Jul 15, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (Jul 20, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (Jun 28, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (May 14, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (Feb 26, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (Sep 13, 2013 Multiplayer prototype) by Funtimeandrefoxy Assassin's Creed IV: Black Flag (Feb 28, 2013 Multiplayer prototype) by Funtimeandrefoxy Tom Clancy's Ghost Recon: Future Soldier (Feb 23, 2012 prototype) by Funtimeandrefoxy Crysis 3 (Sep 4, 2012 prototype) by Funtimeandrefoxy MotorStorm: Apocalypse (The First Playable Internal Prototype) by TreezZ Vectorman (May 7, 2003 prototype) by Hidden Palace Vectorman (May 1, 2003 prototype) by Hidden Palace Vectorman (Jun 17, 2003 prototype) by Hidden Palace Vectorman (Jan 10, 2003 prototype) by Hidden Palace Vectorman (Feb 6, 2003 prototype) by Hidden Palace Vectorman (Apr 14, 2003 prototype) by Hidden Palace Vectorman (Apr 7, 2003 prototype) by Hidden Palace Black & White: Creatures (May 13, 2005 Nintendo DS prototype) by Tikal. Tom Clancy's Ghost Recon: Future Soldier (Feb 22, 2012 prototype) by Funtimeandrefoxy Crysis 3 (Dec 19, 2012 prototype) by Funtimeandrefoxy
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, t10.o_sortkey
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
INNER JOIN
`smw_fpt_cdat` AS t10 ON t0.smw_id=t10.s_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
t10.o_sortkey DESC
LIMIT
105
OFFSET
0
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, t10.o_sortkey
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
INNER JOIN
`smw_fpt_cdat` AS t10 ON t0.smw_id=t10.s_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
t10.o_sortkey DESC
LIMIT
105
OFFSET
0
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 | 50512 | 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 | t10 | ref | s_id | s_id | 4 | hp_wiki_new.t3.s_id | 1 | ||
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