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
Debug output SQLStore
ASK Query
[[Category:Meetings]]
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, idst4.smw_sort
FROM
  `wiki_smw_object_ids` AS t0
INNER JOIN
  `wiki_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
  (`wiki_smw_di_wikipage` AS t4
INNER JOIN
  `wiki_smw_object_ids` AS idst4 ON idst4.smw_id=t4.o_id) ON t0.smw_id=t4.s_id
WHERE
  (t1.o_id=5666)
   AND (t4.p_id=5667)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  idst4.smw_sort DESC
LIMIT
  105
OFFSET
  200
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1refs_id, o_id, s_id_2, o_id_2o_id_25const690Using index; Using temporary; Using filesort
1SIMPLEt4refs_id, o_id, p_id, s_id_2, s_id_3, o_id_2, o_id_3p_id8const, wikidb.t1.s_id1Using where
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4wikidb.t1.s_id1Using where
1SIMPLEidst4eq_refPRIMARY, smw_idPRIMARY4wikidb.t4.o_id1
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:1
Query-Depth:0
Errors and Warnings
None
 
October 16, 2018
October 9, 2018
October 2, 2018
September 25, 2018
September 18, 2018
September 11, 2018
September 4, 2018
August 28, 2018
August 21, 2018
August 14, 2018
August 7, 2018
July 31, 2018
July 24, 2018
July 17, 2018
July 10, 2018
July 3, 2018
June 26, 2018
June 19, 2018
June 12, 2018
June 5, 2018
May 29, 2018
May 22, 2018
May 15, 2018
May 8, 2018
May 1, 2018
April 24, 2018
April 17, 2018
April 10, 2018
April 3, 2018
March 27, 2018
March 20, 2018
March 13, 2018
March 6, 2018
February 27, 2018
February 13, 2018
February 6, 2018
January 30, 2018
January 23, 2018
January 16, 2018
January 9, 2018
January 2, 2018
December 19, 2017
December 12, 2017
December 5, 2017
November 28, 2017
November 21, 2017
November 14, 2017
November 3, 2017
October 31, 2017
October 24, 2017
October 17, 2017
October 10, 2017
October 3, 2017
September 26, 2017
September 12, 2017
September 5, 2017
August 22, 2017
August 29, 2017
August 15, 2017
August 8, 2017
August 1, 2017
July 25, 2017
July 18, 2017
July 11, 2017
June 27, 2017
June 20, 2017
June 13, 2017
June 6, 2017
May 30, 2017
May 23, 2017
May 16, 2017
May 9, 2017
May 2, 2017
April 25, 2017
April 18, 2017
April 11, 2017
April 4, 2017
March 28, 2017
March 21, 2017
March 14, 2017
March 7, 2017
February 28, 2017
February 21, 2017
February 14, 2017
February 7, 2017
January 31, 2017
January 24, 2017
January 17, 2017
January 10, 2017
January 3, 2017
December 27, 2016
December 20, 2016
December 13, 2016
December 6, 2016
November 22, 2016
November 29, 2016
November 15, 2016
November 8, 2016
November 1, 2016
October 25, 2016