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
[[checklevel::≥1]]
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_di_number` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (
   (t1.o_sortkey>='1') AND t1.p_id=1199509)
  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
  600
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEt1ranges_id, p_id, o_sortkey, p_id_2, s_id_2p_id131530Using index condition; Using temporary; Using filesort
1SIMPLEt0eq_refPRIMARY, smw_id, smw_iw, smw_iw_2PRIMARY4lexlepwebu54.t1.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:2
Query-Depth:1
Errors and Warnings
None
PageLevelProblems (in keywords)Description (in keywords; old method)
Morandi 2004 794 117b.png1Patera VA·17 Arsago Seprio from Morandi
Morandi 2004 795 118.png1Inscription VA·24 from Morandi
Morandi 2004 795 119b.png1Inscription VA·19 from Morandi
Morandi 2004 795 120.png1Potsherd VA·20 Arsago Seprio with inscription VA·20 from Morandi
Morandi 2004 796 121.png1Inscription VA·21 from Morandi
Morandi 2004 796 122.png1Inscription VA·22 from Morandi
Morandi 2004 796 122b.png1Cup VA·22 Arsago Seprio from Morandi
Morandi 2004 796 123.png1Inscription VA·23 from Morandi
Morandi 2004 796 124a.png1Inscription VA·18 from Morandi
Morandi 2004 796 124b.png1VA·18 Arsago Seprio from Morandi
Morandi 2004 797 125a.png1Part of inscription VA·25 from Morandi
Morandi 2004 797 125b.png1Part of inscription VA·25 from Morandi
Morandi 2004 797 125c.png1Pitcher VA·25 Arsago Seprio from Morandi
Morandi 2004 797 127.png1Inscription VA·27 from Morandi 2004
Morandi 2004 800 167.png3Potsherd `CO·20 Rondineto´ with inscription `CO·20´ )rpiạ (
Morandi 2004 807 a.png1Potsherd `BS·25 Brescia´ with the inscription `BS·25´ ịạṃ
Morandi 2004 809 276.png2Detail of coin `NM·19´
Morandi 2004 810 277a.png1Front side of gravestone `PG·1 Todi´ with inscriptions `PG·1.1´ and `PG·1.2´
Morandi 2004 810 277b.png2Back side of gravestone `PG·1 Todi´ with the inscriptions `PG·1.3´ and `PG·1.4´
Morandi 2004b1
Motta 2000 04.png1Front of the Davesco stela with inscriptions TI·36.1 and TI·36.2 from Motta
Motta 2000 09.png1Stela from Stabio with inscription TI·42 from Motta
Motta 2000 13.png1Cup TI·8 Giubiasco with inscription TI·8 from Motta 2000
Motta 2000 14.png1Bowl TI·15 Giubiasco with inscription TI·15 from Motta
Motta 2000 16a.png1Bottle TI·12 Giubiasco from Motta 2000
Motta 2000 16b.png1Inscription TI·12 from Motta
Motta 2000 17.png1Olla TI·11 Giubiasco with inscription TI·11 from Motta 2000
Motta 2000 18.png1Inscription TI·11 from Motta 2000
Motta 2000 19.png1Inscription TI·9 from Motta 2000
Motta 2000 20.png1Inscription TI·10 from Motta 2000
Motta 2000 21.png1Bottle TI·13 Giubiasco with inscription TI·13 from Motta
Motta 20011
Museo Camuno CAMUS (Breno)3
Museo Civico "Carlo Giacomo Franchini" (Oleggio)5
Museo Civico Archeologico "Ubaldo Formentini" (La Specia)1
Museo Civico Archeologico (Sesto Calende)1
Museo civico archeologico di Villa Mirabello (Varese)5
Müller 19131
NM·14obverse left-facing male head with laurel wreath, reverse left facing trotting horse and legend
NM·10.11obverse: small circle, three slanted parallel lines, and triangle with grid pattern, reverse: triangle, legend, and trident
NM·10.21obverse: triangle with grid pattern, reverse: triangle, legend, and trident
NM·125
NM·131obverse: circle, three parallel lines, triangle shape with grid pattern, reverse: circle with dot, trident, legend
NM·141obverse: small circle, three parallel lines, and triangle with grid pattern, reverse: decorated circle, legend within horizontal lines, and trident
NM·154obverse: right-facing head of Apollo, reverse: right-facing head of a horse and legend
NM·164obverse: left-facing head of Apollo, reverse: left-facing horse in gallop and legend
NM·173obverse: right facing male head; reverse: right-turned horse protome, underneath the legend
NM·182obverse: right-facing female head, reverse: point rosette, left-facing quadruped, horizontal separation line, and legend
NM·195obverse: head of Jupiter, reverse: prow of a ship
NM·21obverse: right-facing female head, reverse: right-facing lion