Semantic search
Jump to navigation
Jump to search
Query-Depth:1Contra 4 (May 21, 2007 prototype A) by Prototector Contra 4 (April 10, 2007 prototype C) by Prototector Contra 4 (April 10, 2007 prototype B) by Prototector Contra 4 (April 10, 2007 prototype A) by Prototector Contra 4 (February 18, 2007 prototype C) by Prototector Contra 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 Iron Phoenix (May 9, 2004 prototype) by Hidden Palace Jade Empire (Mar 2, 2005 prototype) by Hidden Palace Turok: Evolution (Jun 21, 2002 prototype) by Hidden Palace Kill.switch (May 13, 2003 prototype) by Hidden Palace Kill.switch (Sep 7, 2003 prototype) by Hidden Palace Kill.switch (May 12, 2003 prototype) by Hidden Palace Kill.switch (Aug 21, 2003 22.14 prototype) by Hidden Palace Kill.switch (Aug 21, 2003 15.16 prototype) by Hidden Palace 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
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
10
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
10
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