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
550
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
550
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- IEW: alios, an-, ande-, arkatokomaterekos, artonis, ate-, ateknati, aśouni, belg-, brist-, brīg-, buđ-, dēu̯-, el-, enu, eripoχios, exobna, gal-, galat-, i̯ant-, kai̯-, kart-, kass-, kat-, kiketu, king-, kint-, klut-, kob-, koisis, koi̯l-, komeuios, leu̯k-, lokan, mat-, medi̯-, meśiolano, minui, nerios, onis, pala, penilas, petua(, pli-, pruiam, sabi, takos, tal-, tep-, toutas, tou̯t-, trutiknos, uasekia, uasi, uenia, u̯al-, u̯en-, u̯ik-, u̯rīt-, ēt-
- Ifrah 1986: North Italic Script
- Irslinger 2002: -et-, ai̯u-, bit-, bog-, brist-, galat-, i̯ant-, kalatiknos, kass-, kat-, king-, kint-, klut-, mat-, pirauiχeś, prit-, rat-, rit-, tengu̯-, teđ-, toutas, tou̯t-, u̯iđ-, u̯rīt-, u̯īt-, ēt-
- Isaac 2007: Stifter 2011, Stifter 2012d
- Istenič 1985: none
- Istenič 1999: PD·2 Hajdina, Poetovio western necropolis
- Istenič 2000: PD·2, PD·2 Hajdina, File:PD·2 Hajdina drawing.png, File:PD·2 drawing Istenič.png
- Jacobsohn 1923: none
- Jacobsohn 1927: GR·1, MI·7.1, MI·7.2, TI·34.1, TI·34.2, TI·34.3, TI·36.1, TI·36.2, TI·37, TI·39, TI·40, TI·41, TI·42, VB·2, VB·26, VB·27, VB·28, VB·3.1, ualaunal
- Jacobsthal & Langsdorff 1929: TI·18 Giubiasco, TI·18.1, TI·18.2
- Jasanoff 1991: buđ-
- Jecklin 1891: none
- Jeffery 1961: VA·4.1
- Jordán Cólera 1998: none
- Jorio 2003: BG·29 Verdello, BG·35 Verdello, BG·36 Verdello, BG·36.1, BG·36.2
- Joseph 1982: kal-, kalatiknos, u̯allau̯n-
- Jospin & Dalaine 2011: Rubat Borel 2011
- KGP: )rkomui, BE·1, ad-, aged-, akluśamoualos, alk-, alkouinos, amaśilu, ambi-, anarekartos, anareuiśeos, ande-, anokopokios, anteśilu, are-, ass-, ate-, ateknati, ateporix, atepu, ateratos, aśkoneti, aśkonetio, bir(r)-, bit-, biu̯-, bog-, bou̯-, bou̯d-, brīg-, buđ-, dall-, dubn-, dēu̯-, dī-, el-, ep-, esanekoti, eskiko, eskikorikos, exobna, gon(n)-, in-, inutu, i̯ant-, i̯ou̯ink-, kal-, kart-, kass-, kat-, kiketu, king-, kint-, kob-, kom-, kott-, leu̯k-, mag-, mant-, mat-, medi̯-, metalui, mīn-, nemetieś, pompe-, prikou, rat-, ret-, retalos, ređ-, rii̯-, rit-, ritukalos, rupelos, rīg-, rūn-, seg-, sent-, set-, snaśiouitos, sola, sunalei, tal-, tanotalos, teđ-, tikou, tou̯t-, trutiknos, tunal, uenia, uerkalai, u̯allau̯n-, u̯en-, u̯er-, u̯es-, u̯id-, u̯ik-, u̯ind-, u̯rīt-, u̯īs-, u̯īt-, vemetuvis
- KP: ag-, akitu, tetu, uvamokozis, θomezeclai
- Kaenel 2000: JU·1, JU·1 Montmorot, File:JU·1 drawing Verger.png
- Kajanto 1965: uericou
- Karl & Leskovar 2009: Stifter 2009b
- Katalog Zürich 1978: Castelin 1978
- Keller & Meyer 1865: TI·41, TI·41 Stabio, TI·42
- Kenrick 2006: BG·36.1
- Kientz 1943: TI·15, TI·16, TI·16 Giubiasco
- Kloekhorst 2008: kat-
- Koch 1983: BS·3 Voltino, BS·3.2, Eska 1989, tośokote
- Koch 1985: BS·3.2
- Kos 2004: Numismatics
- Krahe 1936: -al-, North Italic Script, The Cisalpine Celtic Languages, VB·26
- Krahe 1954: Schmidt 1965
- Krahe 1958: Untermann 1958
- Kretschmer 1905: -al-, GR·1, Herbig 1906, The Cisalpine Celtic Languages, VB·1, VB·10, VB·11, VB·12, VB·13, VB·14, VB·16, VB·17, VB·2, VB·3.1, VB·3.2, VB·3.3, VB·3.4, VB·4, VB·6, VB·7, VB·8, VB·9, alkouinos, kualui, pala, ualaunal
- Kretschmer 1943: -al-, Kretschmer 1951, PD·1, dieupala
- Kretschmer 1951: none
- Krisch & Lindner 2011: Stifter 2011c
- Kroonen 2013: alk-, belg-, brīg-, kart-, kat-, kob-, koliuetu, pruiam, seg-, tou̯t-, u̯en-
- Kruta 2000: Numismatics
- Kruta 2004: Morandi 2004b
- Kunow 1985: TI·4
- Ködderitzsch 1986: rii̯-
- LEIA: -il(l)-, -ul(l)-, ag-, aged-, ai̯u-, akitu, an-, anarekartos, ande-, are-, at(t)-, ate-, ater-, au̯-, belg-, bir(r)-, biu̯-, brig-, brist-, buđ-, dall-, dēu̯-, dūr-, i̯ou̯ink-, kal-, kart-, kass-, kat-, king-, kint-, klut-, koi̯l-, koliuetu, mag-, mant-, mat-, medi̯-, mīn-, penn-, prit-, priś, pruiam, raneni, rūn-, sent-, tal-, tengu̯-, tep-, teđ-, tikou, toutas, tou̯t-, u̯ik-
- LIPP: ate-
- LIR: VR·19
- LIV²: alk-, biu̯-, bog-, dut-, gal-, galat-, i̯ant-, karite, kart-, kat-, king-, klut-, komeuios, leu̯k-, mīn-, pala, rat-, seg-, sent-, tep-, tetu, tou̯t-, uerkalai, u̯al-, u̯allau̯n-, u̯en-, u̯ik-, u̯ind-, u̯rīt-, u̯īt-, ēt-
- Lacroix 2016: dubn-
- Lamanna 2014: Forcello
- Lambert & Pilon 2018: in-
- Lambert & Pinault 2007: Anreiter & Roider 2007, Sims-Williams 2007, Uhlich 2007