Semantic search
From Lexicon Leponticum
Jump to navigationJump to search
Debug output SQLStore
ASK Query
[[Category:Reference]]
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1313)
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
250
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 t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id=1313)
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
250
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_id, s_id_2, o_id_2 | o_id_2 | 5 | const | 1314 | Using index; 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:1Query-Depth:0
Errors and Warnings
None- De Bernardo Stempel 1994: ualaunal, u̯allau̯n-
- De Bernardo Stempel 1995: none
- De Bernardo Stempel 1996: priś
- De Bernardo Stempel 1998: -al-, kass-
- De Bernardo Stempel 1999: -al-, -il(l)-, -ul(l)-, ariuonepos, arkatokomaterekos, ateknati, belg-, kasiuos, kiketu, lokan, moconis, pelkui, piuonei, prikou, rikanas, tekialui, teuoχtoni(o)n, tikou, uenia, uvamokozis, uvltiauiopos, u̯ind-, ēt-
- De Bernardo Stempel 2000: Historical Overview, meśiolano, pirakos
- De Bernardo Stempel 2003: -oi̯so, MI·10.1, ariuonepos, eripoχios
- De Bernardo Stempel 2005: CO·48, kepi, tetu
- De Bernardo Stempel 2009: sekezos
- De Bernardo Stempel 2010: bir(r)-
- De Bernardo Stempel 2011: none
- De Bernardo Stempel 2012: The Cisalpine Celtic Languages
- De Giuli 1979: Brisino, File:De Giuli 1978-9 246 fig1-2.png, File:De Giuli 1978-9 246 fig1.png, File:De Giuli 1978-9 247 fig2-2.png, File:De Giuli 1978-9 247 fig2.png, File:De Giuli 1978-9 248 fig3-2.png, File:De Giuli 1978-9 248 fig3.png, File:De Giuli 1978-9 249 fig4-2.png, File:De Giuli 1978-9 249 fig4.png, VB·22, VB·22 Stresa, VB·23, VB·23 Stresa, VB·24, VB·24 Stresa, VB·25, VB·25 Stresa
- De Goede 2014: none
- De Hoz 1985: Tovar 1985
- De Hoz 1990: -ī, Onomastics, VB·2, VB·22, VB·28, musu, plialeθu, seχeθu
- De Hoz 1992: -oi̯so, -ī, Archaeological Overview, GR·1, The Cisalpine Celtic Languages
- De Hoz 1994: brig-
- De Hoz 1995: karnitus
- De Hoz 2005: tekialui
- De Hoz 2007: none
- De Hoz et al. 2005: De Hoz 2005
- De La Tour 1892: NM·1, NM·11, NM·13, NM·3, NM·9
- De Marinis & Biaggio Simona 2000: Archaeological Overview, Arslan 2000, De Marinis 2000, Kaenel 2000, Motta 2000, Nagy 2000, Schmid-Sikimić 2000, TI·10 Giubiasco, TI·11, TI·11 Giubiasco, TI·12, TI·12 Giubiasco, TI·13, TI·13 Giubiasco, TI·15, TI·15 Giubiasco, TI·17 Giubiasco, TI·18.1, TI·18.2, TI·19 Giubiasco, TI·2, TI·2 Giubiasco, TI·21 Locarno, TI·22, TI·22 Locarno, TI·23 Locarno, TI·24, TI·24 Locarno, TI·25 Locarno, TI·48.1, TI·48.2, TI·8 Giubiasco, TI·9 Giubiasco, The Cisalpine Celtic Languages, Wiblé 2000
- De Marinis & Motta 1991: ?aui, Archaeological Overview, CO·15, CO·16, CO·48, CO·48 Prestino, CO·53, CO·53 Prestino, CO·72, GR·1 Mesocco, North Italic Script, TI·14, TI·14 Giubiasco, TI·26, TI·27 Mezzovico-Vira, TI·27.1, TI·27.2, TI·29, TI·30, TI·31, TI·32, TI·33, TI·34 Capriasca, TI·34.1, TI·34.2, TI·34.3, TI·35, TI·36 Davesco, TI·36.1, TI·36.2, TI·36.3, TI·37, TI·38, TI·39, TI·40 Stabio, TI·41, TI·41 Stabio, TI·42, TI·42 Stabio, TI·43, TI·44, TI·45.1, TI·45.2, TI·54, VA·6, VA·6 Vergiate, teromui
- De Marinis & Motta 2007: BG·49, BG·49 Caravaggio, BS·1, BS·15, BS·15 Gottolengo, Campo de Croppe, Cantacucco, Cascina Riccio, piuo
- De Marinis & Premoli Silva 1968-9: CO·47, CO·47 Breccia, CO·68, Como
- De Marinis & Rapi 2005: De Marinis 2005, De Marinis 2005b, Forcello
- De Marinis 1981: Archaeological Overview, CO·69, CO·70, TI·1 Gudo, Property:type
- De Marinis 1985: MN·1, MN·1 Bagnolo San Vito, sekenei
- De Marinis 1986: CO·53, CO·53 Prestino, CO·6 Rondineto, CO·62 Casate, CO·72, CO·72 San Fermo della Battaglia, CO·73, CO·73 Civiglio, North Italic Script
- De Marinis 1986b: Prosdocimi 1987b, VA·3, VA·3 Sesto Calende, VA·32, VA·5, VA·5 Golasecca
- De Marinis 1986–1987: Cattani 1986, De Marinis 1986b, NO·3, Pandolfini 1986, Prosdocimi 1986d, VA·3, VA·3 Sesto Calende
- De Marinis 1987: none
- De Marinis 1988: Archaeological Overview, Historical Overview, MS·1 Aulla, North Italic Script, The Cisalpine Celtic Languages
- De Marinis 1989: Mantova, Pa 0.3, Pa 0.3 Mantova, Vicolo Pace
- De Marinis 1991: Archaeological Overview, BS·5, CO·53, The Cisalpine Celtic Languages
- De Marinis 1991b: Archaeological Overview
- De Marinis 1992: BS·3.2, North Italic Script
- De Marinis 1999: BG·18 Parre, North Italic Script
- De Marinis 2000: TI·18 Giubiasco, TI·18.1, TI·18.2
- De Marinis 2001: CO·57 Prestino, CO·58 Prestino, CO·59 Prestino
- De Marinis 2005: MN·1, MN·1 Bagnolo San Vito, Pa 0.3, Pa 0.3 Mantova
- De Marinis 2005b: Forcello, Mantova
- De Marinis 2009: VA·3, VA·3 Sesto Calende, VA·31
- De Marinis 2009b: Presualdo, VA·3, VA·3 Sesto Calende, VA·4 Sesto Calende, VA·4.1, VA·4.2
- De Marinis 2009c: Galliasco, Monsorino, VA·5 Golasecca
- De Marinis 2009d: VA·31
- De Marinis 2009e: San Gallo di Ronchi, VA·6, VA·6 Vergiate
- De Marinis 2009f: Sant’Ambrogio