Semantic search
Jump to navigation
Jump to search
Query-Depth:1Benefactor by Glitchedblood BetaArchive by Glitchedblood BetaCollector by Farmerbb Beyond (Sep 12, 2005 prototype) by Cut Into Fourteen Pieces Beyond Divinity (Feb 26, 2004 demo) by Nex Beyond Good & Evil (Oct 13, 2003 prototype) by Cut Into Fourteen Pieces Beyond Good & Evil HD (Mar 3, 2006 Preview prototype) by Funtimeandrefoxy Beyond Good & Evil HD (Mar 3, 2006 Review prototype) by Funtimeandrefoxy Beyond: Two Souls (Aug 20, 2013 prototype) by Catsus Beyond: Two Souls (Jun 9, 2013 prototype) by Catsus Beyond: Two Souls (Nov 6, 2012 prototype) by Mementomori Big Bang Pro Wrestling (Prototype) by Kiddo Big Bird's Egg Catch (Dec 8, 1982 prototype) by Missile Big Bird's Egg Catch (May 17, 1983 prototype) by Missile Big Bird's Egg Catch (May 2, 1983 prototype) by Missile Big Bumpin' (Sep 15, 2006 prototype) by Dink Big Hero 6: Battle in the Bay (Apr 24, 2014 prototype) by Tikal. Big Top Circus (Prototype) by Lemurboy12 Bigmak by Glitchedblood Bikerspade by Lilithdesign388 Bikespade by Lilithdesign388 Bill Narum by Glitchedblood Bio Force Ape (Prototype) by Adiguvicx BioShock 2 (Dec 16, 2009 prototype) by Cut Into Fourteen Pieces BioShock 2 (Nov 30, 2009 prototype) by Cut Into Fourteen Pieces Biohazard Outbreak (Dec 19, 2003 prototype) by Czykago Bionic Breakthrough (Jun 22, 1984 prototype) by Missile Bionic Breakthrough (prototype) by Missile Bionicle 2: City of Legends (Dec 9, 2003 tech demo) by Tikal. Bionicle 2: City of Legends (Jan 16, 2004 tech demo) by SerchioWrld Bionicle 2: City of Legends (Jan 19, 2004 tech demo) by Tikal. Bionicle Heroes (Sep 28, 2006 prototype) by Tikal. Bionicle Heroes (Sep 4, 2006 prototype) by Tikal. Birds of Steel (Oct 9, 2011 prototype) by Funtimeandrefoxy Black & White: Creatures (Dec 9, 2005 prototype) by Tikal. Black & White: Creatures (May 13, 2005 Nintendo DS prototype) by Tikal. Black & White: Creatures (Nintendo DS prototype) by Tikal. Black (Dec 5, 2005 demo) by Czykago Black (Nov 25, 2005 demo) by Czykago Black 2 (Feb 13, 2007 prototype) by Czykago Black 2 (Jun 29, 2006 prototype) by Czykago Black 9 (Jan 13, 2004 prototype) by Gmestanley Black Knight Sword (Feb 28, 2012 Prototype) by Slycooper124 Black Mesa (May 8, 2006 prototype - Alpha 5) by Lilithdesign388 BlackSite: Area 51 (Aug 15, 2007 prototype) by Slycooper124 BlackThorne (CES prototype) by Tikal. Blade Kitten (Jul 7, 2010 prototype) by Funtimeandrefoxy Blades of Time (prototype) by Catsus Blank by Nunof Yerbizness Blassster by Glitchedblood
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
515
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
515
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