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, t4.o_hash
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=1313)
AND (t4.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
500
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, t4.o_hash
FROM
`lexlep_smw_object_ids` AS t0
INNER JOIN
`lexlep_smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`lexlep_smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=1313)
AND (t4.p_id=1199080)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t4.o_hash ASC
LIMIT
55
OFFSET
500
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 | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | lexlepwebu54.t1.s_id, const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Gorini 1984: Morandi 1984
- Gorini 1994: Arslan 1994, Brenot 1994, Buora 1994, Marinetti & Prosdocimi 1994, Mollo Mezzena 1994, Saccocci 1994
- Gorini 1998: Numismatics
- Gorini 2000: NM·6.1, NM·6.2, Numismatics
- Gorini 2014: none
- GPC: pala
- GPN: )rkomui, The Cisalpine Celtic Languages, ad-, aged-, alios, amaśilu, ambi-, anarekartos, ande-, anteśilu, ass-, ate-, atepu, ateratos, banu̯-, bir(r)-, bog-, bou̯d-, brig-, brog-, brīg-, buđ-, dubn-, dēu̯-, dī-, dūr-, el-, ep-, eripoχios, eskiko, eskikorikos, esopnio, exobna, eχs-, gon(n)-, inutu, i̯ant-, kai̯-, kart-, kasios, kass-, kat-, keleśu, kiketu, king-, kint-, kob-, kom-, koma, kott-, latumarui, leu̯k-, mag-, mat-, matopokios, metalui, metelui, namu, natom, natoris, naθina, nemetieś, oletu, onis, pirakos, polios, rat-, ret-, retalos, ređ-, rii̯-, rit-, rēm-, rīg-, seg-, sura, takos, tal-, tanotalos, tekialui, teuoχtoni(o)n, toutiopouos, tou̯t-, trutiknos, ueca, uenia, uiro, u̯allau̯n-, u̯en-, u̯er-, u̯ik-, u̯ind-, u̯rīt-
- Granucci 1975: GR·1, North Italic Script, The Cisalpine Celtic Languages
- Grassi & Mella Pariani 2009: none
- Grassi & Pizzo 2014: Maras 2014b
- Graue 1974: Property:date
- Green 1995: Frey 1995
- Gregori 1990: Brescia
- Gregori 2000: Brescia
- Griffith 2005: artuaś, siteś
- GS Massari Gaballo & Tocchetti Pollini 1986: Arslan 1986, Tibiletti Bruno 1986
- Guichard et al. 1988: BR·1, BR·1 Marseille, File:Guichard et al. 1988 fig7.102.png
- Guštin & David 2014: Gorini 2014
- Göbl 1973: NM·1, NM·13, NM·9, Numismatics, tikou
- Hackens & Weiller 1982: Pautasso 1982
- Haeussler & King 2017: Falileyev 2017
- Hajek 1997: none
- Haller 1829: NM·9
- Hamp 1953: u̯er-
- Hamp 1973: ande-
- Hamp 1974: uenia, uvamokozis
- Hamp 1974b: u̯īt-
- Hamp 1976: i̯ant-
- Hamp 1980: u̯ind-
- Hamp 1982: none
- Hamp 1982b: none
- Hamp 1989: BS·3 Voltino, BS·3.2, to, θomezeclai
- Hamp 1990: NO·21.1, brist-
- Hamp 1991: brig-
- Hamp 1991b: kalite, karite
- Hamp 1992: brist-
- Harari 2017: Harari 2017b, Morandi 2017, Pearce 2017, Prosdocimi & Solinas 2017, Rondini 2017
- Harari 2017b: none
- Heidermanns et al. 1993: McCone 1993
- Herbig 1906: NM·16, TI·11, TI·12, TI·13, TI·15, TI·17, TI·19, TI·2, TI·3, TI·5, TI·6, TI·7, TI·7 Giubiasco, TI·8, TI·9, VB·12, VB·2
- Herbig 1911: none
- Hiriart et al. 2018: Goddard 2018, Lambert 2018, Piana Agostinetti 2018, Poccetti 2018, Verger 2018
- Hirt 1905–1907: VB·3.1
- Hirt 1917: TI·41, VB·3.1, pala
- Hirunuma 1986: none
- Hirunuma 1990: pala
- Hodson 1968: BE·1, BE·1 Münsingen, Rain
- Hormayr 1823: PD·1 Ženjak, TI·36 Davesco, TI·36.1, TI·36.2
- Höfler 2017: pala
- Höfler 2017b: poininos