Semantic search
Jump to navigation
Jump to search
Query-Depth:1
Debug output SQLStore
ASK Query
[[Has status::Released, redump needed||Released]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
((t1.o_hash='Released, redump needed') OR (t1.o_hash='Released')
) AND t1.p_id=2412)
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
4000
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
((t1.o_hash='Released, redump needed') OR (t1.o_hash='Released')
) AND t1.p_id=2412)
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
4000
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, o_hash, s_id_2 | p_id | 4 | const | 21773 | Using index condition; 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:3Query-Depth:1
Errors and Warnings
NoneDate | System | Genre | Unreleased | |
---|---|---|---|---|
Gauntlet Legends (May 26, 2000 prototype) | 26 May 2000 12:24:24 | Dreamcast | Role playing | - |
Gauntlet: Dark Legacy (Feb 6, 2001 prototype) | 6 February 2001 13:18:37 | PlayStation 2 | Action RPG | - |
Gauntlet: Dark Legacy (Mar 19, 2001 build) | 19 March 2001 | PlayStation 2 | - | |
Gears of War (Jan 22, 2006 prototype) | 22 January 2006 | Xbox 360 | Third-person shooter | - |
Gears of War (Jan 22, 2007 prototype) | 22 January 2007 16:23:45 | Xbox 360 | Third Person Shooter | - |
Gears of War (Nov 11, 2006 prototype) | 11 November 2006 22:01:35 | Xbox 360 | Third Person Shooter | - |
Gears of War (Oct 2, 2006 prototype) | 2 October 2006 07:49:27 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 14, 2006 prototype) | 14 September 2006 00:00:00 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 21, 2006 prototype) | 21 September 2006 00:00:00 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 23, 2006 prototype) | 23 September 2006 11:34:59 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 25, 2006 prototype) | 25 September 2006 09:09:43 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 27, 2006 prototype) | 27 September 2006 09:15:15 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 29, 2006 12.46 prototype) | 29 September 2006 12:46:14 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 29, 2006 22.09 prototype) | 29 September 2006 22:09:16 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 3, 2006 prototype) | 3 September 2006 | Xbox 360 | Third-person shooter | - |
Gears of War (Sep 4, 2006 prototype) | 4 September 2006 00:19:53 | Xbox 360 | Third Person Shooter | - |
Gears of War (Sep 6, 2006 prototype) | 6 September 2006 | Xbox 360 | Third Person Shooter | - |
Gears of War 2 (Apr 29, 2008 prototype) | 29 April 2008 19:09:42 | Xbox 360 | Third Person Shooter | - |
Gears of War 2 (Apr 29, 2010 TU6 prototype) | 29 April 2010 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Apr 4, 2008 prototype) | 4 April 2008 06:46:56 | Xbox 360 | Third Person Shooter | - |
Gears of War 2 (DLC Combustible Multiplayer Map Pack prototype) | Xbox 360 | Action, Shooter | - | |
Gears of War 2 (Dec 2, 2008 2 Test DLCs + DLC Combustible Multiplayer Map Pack prototype) | 2 December 2008 11:21:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Feb 1, 2008 prototype) | 1 February 2008 | Xbox 360 | Third Person Shooter | - |
Gears of War 2 (Feb 12, 2008 prototype) | 12 February 2008 23:22:56 | Xbox 360 | First Person Shooter | - |
Gears of War 2 (Feb 20, 2009 DLC Snowblind Map Pack prototype) | 20 February 2009 05:11:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Jan 6, 2009 TU2 prototype) | 6 January 2009 17:17:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Mar 4, 2009 TU3 prototype) | 4 March 2009 21:51:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (May 8, 2009 prototype) | 8 May 2009 | Xbox 360 | First Person Shooter | - |
Gears of War 2 (Nov 21, 2008 TU1 prototype) | 21 November 2008 17:58:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Sep 14, 2008 prototype) | 14 September 2008 15:12:04 | Xbox 360 | Third Person Shooter | - |
Gears of War 2 (Sep 23, 2008 DLC Flashback Multiplayer Pack prototype) | 23 September 2008 12:44:00 | Xbox 360 | Action, Shooter | - |
Gears of War 2 (Sep 23, 2008 DLC Gold-Plated Hammerburst Assault Riffle prototype) | Xbox 360 | Action, Shooter | - | |
Gears of War 2 (Sep 23, 2008 DLC Gold-Plated Lancer Assault Rifle prototype) | Xbox 360 | Action, Shooter | - | |
Gears of War 3 (Apr 22, 2011 prototype) | 22 April 2011 21:43:01 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Apr 8, 2010 prototype) | 8 April 2010 | Xbox 360 | Third-person shooter | - |
Gears of War 3 (Apr 8, 2011 prototype) | 8 April 2011 18:53:05 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Dec 21, 2010 Multiplayer Prototype) | 21 December 2010 03:38:01 | Xbox 360 | Third Person Shooter | - |
Gears of War 3 (Jan 10, 2011 prototype) | 10 January 2011 12:42:27 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jan 11, 2011 prototype) | 11 January 2011 20:00:19 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jan 12, 2011 prototype) | 12 January 2011 07:33:47 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jan 20, 2011 prototype) | 20 January 2011 12:40:56 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jan 24, 2011 PC prototype) | 24 January 2011 | PC | Third-person shooter | ✓ |
Gears of War 3 (Jan 24, 2011 PS3 prototype) | 24 January 2011 | PlayStation 3 | Action, Shooter | ✓ |
Gears of War 3 (Jan 24, 2011 Xbox 360 prototype) | 24 January 2011 | Xbox 360 | Third-person shooter | - |
Gears of War 3 (Jan 8, 2011 prototype) | 8 January 2011 | Xbox 360 | Third-person shooter | - |
Gears of War 3 (Jun 1, 2011 prototype) | 1 June 2011 22:16:39 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jun 14, 2010 prototype) | 14 June 2010 15:27:24 | Xbox 360 | First Person Shooter | - |
Gears of War 3 (Jun 29, 2011 prototype) | 29 June 2011 | Xbox 360 | Third-person shooter | - |
Gears of War 3 (Jun 3, 2010 E3 prototype) | 3 June 2010 | Xbox 360 | Third-person shooter | - |
Gears of War 3 (Jun 3, 2010 prototype) | 3 June 2010 06:47:01 | Xbox 360 | First Person Shooter | - |