Semantic search
From Thesaurus Inscriptionum Raeticarum
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=2598883)
AND (t4.p_id=2598877)
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
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
INNER JOIN
`smw_di_blob` AS t4 ON t0.smw_id=t4.s_id
WHERE
(t1.o_id=2598883)
AND (t4.p_id=2598877)
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 | 924 | Using index; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | tirwebspas52.t1.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, p_id, s_id_2 | s_id | 8 | tirwebspas52.t1.s_id, const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- Mayr 1959d: CE-1.1, CE-1.2, CE-1.3, CE-1.4, CE-1.5
- Mayr 1959e: RN-1
- Mayr 1960: ST-1, ST-2, ST-3, ST-4, ST-5, ST-6, ST-7
- Mayr 1960b: none
- Mayr 1960c: BZ-11, BZ-4, BZ-4 fragment
- Mayr 1960d: BZ-14
- Mayr 1960e: BZ-3
- Mayr 1960f: NO-2, NO-2 strainer, Non-script notational systems, SZ-16, SZ-3
- Mayr 1960g: PU-1
- Mayr 1961: VR-3
- Mayr 1961b: none
- Mayr 1961c: The Feltre inscription stones
- Mayr 1962: NO-7, ST rock, SZ-10.1, SZ-10.2, SZ-18, SZ-4.2, SZ-5.2
- Mayr 1962b: BZ-6, Modern research on Raetic
- Mayr 1962c: ST-8
- Mayr 1963: none
- Mayr 1965: SR-1, SR-5
- Mayr 1969: SR-3.1, SR-3.2
- Meid et al. 1971: Joppich 1971, Menghin 1971, Prosdocimi 1971, Ölberg 1971
- Menghin 1911: Modern research on Raetic
- Menghin 1912: none
- Menghin 1914: Modern research on Raetic, Non-script notational systems, RN-1
- Menghin 1917: none
- Menghin 1958: none
- Menghin 1961: WE-5 potsherd
- Menghin 1970: Ancient sources
- Menghin 1971: none
- Menghin 1984: none
- Menghin 1999: Weiss 1999, Weiss 1999b, Weiss 1999c
- Mentz 1954–55: SL-2.4
- Mérey-Kádar 1958: SZ-82, SZ-82 cist
- Merhart 1926: SZ-29 bowl, SZ-52 bowl, SZ-54 bowl, SZ-59 bowl, SZ-60 bowl, SZ-61 bowl, SZ-83 bowl
- Merhart 1927: WE-5 potsherd
- Merhart 1969: none
- Metzger 1993: none
- Metzger & Gleirscher 1992: Ciurletti 1992, Dal Rì 1992b, De Marinis 1992, Demetz 1992, Frei-Stolba 1992, Gleirscher 1992, Lang 1992, Leonardi 1992, Lora & Ruta Serafini 1992, Marinetti 1992, Marzatico 1992, Rageth 1992, Risch 1992, Schubert 1992, Sperber 1992, Stadler 1992, Sölder 1992
- Meyer 1901: BZ-3, BZ-4
- Meyer 1970: none
- MLR: AS-1, AS-10, AS-11, AS-12, AS-13, AS-14, AS-15.1, AS-15.2, AS-16, AS-17 potsherd, AS-17.1, AS-17.2, AS-18, AS-18 potsherd, AS-19.1, AS-19.2, AS-2, AS-20 potsherd, AS-20.1, AS-20.2, AS-21.1, AS-21.2, AS-23 beaker, AS-3, AS-3 potsherd, AS-4, AS-5, AS-6, AS-7, AS-8, AS-9, AV-1, Archaeology in the Raetic area, BZ-1, BZ-1 potsherd, BZ-10.1, BZ-10.2, BZ-11, BZ-11 cist, BZ-12, BZ-12 key, BZ-13, BZ-14, BZ-15, BZ-16, BZ-17, BZ-19, BZ-19 sickle, BZ-2, BZ-20, BZ-20 potsherd, BZ-21, BZ-21 potsherd, BZ-22, BZ-22 potsherd, BZ-23, BZ-23 potsherd, BZ-3, BZ-4, BZ-5, BZ-6, BZ-7.2, BZ-8.1, BZ-8.2, BZ-9, CE-1.1, CE-1.2, CE-1.3, CE-1.4, CE-1.5, Concordance, EN-1, EN-1 potsherd, FI-1, FI-1 antler, HU-1, HU-4.1, HU-4.2, HU-4.3, HU-5.1, HU-5.2, HU-5.3, HU-6, HU-7, How to use TIR, IT-1, IT-1 potsherd, IT-2, IT-3, IT-3 potsherd, IT-4, IT-5, IT-6, Category:Inscription, MA-1, MA-1 antler, MA-10, MA-10 antler, MA-11, MA-11 antler, MA-12, MA-12 antler, MA-13, MA-13 antler, MA-14, MA-14 antler, MA-15 antler, MA-16, MA-16 antler, MA-17, MA-17 antler, MA-18, MA-18 antler, MA-19, MA-19 antler, MA-2, MA-2 antler, MA-20, MA-20 antler, MA-21, MA-21 antler, MA-22, MA-22 antler, MA-23, MA-23 antler, MA-24, MA-24 ingot, MA-3 antler, MA-4, MA-4 antler, MA-5, MA-5 antler, MA-6, MA-6 antler, MA-7, MA-7 antler, MA-8, MA-8 antler, MA-9, MA-9 antler, Modern research on Raetic, NO-1, NO-1 fragment, NO-10, NO-11, NO-12, NO-12 bowl, NO-13, NO-14, NO-14 potsherd, NO-15, NO-15 rod, NO-16, NO-16 bronze, NO-17, NO-17 bone point, NO-18, NO-18 bowl, NO-2, NO-3, NO-4, NO-4 antler, NO-6, NO-7, NO-8, NO-9, Non-script notational systems, P, PA-1, PU-1, PU-10, PU-10 potsherd, PU-11, PU-11 stone, PU-2, PU-3, PU-4, PU-5, PU-5 bone, PU-6, PU-6 bone, PU-7, PU-7 bone, PU-8, PU-8 potsherd, PU-9, PU-9 potsherd, RN-1, RN-2, SL-1, SR-1, SR-11, SR-2, SR-3.1, SR-3.2, SZ-1.1, SZ-19, SZ-19 handle, SZ-20, SZ-20 bronze, SZ-21, SZ-22 antler, SZ-22.1, SZ-22.2, SZ-23, SZ-23 antler, SZ-24, SZ-24 antler, SZ-27 potsherd, SZ-27.1, SZ-27.2, SZ-28, SZ-28 bowl, SZ-29, SZ-29 bowl, SZ-30, SZ-32, SZ-32 antler, SZ-34, SZ-36, SZ-52, SZ-52 bowl, SZ-54, SZ-54 bowl, SZ-63 antler, SZ-63.2, SZ-74, SZ-76.1, SZ-76.2, SZ-77, SZ-78, SZ-79.1, SZ-79.2, SZ-80, SZ-81, SZ-84, SZ-84 potsherd, SZ-85, SZ-85 bowl, SZ-86, SZ-86 potsherd, SZ-87, SZ-87 rod, SZ-89, SZ-90, SZ-91.1, SZ-94, SZ-96, SZ-96 rod, SZ-97, SZ-98, Script, Soprintendenza Archeologia del Veneto – Nucleo Operativo di Verona, Suotchastè, TR-1 bone, TR-1.1, TR-1.2, TR-2, TR-2 bone, TR-3, TR-3 bone, TR-4, TR-4 bone, VN-1, VN-11, VN-11 bone point, VN-12, VN-12 bone point, VN-2, VN-2 bone, VN-7 bone, VN-8, VN-8 bone, VN-9, VN-9 bone point, VR-1, VR-1 antler, VR-10, VR-10 bronze, VR-11, VR-11 bronze, VR-12, VR-12 bone, VR-13, VR-13 bone, VR-14, VR-14 bone, VR-15, VR-15 bone, VR-16, VR-16 bone, VR-17, VR-17 bone point, VR-2, VR-2 antler, VR-3, VR-4, VR-4 bone, VR-6, VR-6 antler, VR-7, VR-7 bone, VR-8, VR-8 bone, VR-9 potsherd, WE-1, WE-2, WE-3, WE-3 antler, WE-4, WE-5 potsherd, WE-5.1, WE-5.2, WE-6, WE-6 potsherd, WE-7, WE-7 potsherd, Property:sigla mlr
- Mode e modelli 2012: Marchesini 2012
- Mommsen 1853: CE-1.1, CE-1.2, CE-1.3, CE-1.4, CE-1.5, Modern research on Raetic, SL-2 helmet, SL-2.1, SL-2.2, Script, VR-3, WE-1
- Mommsen 1854–85: Modern research on Raetic
- Morandi 1982: CE-1.1, CE-1.2, CE-1.3, CE-1.4, CE-1.5, MA-10, MA-19, MA-8, MA-9, SZ-1.1, SZ-1.2, SZ-3, SZ-4.1, The Feltre inscription stones
- Morandi 1999: MA-15 antler, MA-4 antler, Modern research on Raetic, PU-1 girdle plate, SZ-30 situla, TV-1 slab, TV-1.1, TV-1.2, The Feltre inscription stones, WE-3, WE-3 antler, terisna
- Morandi 2000: T, terisna
- Morandi 2004: none
- Morandi 2004–09: none
- Morigi Govi & Colonna 1981: none
- Museo Ritrovato 1986: Colle di Castello, TR-1 bone, TR-2 bone, TR-3 bone, TR-4 bone
- Mutschlechner 1983: ST rock