Semantic search
Jump to navigation
Jump to search
Query-Depth:0
Debug output SQLStore
ASK Query
[[Category:Missing title screenshots]]
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_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=2893)
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
2000
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_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=2893)
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
2000
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 2571 | Using index; 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:1Query-Depth:0
Errors and Warnings
NoneS
- Section 8: Prejudice (Sep 3, 2010 prototype)
- Section 8: Prejudice (Sep 8, 2010 prototype)
- Section 8: Prejudice (Sep 9, 2010 prototype)
- Sega Channel (Feb 16, 1994 prototype)
- Sega Channel (Game Guide Prototype)
- Sega Channel (January 1996 dev disc)
- Sega GT Online (Oct 3, 2003 prototype)
- Sega Rally Championship Plus: NetLink Edition (Apr 16, 1997)
- Sega Rally Revo (Aug 20, 2007 prototype)
- Sega Rally Revo (Jul 26, 2007 prototype)
- Sega Rally Revo (TOKYO GAME SHOW BUILD prototype)
- Sengoku Otome: Legend Battle (Mar 24, 2016 prototype)
- Senran Kagura: Estival Versus (Dec 25, 2015 prototype)
- Serious Sam Double D XXL (Feb 9, 2011 prototype)
- Serious Sam HD: The First Encounter (May 17, 2010 prototype)
- Shadow Complex (Dec 1, 2008 prototype)
- Shadow Complex (Jul 15, 2009 prototype)
S cont.
- Shadow Complex (Mar 12, 2009 prototype)
- Shadow Complex (Mar 7, 2009 Prototype)
- Shadow Vault (Mar 29, 2004 prototype)
- Shadow Vault (Mar 31, 2004 prototype)
- Shadow of Rome (Oct 5, 2004 prototype)
- Shadow of the Colossus (Dec 12, 2005 prototype)
- Shadow of the Colossus (Nov 2, 2005 prototype)
- Shadowrun (May 14, 2007 prototype)
- Shadows of the Damned (Apr 22, 2011 prototype)
- Shattered Steel (Jun 20, 1996 demo)
- Shaun White Snowboarding (Oct 21, 2008 prototype)
- Shaun White Snowboarding (Sep 8, 2008 prototype)
- Shift 2: Unleashed (Mar 2, 2011 prototype)
- Shinobi (Feb 25, 2009 prototype)
- Shovel Knight (Apr 8, 2015 prototype)
- Si Balla (Nov 24, 1994 prototype)
- Signus: The Artifact Wars (Sep 6, 1997 prototype)
S cont.
- Silent Hill 4: The Room (Jun 29, 2004 build)
- Silent Hill HD Collection (Nov 20, 2011 prototype)
- Silent Hill: Downpour (Aug 12, 2011 prototype)
- Silent Hill: Downpour (Aug 3, 2011 prototype)
- Silent Hill: Downpour (Aug 4, 2011 prototype)
- Silent Hill: Downpour (Jan 31, 2012 prototype)
- Silent Hill: Downpour (Jul 11, 2011 prototype)
- Silent Hill: Downpour (Jul 13, 2011 prototype)
- Silent Hill: Downpour (Jul 28, 2011 prototype)
- Silent Hill: Downpour (Jun 12, 2011 prototype)
- Silent Hill: Downpour (Jun 28, 2011 prototype)
- Silent Hill: Downpour (Jun 3, 2011 09.23 prototype)
- Silent Hill: Downpour (Jun 3, 2011 14.07 prototype)
- Silent Hill: Homecoming (Jun 19, 2008 Prototype)
- Silent Scope (Sep 11, 2000 prototype)
- Silver Falls: Ghoul Busters (prototype)