Semantic search
Jump to navigation
Jump to search
Query-Depth:1Aliens: Colonial Marines (May 31, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (May 4, 2011 prototype) by Dink Aliens: Colonial Marines (May 4, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (May 7, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (May 8, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 1, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 13, 2012 16.24 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 13, 2012 20.35 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 15, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 16, 2011 10.29 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 16, 2011 14.27 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 17, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 19, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 2, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 21, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 29, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 29, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Nov 7, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 10, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 15, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 22, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 23, 2012 10.29 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 23, 2012 21.03 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 24, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 3, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 5, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 8, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 9, 2012 06.43 prototype) by Hidden Palace Aliens: Colonial Marines (Oct 9, 2012 21.38 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 13, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 24, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 25, 2012 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 29, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 30, 2011 prototype) by Hidden Palace Aliens: Colonial Marines (Sep 6, 2012 prototype) by Hidden Palace All Kamen Rider: Rider Generation (Jun 2, 2011 prototype) by Lemurboy12 All Round Hunter (Apr 16, 2010 prototype) by Hidden Palace All Round Hunter (Apr 20, 2010 prototype) by Hidden Palace All Round Hunter (Mar 5, 2010 prototype) by Hidden Palace All Star Baseball 2003 (Jan 16, 2002 prototype) by Lemurboy12 All Star Soccer (May 26, 1997 prototype) by Cut Into Fourteen Pieces All Star Tennis 2000 (Localization prototype) by Elmotus All Star Tennis 2000 (Prototype) by Elmotus All Zombies Must Die! (Oct 10, 2011 prototype) by Hidden Palace All-Pro Football 2K8 (Jul 11, 2007 prototype) by Hidden Palace All-Star Baseball 2001 (Broken prototype) by Lemurboy12 All-Star Baseball 2001 (Prototype) by Lemurboy12 All-Star Baseball 2003 featuring Derek Jeter (Jan 16, 2002 prototype) by Lemurboy12 All-Star Baseball 2003 featuring Derek Jeter (Jan 21, 2002 prototype) by Hidden Palace All-Star Baseball 2003 featuring Derek Jeter (May 23, 2002 build) by Lemurboy12
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
510
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
510
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