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.
The part "resourcesassetslicensespublic%domain.png" of the query was not understood.
Results might not be as expected.
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
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 21799 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
The part "resourcesassetslicensespublic%domain.png" of the query was not understood.
Results might not be as expected.
Date System Genre Unreleased Contra 4 (April 25, 2007 prototype A) 25 April 2007 Nintendo DS - Contra 4 (April 25, 2007 prototype B) 25 April 2007 Nintendo DS - Contra 4 (April 25, 2007 prototype C) 25 April 2007 Nintendo DS - Contra 4 (April 26, 2007 prototype A) 26 April 2007 Nintendo DS - Contra 4 (April 26, 2007 prototype B) 26 April 2007 Nintendo DS - Contra 4 (April 26, 2007 prototype C) 26 April 2007 Nintendo DS - Contra 4 (April 29, 2007 prototype A) 29 April 2007 Nintendo DS - Contra 4 (April 29, 2007 prototype B) 29 April 2007 Nintendo DS - Contra 4 (April 29, 2007 prototype C) 29 April 2007 Nintendo DS - Contra 4 (April 4, 2007 prototype A) 4 April 2007 Nintendo DS - Contra 4 (April 4, 2007 prototype B) 4 April 2007 Nintendo DS - Contra 4 (April 4, 2007 prototype C) 4 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype A) 5 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype B) 5 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype C) 5 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype D) 5 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype E) 5 April 2007 Nintendo DS - Contra 4 (April 5, 2007 prototype F) 5 April 2007 Nintendo DS - Contra 4 (August 13, 2007 prototype A) 13 August 2007 Nintendo DS - Contra 4 (August 13, 2007 prototype B) 13 August 2007 Nintendo DS - Contra 4 (August 13, 2007 prototype C) 13 August 2007 Nintendo DS - Contra 4 (August 28, 2007 prototype A) 28 August 2007 Nintendo DS - Contra 4 (August 28, 2007 prototype B) 28 August 2007 Nintendo DS - Contra 4 (August 7, 2007 prototype) 7 August 2007 Nintendo DS - Contra 4 (August 8, 2007 18:30:54 prototype) 8 August 2007 18:30:54 Nintendo DS - Contra 4 (August 8, 2007 18:47:29 prototype) 8 August 2007 18:47:29 Nintendo DS - Contra 4 (August 8, 2007 21:39:53 prototype) 8 August 2007 21:39:53 Nintendo DS - Contra 4 (December 19, 2007 prototype) 19 December 2007 Nintendo DS - Contra 4 (February 12, 2007 prototype A) 12 February 2007 Nintendo DS - Contra 4 (February 12, 2007 prototype B) 12 February 2007 Nintendo DS - Contra 4 (February 12, 2007 prototype C) 12 February 2007 Nintendo DS - Contra 4 (February 15, 2007 prototype A) 15 February 2007 Nintendo DS - Contra 4 (February 15, 2007 prototype B) 15 February 2007 Nintendo DS - Contra 4 (February 15, 2007 prototype C) 15 February 2007 Nintendo DS - Contra 4 (February 18, 2007 prototype A) 18 February 2007 Nintendo DS - Contra 4 (February 18, 2007 prototype B) 18 February 2007 Nintendo DS - Contra 4 (February 18, 2007 prototype C) 18 February 2007 Nintendo DS - Contra 4 (February 2, 2007 prototype A) 2 February 2007 Nintendo DS - Contra 4 (February 2, 2007 prototype B) 2 February 2007 Nintendo DS - Contra 4 (February 2, 2007 prototype C) 2 February 2007 Nintendo DS - Contra 4 (February 22, 2007 prototype) 22 February 2007 Nintendo DS - Contra 4 (February 26, 2007 prototype) 26 February 2007 Nintendo DS - Contra 4 (February 5, 2007 prototype) 5 February 2007 Nintendo DS - Contra 4 (February 7, 2007 prototype A) 7 February 2007 Nintendo DS - Contra 4 (February 7, 2007 prototype B) 7 February 2007 Nintendo DS - Contra 4 (February 7, 2007 prototype C) 27 February 2007 Nintendo DS - Contra 4 (January 23, 2008 prototype A) 23 January 2008 Nintendo DS - Contra 4 (January 23, 2008 prototype B) 23 January 2008 Nintendo DS - Contra 4 (January 24, 2008 prototype) 24 January 2008 Nintendo DS - Contra 4 (January 31, 2007 prototype A) 31 January 2007 Nintendo DS -
This section contains some links to help explain how to use the #ask
syntax.
Search operators lists available search operators including those for range and wildcard queries
Input assistance
Input assistance is provided for the printout, sort, and condition field. The condition field requires to use one of following prefixes:
p:
to fetch property suggestions (e.g. [[p:Has ...
)c:
to fetch category suggestionscon:
to fetch concept suggestions