Semantic search
Jump to navigation
Jump to search
Query-Depth:1171-5694-01 by Glitchedblood 171-6563A by Glitchedblood 18 Wheeler: American Pro Trucker (Apr 5, 2001 prototype) by Hidden Palace 18 Wheeler: American Pro Trucker (Feb 2, 2001 prototype) by Hidden Palace 18 Wheeler: American Pro Trucker (Nov 12, 2001 prototype) by Lemurboy12 1942: Joint Strike (Apr 17, 2008 prototype) by Hidden Palace 1943: The Battle of Midway (Prototype) by Hidden Palace 1992 Winter CES by Snescentral 2 Games in 1: The SpongeBob SquarePants Movie / Battle for Bikini Bottom (Nov 10, 2005 prototype) by Lemurboy12 2 in 1: Dora the Explorer Double Pack (Prototype) by Hidden Palace 2002 World Cup PK (Design Documents) by SF-Human 2002 World Cup PK (PAL prototype) by SF-Human 2010 FIFA World Cup South Africa (Feb 10, 2010 German and French prototype) by Слава України 2010 FIFA World Cup South Africa (Feb 10, 2010 Italian and Spanish prototype) by Слава України 2010 FIFA World Cup South Africa (Jan 23, 2010 prototype) by Hidden Palace 2010: The Graphic Action Game (Nov 9, 1984 prototype) by Tikal. 2010: The Graphic Action Game (RV44 prototype) by Tikal. 2018 Nintendo data breach by Starfrost 2097 ROM Pack II by Revenant 2420 ROM Pack V by Hidden Palace 2440 ROM Pack by Hidden Palace 24: The Game (Dec 13, 2005 prototype) by Hidden Palace 24: The Game (Jan 10, 2006 prototype) by Imjustatester 24: The Game (Jan 9, 2006 prototype) by Hidden Palace 24: The Game (Nov 28, 2005 prototype) by Hidden Palace 25 to Life (Dec 8, 2005 prototype) by Cut Into Fourteen Pieces 25 to Life (May 24, 2005 prototype) by Czykago 2Xtreme (Aug 29, 1996 prototype) by Hidden Palace 3 Jigen Kakutou Ballz (Prototype) by Lemurboy12 3 on 3 NHL Arcade (Dec 1, 2008 prototype) by Hidden Palace 3 on 3 NHL Arcade (Dec 17, 2008 prototype) by Hidden Palace 3-D Genesis (prototype) by Tikal. 3-D Rubik's Cube (prototype) by Tikal. 3-D Zapper (Dec 15, 1982 prototype) by Tikal. 3-D Zapper (prototype 2) by Tikal. 3D Baseball (Aug 30, 1996 prototype) by Hidden Palace 3D Baseball (Aug 6, 1996 prototype) by Hidden Palace 3D Baseball (Oct 16, 1996 prototype) by Hidden Palace 3D Baseball (Sep 19, 1996 prototype) by Hidden Palace 3D Challenge (Tech Demo) (E3 prototype) by SegaIsOkayIGuess 3D Gunner (Prototype) by Hidden Palace 3D Lemmings (Aug 23, 1995 prototype) by Hidden Palace 3D Lemmings (Aug 8, 1995 prototype) by Hidden Palace 3D Pinball: Space Cadet (Apr 26, 1995 prototype) by Riley 3D Pinball: Space Cadet (July 3, 1995 prototype) by Divingkataetheweirdo 3D Pinball: Space Cadet (June 12, 1995 prototype) by Riley 3D Pinball: Space Cadet (June 16, 1995 prototype) by Riley 3D Pinball: Space Cadet (June 27, 1995 prototype) by Riley 3D Pinball: Space Cadet (May 12, 1995 prototype) by Riley 3D Pinball: Space Cadet (May 26, 1995 prototype) by Riley
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
60
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
60
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 | 50526 | 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 | 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