Semantic search
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
15
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 |
Query-Depth:1
100 Bullets (Jun 30, 2004 prototype) (Page creatorThis property is a special property in this wiki.: Cut Into Fourteen Pieces), 13thVessel (Page creatorThis property is a special property in this wiki.: Glitchedblood), 171-5694-01 (Page creatorThis property is a special property in this wiki.: Glitchedblood), 171-6563A (Page creatorThis property is a special property in this wiki.: Glitchedblood), 18 Wheeler: American Pro Trucker (Nov 12, 2001 prototype) (Page creatorThis property is a special property in this wiki.: Lemurboy12), 1992 Winter CES (Page creatorThis property is a special property in this wiki.: Snescentral), 2 Games in 1: The SpongeBob SquarePants Movie / Battle for Bikini Bottom (Nov 10, 2005 prototype) (Page creatorThis property is a special property in this wiki.: Lemurboy12), 2002 World Cup PK (Design Documents) (Page creatorThis property is a special property in this wiki.: SF-Human), 2002 World Cup PK (PAL prototype) (Page creatorThis property is a special property in this wiki.: SF-Human), 2010 FIFA World Cup South Africa (Feb 10, 2010 German and French prototype) (Page creatorThis property is a special property in this wiki.: Слава України), 2010 FIFA World Cup South Africa (Feb 10, 2010 Italian and Spanish prototype) (Page creatorThis property is a special property in this wiki.: Слава України), 2010: The Graphic Action Game (Nov 9, 1984 prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 2010: The Graphic Action Game (RV44 prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 2018 Nintendo data breach (Page creatorThis property is a special property in this wiki.: Starfrost), 2097 ROM Pack II (Page creatorThis property is a special property in this wiki.: Revenant), 24: The Game (Jan 10, 2006 prototype) (Page creatorThis property is a special property in this wiki.: Imjustatester), 25 to Life (Dec 8, 2005 prototype) (Page creatorThis property is a special property in this wiki.: Cut Into Fourteen Pieces), 25 to Life (May 24, 2005 prototype) (Page creatorThis property is a special property in this wiki.: Czykago), 3 Jigen Kakutou Ballz (Prototype) (Page creatorThis property is a special property in this wiki.: Lemurboy12), 3-D Genesis (prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 3-D Rubik's Cube (prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 3-D Zapper (Dec 15, 1982 prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 3-D Zapper (prototype 2) (Page creatorThis property is a special property in this wiki.: Tikal.), 3D Challenge (Tech Demo) (E3 prototype) (Page creatorThis property is a special property in this wiki.: SegaIsOkayIGuess), 3D Pinball: Space Cadet (Apr 26, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pinball: Space Cadet (July 3, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Divingkataetheweirdo), 3D Pinball: Space Cadet (June 12, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pinball: Space Cadet (June 16, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pinball: Space Cadet (June 27, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pinball: Space Cadet (May 12, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pinball: Space Cadet (May 26, 1995 prototype) (Page creatorThis property is a special property in this wiki.: Riley), 3D Pocket Pool (Prototype) (Page creatorThis property is a special property in this wiki.: Elmotus), 3D Realms (Page creatorThis property is a special property in this wiki.: Glitchedblood), 3D Ultra Mini Golf (Mar 17, 2007 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 3D Ultra MiniGolf Adventures 2 (Jul 23, 2010 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 4 in 1 (Feb 19, 1987 prototype) (Page creatorThis property is a special property in this wiki.: Missile), 40 Winks (Oct 7, 1999 prototype) (Page creatorThis property is a special property in this wiki.: Null), 4Chan (Page creatorThis property is a special property in this wiki.: Glitchedblood), 7 Sins (Sep 29, 2004 prototype) (Page creatorThis property is a special property in this wiki.: Cut Into Fourteen Pieces), 8 Kings (Aug 7, 2003 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 8 Kings (Jun 5, 2003 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 8 Kings (May 9, 2003 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 8 Kings (Nov 18, 2003 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 8 Kings (Oct 23, 2003 prototype) (Page creatorThis property is a special property in this wiki.: Funtimeandrefoxy), 8 in 1 (Nov 16, 1992 prototype) (Page creatorThis property is a special property in this wiki.: Missile), 8Ball Allstars (Aug 15, 2008 Pool prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 8Ball Allstars (Feb 11, 2008 prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 8Ball Allstars (Feb 26, 2008 prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), 90 Minutes: European Prime Goal (prototype) (Page creatorThis property is a special property in this wiki.: Tikal.), ? (Page creatorThis property is a special property in this wiki.: Glitchedblood)