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::≥2020]] [[sortdate::≤2029.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, t11.o_hash
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
INNER JOIN
  `lexlep_smw_di_blob` AS t11 ON t0.smw_id=t11.s_id
WHERE
  (t2.o_id=1313
   AND (
   (t4.o_sortkey>='2020') AND t4.p_id=1199186)
   AND (
   (t6.o_sortkey<='2029.9999') AND t6.p_id=1199186)
   AND (
   (t8.o_sortkey!='0') AND t8.p_id=1199186)
  )
   AND (t11.p_id=1199080)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t11.o_hash ASC
LIMIT
  55
OFFSET
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt4ranges_id, p_id, o_sortkey, p_id_2, s_id_2p_id1340Using 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
1SIMPLEt11refs_id, p_id, s_id_2s_id8lexlepwebu54.t4.s_id, const1
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
Referencesortdate
Aberson et al. 20202,020
Aberson et al. 20212,021
Amicone et al. 20202,020
Barbieri 20202,020
Beltrán et al. 20202,020
Bersani & Venturino 20212,021
Bertol Stipetić 20222,022
Calderini & Massarelli 20222,022
Coltelloni-Trannoy & Moncunill Martí 20232,021
Consonni et al. 20212,021
Delamarre 20242,024
Dell'Era 20202,020
Dell'Era 20222,022
Eska & Eska 20222,022
Estarán Tolosa et al. 20212,021
Lanza et al. 20232,023
Maras 20232,023
Mees 20202,020
Mees 2020b2,020
Mees 20242,024
Mullen & Ruiz Darasse 20202,020
Mullen 20232,021
Nedoma & Nielsen 20202,020
Poggiani Keller & Rondini 20202,020
Repanšek 20202,020
RIIG2,020
Rubat Borel 20212,021
Salomon & Stifter 20242,024
Salomon 20202,020
Salomon 20222,022
Salomon 20232,023
Sims-Williams 20202,020
Solinas 20222,022
Stifter 20202,020
Stifter 2020b2,020
Stifter 2020c2,020
Stifter 20232,023
Stifter 20242,024
Wooding & Olson 20202,020
Zamboni et al. 20202,020
Retrieved from "https://lexlep.univie.ac.at/wiki/Special:Ask"