Semantic search

Jump to navigation Jump to search
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
The part "resourcesassetslicensespublic%domain.png" of the query was not understood. Results might not be as expected.
Debug output SQLStore
ASK Query
[[:+]] [[Page creator::!Drx]] [[Page creator::!Evilhamwizard]] [[Page creator::!MediaWiki default]] [[Page creator::!Ehw]]
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_object_ids` AS t2
INNER JOIN
  (`smw_di_wikipage` AS t3
INNER JOIN
  `smw_object_ids` AS t5 ON t3.o_id=t5.smw_id) ON t2.smw_id=t3.s_id
INNER JOIN
  (`smw_di_wikipage` AS t6
INNER JOIN
  `smw_object_ids` AS t8 ON t6.o_id=t8.smw_id) ON t2.smw_id=t6.s_id
INNER JOIN
  (`smw_di_wikipage` AS t9
INNER JOIN
  `smw_object_ids` AS t11 ON t9.o_id=t11.smw_id) ON t2.smw_id=t9.s_id
INNER JOIN
  (`smw_di_wikipage` AS t12
INNER JOIN
  `smw_object_ids` AS t14 ON t12.o_id=t14.smw_id) ON t2.smw_id=t12.s_id) ON t0.smw_id=t2.smw_id
WHERE
  (t2.smw_namespace=0
   AND (t3.p_id=4245
   AND (t5.smw_sortkey!='Drx')
  )
   AND (t6.p_id=4245
   AND (t8.smw_sortkey!='Evilhamwizard')
  )
   AND (t9.p_id=4245
   AND (t11.smw_sortkey!='MediaWiki default')
  )
   AND (t12.p_id=4245
   AND (t14.smw_sortkey!='Ehw')
  ))
  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
  15
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt3refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id4const50514Using where; Using temporary; Using filesort
1SIMPLEt2eq_refPRIMARY, smw_id, smw_namespacePRIMARY4hp_wiki_new.t3.s_id1Using where
1SIMPLEt6refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id8const, hp_wiki_new.t3.s_id1Using where
1SIMPLEt9refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id8const, hp_wiki_new.t3.s_id1Using where
1SIMPLEt12refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id8const, hp_wiki_new.t3.s_id1Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4hp_wiki_new.t3.s_id1Using where
1SIMPLEt5refPRIMARY, smw_id, smw_sortkeysmw_id4hp_wiki_new.t3.o_id1Using where; Using index; Distinct
1SIMPLEt8refPRIMARY, smw_id, smw_sortkeysmw_id4hp_wiki_new.t6.o_id1Using where; Using index; Distinct
1SIMPLEt11refPRIMARY, smw_id, smw_sortkeysmw_id4hp_wiki_new.t9.o_id1Using where; Using index; Distinct
1SIMPLEt14refPRIMARY, smw_id, smw_sortkeysmw_id4hp_wiki_new.t12.o_id1Using where; Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:9
Query-Depth:1
Errors and Warnings
The part "resourcesassetslicensespublic%domain.png" of the query was not understood. Results might not be as expected.
ArticlePage creatorThis property is a special property in this wiki.
007: From Russia with Love (Aug 23, 2005 prototype)TreblaYevrah
007: From Russia with Love (Dec 5, 2005 debug build)Dink
007: From Russia with Love (Jul 13, 2005 prototype)Dink
007: From Russia with Love (Sep 11, 2005 prototype)Dink
007: From Russia with Love (Sep 25, 2005 prototype)Hidden Palace
007: From Russia with Love (Sep 30, 2005 prototype)Dink
007: Legends (Apr 12, 2012 prototype)Hidden Palace
007: Legends (Apr 5, 2012 prototype)Hidden Palace
007: Legends (Aug 24, 2012 prototype)Hidden Palace
007: Legends (Aug 31, 2012 prototype)Hidden Palace
007: Legends (Aug 7, 2012 prototype)Hidden Palace
007: Legends (Jul 19, 2012 prototype)Hidden Palace
007: Legends (Jun 15, 2012 prototype)Hidden Palace
007: Legends (Jun 18, 2012 prototype)Hidden Palace
007: Legends (May 21, 2012 prototype)Hidden Palace
007: Legends (May 9, 2012 prototype)Hidden Palace
007: Legends (Nov 13, 2012 prototype)Hidden Palace
007: Legends (Nov 16, 2011 prototype)Hidden Palace
007: Legends (Oct 17, 2012 prototype)Hidden Palace
007: Legends (Oct 9, 2012 prototype)Hidden Palace
007: Legends (Sep 1, 2012 prototype)Hidden Palace
007: Legends (Sep 10, 2012 prototype)Hidden Palace
007: Legends (Sep 11, 2012 08.30 prototype)Hidden Palace
007: Legends (Sep 11, 2012 13.55 prototype)Hidden Palace
007: Legends (Sep 14, 2012 prototype)Hidden Palace
007: Legends (Sep 18, 2012 prototype)Hidden Palace
007: Legends (Sep 20, 2012 prototype)Hidden Palace
007: Legends (Sep 26, 2012 prototype)Hidden Palace
007: Legends (Sep 27, 2012 13.31 prototype)Hidden Palace
007: Legends (Sep 27, 2012 15.08 prototype)Hidden Palace
007: Legends (Sep 7, 2012 prototype)Hidden Palace
007: Legends (Sep 8, 2012 prototype)Hidden Palace
007: Nightfire (Oct 18, 2002 prototype)Dink
007: The World Is Not Enough (Aug 26, 2000 prototype)Cut Into Fourteen Pieces
007: The World is Not Enough (Prototype - 2020 release)Hiccup
007: The World is Not Enough (Prototype)Hidden Palace
007: Tomorrow Never Dies (Oct 10, 1999 prototype)Hidden Palace
1 vs. 100 (Apr 14, 2010 Prototype)Slycooper124
1 vs. 100 (Dec 7, 2009 prototype)Lemurboy12
10-Pin Bowling (Game Boy prototype)Elmotus
100 Bullets (Apr 22, 2004 prototype)Cut Into Fourteen Pieces
100 Bullets (Aug 6, 2004 prototype)Cut Into Fourteen Pieces
100 Bullets (Jun 30, 2004 prototype)Cut Into Fourteen Pieces
10ahuHidden Palace
13thVesselGlitchedblood
171-5694-01Glitchedblood
171-6563AGlitchedblood
18 Wheeler: American Pro Trucker (Apr 5, 2001 prototype)Hidden Palace
18 Wheeler: American Pro Trucker (Feb 2, 2001 prototype)Hidden Palace
18 Wheeler: American Pro Trucker (Nov 12, 2001 prototype)Lemurboy12