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:Reference]] [[sortdate::≥2010]] [[sortdate::≤2019.9999]] [[sortdate::!0]]
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_smw_di_number` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
  `lexlep_smw_di_number` AS t6 ON t2.s_id=t6.s_id
INNER JOIN
  `lexlep_smw_di_number` AS t8 ON t2.s_id=t8.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id=1313
   AND (
   (t4.o_sortkey>='2010') AND t4.p_id=1199186)
   AND (
   (t6.o_sortkey<='2019.9999') AND t6.p_id=1199186)
   AND (
   (t8.o_sortkey!='0') AND t8.p_id=1199186)
  )
  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
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4ranges_id, p_id, o_sortkey, p_id_2, s_id_2p_id13247Using index condition; Using temporary; Using filesort
1SIMPLEt2refs_id, o_id, s_id_2, o_id_2s_id_29lexlepwebu54.t4.s_id, const1Using index
1SIMPLEt6refs_id, p_id, o_sortkey, p_id_2, s_id_2s_id_28lexlepwebu54.t4.s_id, const1Using where; Using index
1SIMPLEt8refs_id, p_id, o_sortkey, p_id_2, s_id_2s_id_28lexlepwebu54.t4.s_id, const1Using where; Using index
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
Referencesortdate
Delamarre 20102,010
Delamarre 20122,012
Delamarre 20172,017
Delamarre 20192,019
Delestrée & Meziane 20162,016
Dell'Era 20182,018
Dell'Era 20192,019
Della Casa 20172,017
Dunkel 20142,014
Dupraz 20152,015
ET²2,014
Egetmeyer 20152,015
Eska & Mercado 20112,011
Eska & Wallace 20112,011
Eska 20132,013
Eska 20152,015
Eska 20172,017
Eska 20182,018
Eska 20192,019
Facchinetti & Miedico 20152,015
Falileyev 20102,010
Falileyev 20142,014
Falileyev 20172,017
Falileyev 20192,019
Fortunati et al. 20182,018
Franc 20182,018
Gambacurta & Ruta Serafini 20172,017
Gambacurta 20132,013
Gambari & Cerri 20112,011
Gambari 20112,011
Gambari 2017a2,017
Gambari 2017b2,017
Gambari 20182,018
Gambari 20192,019
García Alonso 20132,013
Gaucci 20142,014
Geiser et al. 20122,012
Giostra 20182,018
Goddard 20182,018
Gorini 20142,014
Grassi & Pizzo 20142,014
Guštin & David 20142,014
Haeussler & King 20172,017
Harari 20172,017
Harari 2017b2,017
Hiriart et al. 20182,018
Höfler 20172,017
Höfler 2017b2,017
Jospin & Dalaine 20112,011
Krisch & Lindner 20112,011