Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Page creator::User:Slycooper124]]
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_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=4245 AND t1.o_id=176277)
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_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id=4245 AND t1.o_id=176277)
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 | t1 | ref | s_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3 | o_id | 5 | const | 368 | Using where; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | hp_wiki_new.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None- Call of Duty: Black Ops II (Nov 15, 2011 Singleplayer/Multiplayer Prototype)
- Call of Duty: Modern Warfare 2 (Jul 13, 2009 prototype)
- Call of Duty: World at War (Mar 27, 2007 Singleplayer/Multiplayer Prototype)
- Call of Duty: World at War (Sep 25, 2008 Multiplayer Prototype)
- Call of Juarez Bound in Blood (2009-03-07).7z
- Call of Juarez: Bound in Blood (Mar 7, 2009 prototype)
- Crimson Dragon (Mar 27 2012).rar
- Crimson Dragon (Mar 27, 2012 Prototype)
- Crysis 2 (5782 2011-02-07).7z
- Crysis 2 (5825 2011-02-16).7z
- Crysis 2 (Feb 16, 2011 Prototype)
- Crysis 2 (Feb 7, 2011 Prototype)
- Crysis 2 (Multiplayer Beta, Sep 07 2010).rar
- Crysis 2 (Sep, 7, 2010 Multiplayer Prototype)
- Crysis 3 (130 2011-07-16).7z
- Crysis 3 (1617 2012-12-13).7z
- Crysis 3 (1632 2012-12-17).7z
- Crysis 3 (1659 2012-12-27).7z
- Crysis 3 (1686, Jan 16 2013).rar
- Crysis 3 (998, May 29 2012).rar
- Crysis 3 (Dec 13, 2012 Prototype)
- Crysis 3 (Dec 17, 2012 Prototype)
- Crysis 3 (Dec 27, 2012 Prototype)
- Crysis 3 (Jan 15, 2013 07.09 Prototype)
- Crysis 3 (Jan 4, 2013 Multiplayer Prototype)
- Crysis 3 (Jul 16, 2011 prototype)
- Crysis 3 (May 29, 2012 Prototype)
- Crysis 3 (Multiplayer Beta, Jan 04 2013).rar
- Dance Central (Aug 10, 2010 Takehome Beta)
- Dance Central (Takehome Beta, Aug 10 2010).rar
- Dance Central 2 (Jul 25, 2011 Takehome Beta)
- Dance Central 2 (Takehome Beta, Jul 25 2011).rar
- Dark Fathoms (May 07, 2009 Tech Demo)
- Dark Fathoms (Tech Demo 2009-05-07).7z
- Dark Void (291839 2009-10-27).7z
- Dark Void (Oct 27, 2009 Prototype)
- Dead Rising 2 Case Zero (357455 2010-06-07).7z
- Dead Rising 2 Case Zero (Jul 08 2010).rar
- Dead Rising 2: Case Zero (Jul 8, 2010 Prototype)
- Dead Rising 2: Case Zero (Jun 7, 2010 prototype)
- Dead Space 2 (208487 2010-11-19).7z
- Dead Space 2 (Nov 19, 2010 Prototype)
- Deep 6 (Engine Demo 2009-07-10).7z
- Deep 6 (Jul 10, 2009 Engine Demo)
- Defiance (2012-11-30).7z
- Defiance (Nov 30, 2012 Prototype)
- Dragon Ball Z Ultimate Tenkaichi (Jun 21 2011).rar
- Dragon Ball Z Ultimate Tenkaichi (Jun 21, 2011 Prototype)
- Dungeon Defenders (Jun 28 2011).rar
- Dungeon Defenders (Jun 28, 2011 Prototype)