Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Has status::Released, redump needed||Released]]
 |?Has build date=Date
 |?Has system=System
 |?Has genre=Genre
 |?Is unreleased#✓,-=Unreleased
 |format=table
 |limit=50
 |offset=2100
 |sort=
 |order=asc
}}

Results 2,101 – 2,150 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Has status::Released, redump needed||Released]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0691",
    "from_cache": false
}

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
2100

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	21783		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:3
Query-Depth:1

Errors and Warnings

None

	Date	System	Genre	Unreleased
Contra 4 (March 29, 2007 prototype A)	29 March 2007	Nintendo DS		-
Contra 4 (March 29, 2007 prototype B)	29 March 2007	Nintendo DS		-
Contra 4 (March 29, 2007 prototype C)	29 March 2007	Nintendo DS		-
Contra 4 (March 7, 2007 prototype A)	7 March 2007	Nintendo DS		-
Contra 4 (March 7, 2007 prototype B)	7 March 2007	Nintendo DS		-
Contra 4 (March 7, 2007 prototype C)	7 March 2007	Nintendo DS		-
Contra 4 (March 8, 2007 prototype A)	8 March 2007	Nintendo DS		-
Contra 4 (March 8, 2007 prototype B)	8 March 2007	Nintendo DS		-
Contra 4 (March 8, 2007 prototype C)	8 March 2007	Nintendo DS		-
Contra 4 (May 1, 2007 prototype A)	1 May 2007	Nintendo DS		-
Contra 4 (May 1, 2007 prototype B)	1 May 2007	Nintendo DS		-
Contra 4 (May 1, 2007 prototype C)	1 May 2007	Nintendo DS		-
Contra 4 (May 12, 2007 prototype A)	12 May 2007	Nintendo DS		-
Contra 4 (May 12, 2007 prototype B)	12 May 2007	Nintendo DS		-
Contra 4 (May 12, 2007 prototype C)	12 May 2007	Nintendo DS		-
Contra 4 (May 15, 2007 prototype A)	15 May 2007	Nintendo DS		-
Contra 4 (May 15, 2007 prototype B)	15 May 2007	Nintendo DS		-
Contra 4 (May 15, 2007 prototype C)	15 May 2007	Nintendo DS		-
Contra 4 (May 2, 2007 prototype A)	2 May 2007	Nintendo DS		-
Contra 4 (May 2, 2007 prototype B)	2 May 2007	Nintendo DS		-
Contra 4 (May 2, 2007 prototype C)	2 May 2007	Nintendo DS		-
Contra 4 (May 21, 2007 prototype A)	21 May 2007	Nintendo DS		-
Contra 4 (May 21, 2007 prototype B)	21 May 2007	Nintendo DS		-
Contra 4 (May 21, 2007 prototype C)	21 May 2007	Nintendo DS		-
Contra 4 (May 4, 2007 prototype A)	4 May 2007	Nintendo DS		-
Contra 4 (May 4, 2007 prototype B)	4 May 2007	Nintendo DS		-
Contra 4 (May 4, 2007 prototype C)	4 May 2007	Nintendo DS		-
Contra 4 (May 5, 2007 prototype A)	5 May 2007	Nintendo DS		-
Contra 4 (May 5, 2007 prototype B)	5 May 2007	Nintendo DS		-
Contra 4 (May 5, 2007 prototype C)	5 May 2007	Nintendo DS		-
Contra 4 (May 9, 2007 prototype A)	9 May 2007	Nintendo DS		-
Contra 4 (May 9, 2007 prototype B)	9 May 2007	Nintendo DS		-
Contra 4 (May 9, 2007 prototype C)	9 May 2007	Nintendo DS		-
Contra 4 (October 15, 2007 prototype A)	15 October 2007	Nintendo DS		-
Contra 4 (October 15, 2007 prototype B)	15 October 2007	Nintendo DS		-
Contra 4 (September 5, 2007 prototype)	5 September 2007	Nintendo DS		-
Contra Advance (Review Prototype)		Game Boy Advance	run-n-gun	-
Contra Evolution (Feb 10, 2010 prototype)	10 February 2010 10:49:51	Xbox 360	3D Shooter, Run-N-Gun	✓
Contra III: The Alien Wars (Review Prototype)		SNES	run-n-gun	-
Contra IV: The Alien Wars (Regional Intermediate Prototype)		SNES	run-n-gun	-
Contra Spirits (Sample Prototype)		SNES	run-n-gun	-
Contra: Legacy of War (Aug 23, 1996 prototype)	23 August 1996 19:41:38	PlayStation	Run-n-gun	-
Contra: Legacy of War (Jan 28, 1997 Prototype)	28 January 1997	Sega Saturn	Run-n-gun	-
Contra: Legacy of War (Oct 3, 1996 prototype)	3 October 1996 04:12:38	PlayStation	3D Shooter, Run-N-Gun	-
Contra: Shattered Soldier (Jul 1, 2002 prototype)	1 July 2002 11:15:30	PlayStation 2	Run and gun	-
Contra: Shattered Soldier (May 8, 2002 prototype)	8 May 2002 14:52:40	PlayStation 2	Shoot em Up	-
Controller Pak Test Program v5.4 (Prototype)		Nintendo 64	Diagnostic	✓
Controller Test Cartridge		SNES	Hardware Diagnostics	-
Cool Boarders 2001 (Aug 21, 2000 prototype)	21 August 2000 11:20:14	PlayStation	Snowboarding	-
Cool Boarders 3 (Jul 1, 1998 prototype)	1 July 1998 18:57:10	PlayStation	Sports - Snowboarding	-

Semantic search

Query log

Navigation menu

Search