Semantic search

From Lexicon Leponticum
Jump to navigationJump 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:Inscription]] [[position::unknown]] [[position::+]]
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
  `lexlep_smw_object_ids` AS t0
INNER JOIN
  (`lexlep_smw_fpt_inst` AS t2
INNER JOIN
  `lexlep_t3` AS t3 ON t2.o_id=t3.id
INNER JOIN
  `lexlep_smw_di_blob` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `lexlep_smw_di_blob` AS t6 ON t2.s_id=t6.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   ((t4.o_hash='unknown') AND t4.p_id=707)
   AND (t6.p_id=707)
  )
  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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4refs_id, p_id, o_hash, s_id_2p_id262const, const91Using index condition; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t4.s_id1Using where
1SIMPLEt6refs_id, p_id, s_id_2s_id8lexlepwebu54.t4.s_id, const1Using index; Distinct
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_24lexlepwebu54.t4.s_id1Using where; Using index; Distinct
1SIMPLEt3eq_refPRIMARYPRIMARY4lexlepwebu54.t2.o_id1Distinct
Auxilliary Tables
  • Temporary table t3
      Recursively computed hierarchy for element(s) (1276).
      SELECT s_id FROM `lexlep_smw_fpt_subc` WHERE o_id=1276 LIMIT 1
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
Inscriptionposition
AO·1.1unknown
AO·1.2unknown
AO·2unknown
AS 3.1unknown
BG·13unknown
BG·17unknown
front
BG·19unknown
BG·41.1unknown
BG·41.10unknown
BG·41.11unknown
BG·41.12unknown
BG·41.13unknown
BG·41.14unknown
BG·41.15unknown
BG·41.16unknown
BG·41.17unknown
BG·41.18unknown
BG·41.19unknown
BG·41.2unknown
BG·41.20unknown
BG·41.21unknown
BG·41.22unknown
BG·41.23unknown
BG·41.24unknown
BG·41.25unknown
BG·41.26unknown
BG·41.27unknown
BG·41.28unknown
BG·41.29unknown
BG·41.3unknown
BG·41.30unknown
BG·41.4unknown
BG·41.5unknown
BG·41.6unknown
BG·41.7unknown
BG·41.8unknown
BG·41.9unknown
BS·2unknown
BS·20unknown
BS·21unknown
BS·8unknown
CO·15unknown
CO·16unknown
CO·17unknown
CO·19unknown
CO·25unknown
CO·28unknown
CO·3unknown
CO·31unknown
CO·32unknown