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:Word]] [[field semantic::prob. personal name]] [[field semantic::+]]
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, t9.o_hash
FROM
  `lexlep_smw_object_ids` AS t0
INNER JOIN
  (`lexlep_smw_fpt_inst` AS t2
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
INNER JOIN
  `lexlep_smw_di_blob` AS t9 ON t0.smw_id=t9.s_id
WHERE
  (t2.o_id=1170
   AND (
   (t4.o_hash='prob. personal name') AND t4.p_id=532)
   AND (t6.p_id=532)
  )
   AND (t9.p_id=1199080)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t9.o_hash ASC
LIMIT
  55
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4refs_id, p_id, o_hash, s_id_2o_hash258const92Using index condition; Using where; Using temporary; Using filesort
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_29lexlepwebu54.t4.s_id, const1Using index
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t4.s_id1Using where
1SIMPLEt9refs_id, p_id, s_id_2s_id8lexlepwebu54.t4.s_id, const1
1SIMPLEt6refs_id, p_id, s_id_2s_id8lexlepwebu54.t4.s_id, const1Using index; Distinct
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:4
Query-Depth:1
Errors and Warnings
None
Wordfield semantic
aieroprob. personal name
ai??roprob. personal name
aiut(prob. personal name
akprob. personal name
alprob. personal name
anaprob. personal name
)aniuiprob. personal name
apiosprob. personal name
aśeśprob. personal name
ariuoneposprob. personal name
artprob. personal name
arukiprob. personal name
atprob. personal name
atiakiprob. personal name
atisprob. personal name
atlatuprob. personal name
aunmiprob. personal name
vatprob. personal name
fesiaprob. personal name
iap??iprob. personal name
ilprob. personal name
inaprob. personal name
inouprob. personal name
)iuka(prob. personal name
)iunθanaχaprob. personal name
ka?(prob. personal name
kaprob. personal name
kaiprob. personal name
kaputusprob. personal name
kasprob. personal name
katprob. personal name
keputusprob. personal name
ceseprob. personal name
cesiiprob. personal name
kiprob. personal name
kiratiprob. personal name
kuprob. personal name
kutsiuprob. personal name
leprob. personal name
liprob. personal name
litprob. personal name
louprob. personal name
me 2prob. personal name
meivaprob. personal name
mitaprob. personal name
mocprob. personal name
musprob. personal name
natorisprob. personal name
neriosprob. personal name
obalzaprob. personal name