Semantic search
Jump to navigation
Jump to search
Query-Depth:13D 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 3DO M2 Shooter Demo by Hidden Palace 4 Wheel Thunder (Jan 26, 2000 prototype) by Hidden Palace 4 Wheel Thunder (Jan 29, 2000 prototype) by Hidden Palace 4 Wheel Thunder (Mar 31, 2000 prototype) by Hidden Palace 4 Wheel Thunder (Nov 5, 1999 prototype) by Hidden Palace 4 in 1 (Feb 19, 1987 prototype) by Missile 40 Winks (Oct 7, 1999 prototype) by Null 4Chan by Glitchedblood 4x4 Evolution (Jan 9, 2001 prototype) by Hidden Palace 500 Years After (Mar 1, 1993 prototype) by Hidden Palace 64DD IPL (US Prototype) by Hidden Palace 64DD IPL Disk (v1.0) by Hidden Palace 64DD IPL Disk (v1.1) by Hidden Palace 64DD TOOL IPL (Development Drive) by Hidden Palace 6GUN (May 31, 2005 prototype) by Hidden Palace 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. 90 Minutes: Sega Championship Football (Sep 18, 2001 prototype) by Hidden Palace ? 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 (Apr 14, 2009 prototype) by Hidden Palace A Kingdom for Keflings (Aug 30, 2008 prototype) by Funtimeandrefoxy A Kingdom for Keflings (Oct 29, 2008 prototype) by Hidden Palace A Murder of Crows by Glitchedblood A Night in Nylon City (Oct 28, 1994 prototype) by Hidden Palace A Week of Garfield (Prototype) by Lemurboy12 A Week of Garfield (Ver 0.9 prototype) by Togemet2 A World of Keflings (Feb 27, 2010 prototype) by Hidden Palace A World of Keflings (Oct 19, 2010 prototype) by Hidden Palace 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
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
110
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
110
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 | 50517 | 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