Semantic search
Jump to navigation
Jump to search
Query-Depth:1Halo 4 (Jan 14, 2013 prototype) by Funtimeandrefoxy Skullgirls (prototype) by MrScottyPieey Shadow of Rome (Oct 5, 2004 prototype) by Hidden Palace Black & White: Creatures (prototype) by Tikal. Osiris (prototype) by Tikal. It Lives! (prototype) by Tikal. Alien Friends (prototype) by Tikal. Hellfire (Jul 10, 1990 prototype) by Hidden Palace Pizza Tower (October 8, 2018 prototype) by Nunof Yerbizness Grand Theft Auto: London 1969 (Apr 11, 1999 prototype) by UNKNOWNED Smuggler's Run (July prototype) by UNKNOWNED Midnight Club: Street Racing (Jul 25, 2000 prototype) by UNKNOWNED Thrasher Presents: Skate and Destroy (prototype) by UNKNOWNED Smuggler's Run (July 22,2000 prototype) by UNKNOWNED Smuggler's Run (July 13,2000 prototype) by UNKNOWNED Section 8: Prejudice (Oct 10, 2010 A prototype) by Funtimeandrefoxy Contra 4 (May 21, 2007 prototype C) by Prototector Contra 4 (May 21, 2007 prototype B) by Prototector Contra 4 (May 21, 2007 prototype A) by Prototector Contra 4 (April 10, 2007 prototype C) by Prototector Contra 4 (April 10, 2007 prototype B) by Prototector Contra 4 (April 10, 2007 prototype A) by Prototector Contra 4 (February 18, 2007 prototype C) by Prototector Contra 4 (February 18, 2007 prototype B) by Prototector Contra 4 (February 18, 2007 prototype A) by Prototector Contra 4 (March 27, 2007 prototype C) by Prototector Contra 4 (March 27, 2007 prototype B) by Prototector Contra 4 (July 18, 2007 prototype C) by Prototector Contra 4 (July 18, 2007 prototype B) by Prototector Contra 4 (August 28, 2007 prototype B) by Prototector Section 8: Prejudice (Dec 16, 2010 Stress Test) by Funtimeandrefoxy Contra 4 (October 15, 2007 prototype A) by Prototector E3 2012 Nintendo Press Kit by Funtimeandrefoxy Contra 4 (January 24, 2008 prototype) by Prototector Contra 4 (December 19, 2007 prototype) by Prototector Contra 4 (October 15, 2007 prototype B) by Prototector Contra 4 (September 5, 2007 prototype) by Prototector Contra 4 (August 28, 2007 prototype A) by Prototector Contra 4 (August 13, 2007 prototype C) by Prototector Contra 4 (August 13, 2007 prototype B) by Prototector Contra 4 (August 13, 2007 prototype A) by Prototector Contra 4 (July 24, 2007 prototype C) by Prototector Contra 4 (July 24, 2007 prototype B) by Prototector Contra 4 (July 24, 2007 prototype A) by Prototector Contra 4 (July 18, 2007 prototype A) by Prototector Contra 4 (July 11, 2007 prototype F) by Prototector Contra 4 (July 11, 2007 prototype E) by Prototector Contra 4 (July 11, 2007 prototype D) by Prototector Contra 4 (July 11, 2007 prototype C) by Prototector Contra 4 (July 11, 2007 prototype B) by Prototector
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, t10.o_sortkey
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
INNER JOIN
`smw_fpt_cdat` AS t10 ON t0.smw_id=t10.s_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
t10.o_sortkey DESC
LIMIT
55
OFFSET
10
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, t10.o_sortkey
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
INNER JOIN
`smw_fpt_cdat` AS t10 ON t0.smw_id=t10.s_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
t10.o_sortkey DESC
LIMIT
55
OFFSET
10
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 | 50515 | 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 | t10 | ref | s_id | s_id | 4 | hp_wiki_new.t3.s_id | 1 | ||
| 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