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
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_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
2000
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 | 21747 | 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 | Article Added"Creation date" is a predefined property that corresponds to the date of the first revision of a subject and is provided by <a rel="nofollow" class="external text" href="https://www.semantic-mediawiki.org/wiki/Help:Special_properties">Semantic MediaWiki</a>. | Unreleased | |
---|---|---|---|---|---|
Contra 4 (April 4, 2007 prototype A) | 4 April 2007 | Nintendo DS | 22 May 2024 22:40:28 | - | |
Contra 4 (April 4, 2007 prototype B) | 4 April 2007 | Nintendo DS | 22 May 2024 22:40:52 | - | |
Contra 4 (April 4, 2007 prototype C) | 4 April 2007 | Nintendo DS | 22 May 2024 22:41:15 | - | |
Contra 4 (April 5, 2007 prototype A) | 5 April 2007 | Nintendo DS | 19 April 2024 21:40:20 | - | |
Contra 4 (April 5, 2007 prototype B) | 5 April 2007 | Nintendo DS | 23 April 2024 21:33:42 | - | |
Contra 4 (April 5, 2007 prototype C) | 5 April 2007 | Nintendo DS | 4 May 2024 16:51:47 | - | |
Contra 4 (April 5, 2007 prototype D) | 5 April 2007 | Nintendo DS | 4 May 2024 16:52:27 | - | |
Contra 4 (April 5, 2007 prototype E) | 5 April 2007 | Nintendo DS | 4 May 2024 16:53:06 | - | |
Contra 4 (April 5, 2007 prototype F) | 5 April 2007 | Nintendo DS | 4 May 2024 16:53:37 | - | |
Contra 4 (August 13, 2007 prototype A) | 13 August 2007 | Nintendo DS | 4 May 2024 17:14:34 | - | |
Contra 4 (August 13, 2007 prototype B) | 13 August 2007 | Nintendo DS | 4 May 2024 17:15:07 | - | |
Contra 4 (August 13, 2007 prototype C) | 13 August 2007 | Nintendo DS | 4 May 2024 17:15:35 | - | |
Contra 4 (August 28, 2007 prototype A) | 28 August 2007 | Nintendo DS | 4 May 2024 17:16:14 | - | |
Contra 4 (August 28, 2007 prototype B) | 28 August 2007 | Nintendo DS | 7 May 2024 22:56:34 | - | |
Contra 4 (August 7, 2007 prototype) | 7 August 2007 | Nintendo DS | 17 April 2024 00:38:30 | - | |
Contra 4 (August 8, 2007 18:30:54 prototype) | 8 August 2007 18:30:54 | Nintendo DS | 17 April 2024 00:40:12 | - | |
Contra 4 (August 8, 2007 18:47:29 prototype) | 8 August 2007 18:47:29 | Nintendo DS | 17 April 2024 00:41:41 | - | |
Contra 4 (August 8, 2007 21:39:53 prototype) | 8 August 2007 21:39:53 | Nintendo DS | 17 April 2024 00:46:34 | - | |
Contra 4 (December 19, 2007 prototype) | 19 December 2007 | Nintendo DS | 4 May 2024 17:18:56 | - | |
Contra 4 (February 12, 2007 prototype A) | 12 February 2007 | Nintendo DS | 22 May 2024 22:34:34 | - | |
Contra 4 (February 12, 2007 prototype B) | 12 February 2007 | Nintendo DS | 22 May 2024 22:35:02 | - | |
Contra 4 (February 12, 2007 prototype C) | 12 February 2007 | Nintendo DS | 22 May 2024 22:35:27 | - | |
Contra 4 (February 15, 2007 prototype A) | 15 February 2007 | Nintendo DS | 19 May 2024 19:27:21 | - | |
Contra 4 (February 15, 2007 prototype B) | 15 February 2007 | Nintendo DS | 19 May 2024 19:27:49 | - | |
Contra 4 (February 15, 2007 prototype C) | 15 February 2007 | Nintendo DS | 19 May 2024 19:28:21 | - | |
Contra 4 (February 18, 2007 prototype A) | 18 February 2007 | Nintendo DS | 7 May 2024 23:00:36 | - | |
Contra 4 (February 18, 2007 prototype B) | 18 February 2007 | Nintendo DS | 7 May 2024 23:01:03 | - | |
Contra 4 (February 18, 2007 prototype C) | 18 February 2007 | Nintendo DS | 7 May 2024 23:01:31 | - | |
Contra 4 (February 2, 2007 prototype A) | 2 February 2007 | Nintendo DS | 19 May 2024 19:25:26 | - | |
Contra 4 (February 2, 2007 prototype B) | 2 February 2007 | Nintendo DS | 19 May 2024 19:26:02 | - | |
Contra 4 (February 2, 2007 prototype C) | 2 February 2007 | Nintendo DS | 19 May 2024 19:26:42 | - | |
Contra 4 (February 22, 2007 prototype) | 22 February 2007 | Nintendo DS | 19 May 2024 19:28:49 | - | |
Contra 4 (February 26, 2007 prototype) | 26 February 2007 | Nintendo DS | 19 May 2024 19:29:18 | - | |
Contra 4 (February 5, 2007 prototype) | 5 February 2007 | Nintendo DS | 22 May 2024 22:34:05 | - | |
Contra 4 (February 7, 2007 prototype A) | 7 February 2007 | Nintendo DS | 19 April 2024 21:37:36 | - | |
Contra 4 (February 7, 2007 prototype B) | 7 February 2007 | Nintendo DS | 4 May 2024 16:46:46 | - | |
Contra 4 (February 7, 2007 prototype C) | 27 February 2007 | Nintendo DS | 4 May 2024 16:47:56 | - | |
Contra 4 (January 23, 2008 prototype A) | 23 January 2008 | Nintendo DS | 17 April 2024 00:48:11 | - | |
Contra 4 (January 23, 2008 prototype B) | 23 January 2008 | Nintendo DS | 17 April 2024 00:49:02 | - | |
Contra 4 (January 24, 2008 prototype) | 24 January 2008 | Nintendo DS | 4 May 2024 17:19:35 | - | |
Contra 4 (January 31, 2007 prototype A) | 31 January 2007 | Nintendo DS | 11 May 2024 19:08:13 | - | |
Contra 4 (January 31, 2007 prototype B) | 31 January 2007 | Nintendo DS | 11 May 2024 19:08:39 | - | |
Contra 4 (January 31, 2007 prototype C) | 31 January 2007 | Nintendo DS | 11 May 2024 19:09:08 | - | |
Contra 4 (July 11, 2007 prototype A) | 11 July 2007 | Nintendo DS | 4 May 2024 17:07:37 | - | |
Contra 4 (July 11, 2007 prototype B) | 11 July 2007 | Nintendo DS | 4 May 2024 17:08:10 | - | |
Contra 4 (July 11, 2007 prototype C) | 11 July 2007 | Nintendo DS | 4 May 2024 17:09:16 | - | |
Contra 4 (July 11, 2007 prototype D) | 11 July 2007 | Nintendo DS | 4 May 2024 17:09:44 | - | |
Contra 4 (July 11, 2007 prototype E) | 11 July 2007 | Nintendo DS | 4 May 2024 17:10:11 | - | |
Contra 4 (July 11, 2007 prototype F) | 11 July 2007 | Nintendo DS | 4 May 2024 17:10:50 | - | |
Contra 4 (July 18, 2007 prototype A) | 18 July 2007 | Nintendo DS | 4 May 2024 17:12:29 | - |