Semantic search
Jump to navigation
Jump to search
Query-Depth:1Contra 4 (February 18, 2007 prototype B) by Prototector Contra 4 (February 18, 2007 prototype A) by Prototector Contra 4 (March 27, 2007 prototype C) by Prototector Contra 4 (March 27, 2007 prototype B) by Prototector Contra 4 (July 18, 2007 prototype C) by Prototector Contra 4 (July 18, 2007 prototype B) by Prototector Contra 4 (August 28, 2007 prototype B) by Prototector Section 8: Prejudice (Dec 16, 2010 Stress Test) by Funtimeandrefoxy Contra 4 (October 15, 2007 prototype A) by Prototector E3 2012 Nintendo Press Kit by Funtimeandrefoxy Contra 4 (January 24, 2008 prototype) by Prototector Contra 4 (December 19, 2007 prototype) by Prototector Contra 4 (October 15, 2007 prototype B) by Prototector Contra 4 (September 5, 2007 prototype) by Prototector Contra 4 (August 28, 2007 prototype A) by Prototector Contra 4 (August 13, 2007 prototype C) by Prototector Contra 4 (August 13, 2007 prototype B) by Prototector Contra 4 (August 13, 2007 prototype A) by Prototector Contra 4 (July 24, 2007 prototype C) by Prototector Contra 4 (July 24, 2007 prototype B) by Prototector Contra 4 (July 24, 2007 prototype A) by Prototector Contra 4 (July 18, 2007 prototype A) by Prototector Contra 4 (July 11, 2007 prototype F) by Prototector Contra 4 (July 11, 2007 prototype E) by Prototector Contra 4 (July 11, 2007 prototype D) by Prototector Contra 4 (July 11, 2007 prototype C) by Prototector Contra 4 (July 11, 2007 prototype B) by Prototector Contra 4 (July 11, 2007 prototype A) by Prototector Contra 4 (June 26, 2007 prototype C) by Prototector Contra 4 (June 26, 2007 prototype B) by Prototector Contra 4 (June 26, 2007 prototype A) by Prototector Contra 4 (June 16, 2007 prototype C) by Prototector Contra 4 (June 16, 2007 prototype B) by Prototector Contra 4 (June 16, 2007 prototype A) by Prototector Contra 4 (June 4, 2007 prototype C) by Prototector Contra 4 (June 4, 2007 prototype B) by Prototector Contra 4 (June 4, 2007 prototype A) by Prototector Contra 4 (May 15, 2007 prototype C) by Prototector Contra 4 (May 15, 2007 prototype B) by Prototector Contra 4 (May 15, 2007 prototype A) by Prototector Contra 4 (May 1, 2007 prototype C) by Prototector Contra 4 (May 1, 2007 prototype B) by Prototector Contra 4 (May 1, 2007 prototype A) by Prototector Contra 4 (April 24, 2007 prototype C) by Prototector Contra 4 (April 24, 2007 prototype B) by Prototector Contra 4 (April 24, 2007 prototype A) by Prototector Contra 4 (April 17, 2007 prototype C) by Prototector Contra 4 (April 17, 2007 prototype B) by Prototector Contra 4 (April 17, 2007 prototype A) by Prototector Contra 4 (April 5, 2007 prototype F) by Prototector Contra 4 (April 5, 2007 prototype E) by Prototector Contra 4 (April 5, 2007 prototype D) by Prototector Contra 4 (April 5, 2007 prototype C) by Prototector Contra 4 (March 16, 2007 prototype C) by Prototector Contra 4 (March 16, 2007 prototype B) by Prototector Contra 4 (March 7, 2007 prototype C) by Prototector Contra 4 (March 7, 2007 prototype B) by Prototector Contra 4 (February 7, 2007 prototype C) by Prototector Contra 4 (February 7, 2007 prototype B) by Prototector Duty Calls: The Calm Before the Storm (January 31, 2011 17:34:08 prototype) by MrScottyPieey The Suffering: Ties That Bind (Jul 12, 2005 prototype) by Funtimeandrefoxy Superman (Mega Drive prototype) by Lemurboy12 Spider-Man (Accumulators prototype) by Lemurboy12 Wrestle War (Prototype) by Lemurboy12 Daffy Duck in Hollywood (ESB Prototype) by Lemurboy12 Demolition Man (NAPALM prototype) by Lemurboy12 Sonic R (Aug 19, 1999 Network Patch prototype) by Lilithdesign388 Alan Wake (Jan 11, 2010 prototype) by Funtimeandrefoxy Final Fight: Double Impact (Jan 12, 2010 prototype) by Funtimeandrefoxy Lost Odyssey (Dec 13. 2007) by Kabojnk Saints Row (Jul 18, 2006) by Kabojnk The Club (Nov 19, 2007) by Kabojnk Tales of Vesperia (May 04, 2009) by Kabojnk Condemned 2: Bloodshot (Feb 17, 2008 prototype) by Kabojnk Metal Gear Rising: Revengeance (Oct 23, 2012 Demo) by Funtimeandrefoxy Fable 3 (Apr 7, 2011 demo) by Funtimeandrefoxy The Tale of Despereaux (Oct 7, 2008 prototype C) by Kabojnk Borderlands (Aug 27, 2009 Patch Data prototype) by Funtimeandrefoxy Sleeping Dogs (Jul 19, 2012 demo) by Funtimeandrefoxy Corpse Party: Sweet Sachiko’s Hysteric Birthday Bash (Trial demo) by Funtimeandrefoxy Guitar Hero 5 (Jun 24, 2009 prototype) by Funtimeandrefoxy Contra 4 (March 27, 2007 prototype A) by Prototector Cubebert by Dink Men Of Valor (Apr 19, 2004 prototype) by Dink Tom Clancy's Ghost Recon: Future Soldier (Mar 1, 2012 prototype) by Funtimeandrefoxy Tom Clancy's Ghost Recon: Future Soldier (Mar 27, 2012 prototype) by Funtimeandrefoxy Contra 4 (April 5, 2007 prototype B) by Prototector Tom Clancy's Ghost Recon: Future Soldier (Apr 4, 2012 prototype) by Funtimeandrefoxy Split/Second (Apr 13, 2010 Print Preview) by Lahvuun Jackie Chan Adventures (Jun 25, 2003 prototype) by Foulowe59 Tom Clancy's Ghost Recon: Future Soldier (Jul 26, 2011 prototype) by Funtimeandrefoxy Warhammer 40,000: Space Marine (Sep 07, 2011 prototype) by Kabojnk Mighty No. 9 (Aug 14, 2014 Prototype) by Debug Driveclub (Jun 11, 2014 prototype) by Funtimeandrefoxy Tom Clancy's Ghost Recon: Future Soldier (Europe Multiplayer prototype) by Funtimeandrefoxy Contra 4 (March 16, 2007 prototype A) by Prototector Contra 4 (April 5, 2007 prototype A) by Prototector Contra 4 (March 7, 2007 prototype A) by Prototector Contra 4 (February 7, 2007 prototype A) by Prototector Tom Clancy's Ghost Recon: Future Soldier (Jan 3, 2012 prototype) by Funtimeandrefoxy
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, t13.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
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
INNER JOIN
`smw_fpt_cdat` AS t13 ON t0.smw_id=t13.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 (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
t13.o_sortkey DESC
LIMIT
105
OFFSET
15
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, t13.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
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
INNER JOIN
`smw_fpt_cdat` AS t13 ON t0.smw_id=t13.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 (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
t13.o_sortkey DESC
LIMIT
105
OFFSET
15
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 | 50514 | 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 | t8 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t6.o_id | 1 | Using where | |
1 | SIMPLE | t11 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t9.o_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 | t13 | 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 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:7Query-Depth:1
Errors and Warnings
None