Semantic search
Jump to navigation
Jump to search
Query-Depth:14 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 A.J.'s World of Discovery (Apr 5, 1993 prototype) by Arctic Circle System ACHEESEDANISH by Hidden Palace AGING-NTR (Aug 18, 2004 prototype) by Voodooween AH-64D Apache (Mar 26, 2003 prototype) by Hidden Palace AMF Bowling (Prototype) by Elmotus
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
115
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
115
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