Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
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
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
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | range | s_id, p_id, o_sortkey, p_id_2, s_id_2 | p_id | 13 | 1530 | Using index condition; Using temporary; Using filesort | ||
| 1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | lexlepwebu54.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None| Page | Level | Problems (in keywords) | Description (in keywords; old method) |
|---|---|---|---|
 | 1 | Patera VA·17 Arsago Seprio from Morandi | |
 | 1 | Inscription VA·24 from Morandi | |
 | 1 | Inscription VA·19 from Morandi | |
 | 1 | Potsherd VA·20 Arsago Seprio with inscription VA·20 from Morandi | |
 | 1 | Inscription VA·21 from Morandi | |
 | 1 | Inscription VA·22 from Morandi | |
 | 1 | Cup VA·22 Arsago Seprio from Morandi | |
 | 1 | Inscription VA·23 from Morandi | |
 | 1 | Inscription VA·18 from Morandi | |
 | 1 | VA·18 Arsago Seprio from Morandi | |
 | 1 | Part of inscription VA·25 from Morandi | |
 | 1 | Part of inscription VA·25 from Morandi | |
 | 1 | Pitcher VA·25 Arsago Seprio from Morandi | |
 | 1 | Inscription VA·27 from Morandi 2004 | |
 | 3 | Potsherd `CO·20 Rondineto´ with inscription `CO·20´ )rpiạ ( | |
 | 1 | Potsherd `BS·25 Brescia´ with the inscription `BS·25´ ịạṃ | |
 | 2 | Detail of coin `NM·19´ | |
 | 1 | Front side of gravestone `PG·1 Todi´ with inscriptions `PG·1.1´ and `PG·1.2´ | |
 | 2 | Back side of gravestone `PG·1 Todi´ with the inscriptions `PG·1.3´ and `PG·1.4´ | |
| Morandi 2004b | 1 | ||
 | 1 | Front of the Davesco stela with inscriptions TI·36.1 and TI·36.2 from Motta | |
 | 1 | Stela from Stabio with inscription TI·42 from Motta | |
 | 1 | Cup TI·8 Giubiasco with inscription TI·8 from Motta 2000 | |
 | 1 | Bowl TI·15 Giubiasco with inscription TI·15 from Motta | |
 | 1 | Bottle TI·12 Giubiasco from Motta 2000 | |
 | 1 | Inscription TI·12 from Motta | |
 | 1 | Olla TI·11 Giubiasco with inscription TI·11 from Motta 2000 | |
 | 1 | Inscription TI·11 from Motta 2000 | |
 | 1 | Inscription TI·9 from Motta 2000 | |
 | 1 | Inscription TI·10 from Motta 2000 | |
 | 1 | Bottle TI·13 Giubiasco with inscription TI·13 from Motta | |
| Motta 2001 | 1 | ||
| 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 1913 | 1 | ||
| NM·1 | 4 | obverse left-facing male head with laurel wreath, reverse left facing trotting horse and legend | |
| NM·10.1 | 1 | obverse: small circle, three slanted parallel lines, and triangle with grid pattern, reverse: triangle, legend, and trident | |
| NM·10.2 | 1 | obverse: triangle with grid pattern, reverse: triangle, legend, and trident | |
| NM·12 | 5 | ||
| NM·13 | 1 | obverse: circle, three parallel lines, triangle shape with grid pattern, reverse: circle with dot, trident, legend | |
| NM·14 | 1 | obverse: small circle, three parallel lines, and triangle with grid pattern, reverse: decorated circle, legend within horizontal lines, and trident | |
| NM·15 | 4 | obverse: right-facing head of Apollo, reverse: right-facing head of a horse and legend | |
| NM·16 | 4 | obverse: left-facing head of Apollo, reverse: left-facing horse in gallop and legend | |
| NM·17 | 3 | obverse: right facing male head; reverse: right-turned horse protome, underneath the legend | |
| NM·18 | 2 | obverse: right-facing female head, reverse: point rosette, left-facing quadruped, horizontal separation line, and legend | |
| NM·19 | 5 | obverse: head of Jupiter, reverse: prow of a ship | |
| NM·2 | 1 | obverse: right-facing female head, reverse: right-facing lion |
