Semantic search
Jump to navigation
Jump to search
Query-Depth:1Aero 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 Aetius For Real by Hidden Palace Affinix Software by Glitchedblood Afro Samurai (Dec 1, 2008 prototype) by Hidden Palace Afro Samurai (Oct 30, 2008 prototype) by Hidden Palace After Burner Climax (Dec 11, 2009 prototype) by Hidden Palace Aftershock (May 3, 1995 prototype) by Hidden Palace Agaju: The Sacred Path of Treasure (Prototype) by Hidden Palace Agartha (Apr 17, 2001 prototype) by Sega Dreamcast Info Agartha (Apr 18, 2001 prototype) by Hidden Palace Agartha (Mar 5, 2001 prototype) by Hidden Palace Agartha (Mar 9, 2001 prototype) by Hairygarlic Age of Booty (Jun 24, 2008 prototype) by Hidden Palace Age of Booty (May 28, 2008 prototype) by Hidden Palace 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 (Aug 6, 2002 prototype) by Hidden Palace Aggressive Inline (Jul 29, 2002 prototype) by Hidden Palace 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 (Feb 10, 2000 prototype) by Hidden Palace Aidyn Chronicles: The First Mage (Mar 2, 2001 prototype) by Lemurboy12 Aidyn Chronicles: The First Mage (May 9, 2000 prototype) by Hidden Palace Air Fortress (Prototype) by Hidden Palace Air Sea Battle (Robert Coppock Demo) by Missile Air Zonk (Prototype) by Hidden Palace AirBlade (Nov 8, 2001 prototype) by Hidden Palace AirCars (Nov 14, 1994 prototype) by Hidden Palace AirForce Delta (Jun 18, 1999 prototype) by Hidden Palace AirForce Delta (Nov 30, 1999 prototype) by Hidden Palace AirMech Arena (Aug 15, 2014 prototype) by Hidden Palace Airblade (Sep 16, 2001 prototype) by Hidden Palace Airburst (Jul 13, 2008 prototype) by Hidden Palace Airlock (prototype) by Tikal.
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
260
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
260
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 | 50513 | 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 | t8 | eq_ref | PRIMARY, smw_id, smw_sortkey | PRIMARY | 4 | hp_wiki_new.t6.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 | 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:5Query-Depth:1
Errors and Warnings
None