Semantic search
Jump to navigation
Jump to search
Query-Depth:13D Pinball: Space Cadet (May 26, 1995 prototype) by Riley 3D Pocket Pool (Prototype) by Elmotus 3D Realms by Glitchedblood 3D Ultra Mini Golf (Mar 17, 2007 prototype) by Funtimeandrefoxy 3D Ultra MiniGolf Adventures 2 (Jul 23, 2010 prototype) by Funtimeandrefoxy 4 in 1 (Feb 19, 1987 prototype) by Missile 40 Winks (Oct 7, 1999 prototype) by Null 4Chan by Glitchedblood 7 Sins (Sep 29, 2004 prototype) by Cut Into Fourteen Pieces 8 Kings (Aug 7, 2003 prototype) by Funtimeandrefoxy 8 Kings (Jun 5, 2003 prototype) by Funtimeandrefoxy 8 Kings (May 9, 2003 prototype) by Funtimeandrefoxy 8 Kings (Nov 18, 2003 prototype) by Funtimeandrefoxy 8 Kings (Oct 23, 2003 prototype) by Funtimeandrefoxy 8 in 1 (Nov 16, 1992 prototype) by Missile 8Ball Allstars (Aug 15, 2008 Pool prototype) by Tikal. 8Ball Allstars (Feb 11, 2008 prototype) by Tikal. 8Ball Allstars (Feb 26, 2008 prototype) by Tikal. 90 Minutes: European Prime Goal (prototype) by Tikal. ? by Glitchedblood A Boy and His Blob (Jul 21, 2005 prototype) by Lemurboy12 A Boy and His Blob (May 16, 2005 prototype) by Lemurboy12 A Bug's Life (Nov 18, 1998 prototype) by Funtimeandrefoxy A Die Hard X360 Collector by Glitchedblood A Die Hard X60 Collector by Glitchedblood A Kingdom for Keflings (Aug 30, 2008 prototype) by Funtimeandrefoxy A Murder of Crows by Glitchedblood A Week of Garfield (Prototype) by Lemurboy12 A Week of Garfield (Ver 0.9 prototype) by Togemet2 A-Max Boxing (prototype) by Togemet2 A-Max Tennis (prototype) by Togemet2 A-Team (Mar 30, 1984 prototype) by Missile A-Team (May 8, 1984 prototype) by Missile A.J.'s World of Discovery (Apr 5, 1993 prototype) by Arctic Circle System AGING-NTR (Aug 18, 2004 prototype) by Voodooween AMF Bowling (Prototype) by Elmotus ASSEMBler by Glitchedblood ASSEMBler Games by Glitchedblood ASSEMbler by Glitchedblood ASiNUS by Lemurboy12 ATV Offroad Fury 3 (Aug 22, 2004 prototype) by Cut Into Fourteen Pieces ATV Offroad Fury 4 (Oct 2, 2006 prototype) by Cut Into Fourteen Pieces ATV Offroad Fury Pro (Sep 25, 2006 prototype) by Cut Into Fourteen Pieces AUXiSO by Lilithdesign388 Aardman Intro (Tech Demo) (prototype) by Thomas Abomination: The Nemesis Project (Sep 15, 1999 prototype) by Cut Into Fourteen Pieces Absolute X (Prototype) by Elmotus Acclaim Entertainment by Glitchedblood Accumulators by Lemurboy12 Ace Combat 04: Shattered Skies (Nov 14, 2001 prototype) by Cut Into Fourteen Pieces
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, 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
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
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
t0.smw_sort ASC
LIMIT
55
OFFSET
45
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
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
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
t0.smw_sort ASC
LIMIT
55
OFFSET
45
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 | 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 | |
| 1 | SIMPLE | t11 | ref | PRIMARY, smw_id, smw_sortkey | smw_id | 4 | hp_wiki_new.t9.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