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 game::SpongeBob SquarePants: SuperSponge]]
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='SpongeBob SquarePants: SuperSponge') AND t1.p_id=4755) 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 51
SQL Explain
ID select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 index_merge s_id, p_id, o_hash, s_id_2 o_hash,p_id 258,262 27 Using intersect(o_hash,p_id); Using where; 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:2
Query-Depth:1
Errors and Warnings
The part "resourcesassetslicensespublic%domain.png" of the query was not understood.
Results might not be as expected.
Date Labels System SpongeBob SquarePants: SuperSponge (Jul 5, 2001 prototype) 5 July 2001 10:11:38 SBSP_040701 PlayStation SpongeBob SquarePants: SuperSponge (Jul 6, 2001 prototype - B) 2 July 2001 20:19:44 SBSP_060701_2 PlayStation SpongeBob SquarePants: SuperSponge (Jul 6, 2001 prototype) 6 July 2001 17:27:57 SBSP_060701 PlayStation SpongeBob SquarePants: SuperSponge (Jun 1, 2001 prototype) 1 June 2001 08:44:29 SBSP_310501 PlayStation SpongeBob SquarePants: SuperSponge (Jun 18, 2001 prototype) 18 June 2001 19:17:34 SBSP_180601 PlayStation SpongeBob SquarePants: SuperSponge (Jun 25, 2001 prototype) 25 June 2001 18:32:03 SBSP_250601 PlayStation SpongeBob SquarePants: SuperSponge (Jun 28, 2001 prototype) 28 June 2001 18:36:14 SBSP_280601 PlayStation SpongeBob SquarePants: SuperSponge (Jun 4, 2001 prototype) 4 June 2001 17:24:21 SBSP_040601 PlayStation SpongeBob SquarePants: SuperSponge (Jun 6, 2001 11.34 prototype) 6 June 2001 11:34:00 Game Boy Advance SpongeBob SquarePants: SuperSponge (Jun 6, 2001 11.39 prototype) 6 June 2001 11:39:00 Game Boy Advance SpongeBob SquarePants: SuperSponge (Jun 7, 2001 prototype) 7 June 2001 19:34:33 BORRYS_SBSP_BUILD!!_070601 PlayStation SpongeBob SquarePants: SuperSponge (Mar 1, 2001 prototype) 1 March 2001 04:17:26 Game Boy Advance SpongeBob SquarePants: SuperSponge (Mar 12, 2001 prototype) 12 March 2001 11:27:14 Game Boy Advance SpongeBob SquarePants: SuperSponge (Mar 14, 2001 prototype) 14 March 2001 12:46:54 Game Boy Advance SpongeBob SquarePants: SuperSponge (Mar 28, 2001 prototype) 28 March 2001 11:11:00 Game Boy Advance SpongeBob SquarePants: SuperSponge (May 10, 2001 prototype) 10 May 2001 22:44:12 SBSP_PRE_E3 PlayStation SpongeBob SquarePants: SuperSponge (May 14, 2001 prototype - B) 14 May 2001 19:32:19 SBSP_E3 PlayStation SpongeBob SquarePants: SuperSponge (May 14, 2001 prototype) 14 May 2001 09:27:20 SBSP_140501 PlayStation SpongeBob SquarePants: SuperSponge (May 15, 2001 prototype - B) 15 May 2001 15:06:36 SBSP_E3_ALLLEVELS PlayStation SpongeBob SquarePants: SuperSponge (May 15, 2001 prototype) 15 May 2001 18:27:35 SBSP_160501 PlayStation SpongeBob SquarePants: SuperSponge (May 2, 2001 prototype) 2 May 2001 08:48:24 SBSP_020501 PlayStation SpongeBob SquarePants: SuperSponge (May 22, 2001 prototype) 22 May 2001 12:41:00 SBSP_020501 PlayStation SpongeBob SquarePants: SuperSponge (May 25, 2001 prototype) 25 May 2001 10:24:00 SBSP052501 PlayStation SpongeBob SquarePants: SuperSponge (May 29, 2001 prototype) 29 May 2001 13:14:00 SBSP052901 PlayStation SpongeBob SquarePants: SuperSponge (May 31, 2001 prototype) 31 May 2001 12:37:00 SBSP053101 PlayStation SpongeBob SquarePants: SuperSponge (May 4, 2001 prototype) 4 May 2001 09:48:49 SBSP_040500 PlayStation SpongeBob SquarePants: SuperSponge (May 5, 2001 prototype - B) 5 May 2001 18:28:36 SBSP_MS9- PlayStation SpongeBob SquarePants: SuperSponge (May 5, 2001 prototype) 5 May 2001 18:28:36 ms9 PlayStation SpongeBob SquarePants: SuperSponge (Nov 28, 2000 prototype) 28 November 2000 07:29:10 Game Boy Advance SpongeBob SquarePants: SuperSponge (Sep 10, 2001 prototype) 10 September 2001 09:30:00 SBSP091001EurDebug, SBSP091001EurFinal PlayStation SpongeBob SquarePants: SuperSponge (Sep 11, 2001 prototype - Debug) 11 September 2001 10:37:00 SBSP091101EurDebug, SBSP091101EurFinal PlayStation SpongeBob SquarePants: SuperSponge (Sep 11, 2001 prototype) 11 September 2001 SBSP_EUR-FINAL_110901 PlayStation SpongeBob SquarePants: SuperSponge (Sep 13, 2001 prototype - Debug) 13 September 2001 08:36:00 SBSP091301EurDebug, SBSP091301EurFinal PlayStation SpongeBob SquarePants: SuperSponge (Sep 13, 2001 prototype) 13 September 2001 SBSP_EUR-FINAL_130901 PlayStation SpongeBob SquarePants: SuperSponge (Sep 5, 2001 prototype - B) 5 September 2001 SBSP_FINAL_PAL_PSX_BURNER_050901 PlayStation SpongeBob SquarePants: SuperSponge (Sep 5, 2001 prototype) 5 September 2001 10:10:16 SBSP_PAL_050901_FINAL PlayStation SpongeBob SquarePants: SuperSponge (Sep 6, 2001 prototype) 6 September 2001 08:48:00 SBSP090601EurFinal PlayStation SpongeBob bug 518 PlayStation bug671 PlayStation bug673 PlayStation
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