__ select letters.*,
max(letter_d_nadania.end) as data_nadania,
min(replace(o_p.sorting_form, " UNKNOWN", "ZZZZZUNK")) as first_addressee, min(letter_publications.number)as ceid_number,
(select min(ls.idd) from letter_sources as ls where ls.idl=letters.id and ls.`primary`="1") as primary_source
from letters
left join letter_publications on letter_publications.idl=letters.id
left join letter_from_date_interval as letter_d_nadania on letter_d_nadania.idl=letters.id
left join text_person as letter_t on letter_t.text_id=letters.id
left join objects_persons as o_p on letter_t.person=o_p.id
where 1 and letters.id in ("3517", "3533", "810", "814", "1178", "5815", "7259", "3622", "2068", "7295", "2278", "2291", "2292", "7371", "2603", "7396", "2620", "2660", "7245", "358", "7339", "2898", "4635", "3352", "7395", "3392") and letter_t.text_type="letter" and letter_t.role="2"
group by letters.id
order by data_nadania , first_addressee, ceid_number
__ QUERY ERROR! Got error 28 from storage engine
Correspondence between Dantiscus and Jan TARNOWSKI
List
Database
Full text
Results found: 0 preserved: 0 + lost: 0 Texts where mentioned Jan TARNOWSKI Results found: 40 IDL, 0 IDP, 2 IDT | 1 | IDL 6227 | Ioannes DANTISCUS to Piotr TOMICKI, Plymouth, 1522-10-29 | | 2 | IDL 6225 | Ioannes DANTISCUS to Sigismund I Jagiellon, Plymouth, 1522-11-10 | | 3 | IDL 352 | Jan ZAMBOCKI to Ioannes DANTISCUS, Cracow (Kraków), 1527-06-14 | | 4 | IDL 363 | Piotr TOMICKI to Ioannes DANTISCUS, Cracow (Kraków), 1527-08-16 | | 5 | IDL 3538 | Camillo GHILINO to Ioannes DANTISCUS, Regensburg, 1532-08-29 | | 6 | IDL 824 | Alfonso de VALDÉS to Ioannes DANTISCUS, Regensburg, 1532-09-03 | | 7 | IDL 831 | Alfonso de VALDÉS to Ioannes DANTISCUS, Passau, 1532-09-11 | | 8 | IDL 3541 | Jan CHOJEŃSKI to Ioannes DANTISCUS, Cracow (Kraków), 1532-10-04 | | 9 | IDL 922 | Cornelis DE SCHEPPER to Ioannes DANTISCUS, Vienna, 1533-03-27 | | 10 | IDL 1073 | Jan CHOJEŃSKI to Ioannes DANTISCUS, Vilnius, 1534-01-04 | | 11 | IDL 1089 | [Ioannes DANTISCUS] to [Cornelis DE SCHEPPER], Löbau (Lubawa), 1534-01-11 | | 12 | IDL 1118 | Cornelis DE SCHEPPER to Ioannes DANTISCUS, Prague, 1534-02-13 | | 13 | IDL 1250 | Maciej DRZEWICKI to Ioannes DANTISCUS, Tum near Łęczyca, 1534-12-24 | | 14 | IDL 1256 | Piotr TOMICKI to Ioannes DANTISCUS, Kielce, 1535-01-01 | | 15 | IDL 1317 | Mikołaj GRABIA to Ioannes DANTISCUS, Vilnius, 1535-06-14 | | 16 | IDL 1321 | Seweryn BONER to Ioannes DANTISCUS, Cracow (Kraków), 1535-06-25 | | 17 | IDL 1334 | Hieronim ŁASKI to Ioannes DANTISCUS, Hohenstein (Olsztynek), 1535-07-18 | | 18 | IDL 1385 | [Ioannes DANTISCUS] to Cornelis [DE SCHEPPER] & Godschalk ERICKSEN (SASSENKERLE), Löbau (Lubawa), 1535-12-23 | | 19 | IDL 1614 | Jan Benedyktowicz SOLFA to Ioannes DANTISCUS, s.l., ca. 1537-04-23 | | 20 | IDL 3619 | Paweł PŁOTOWSKI to Ioannes DANTISCUS, Piotrków, 1538-02-15 | | 21 | IDL 3628 | Paweł PŁOTOWSKI to Ioannes DANTISCUS, Frauenburg (Frombork), 1538-03-10 | | 22 | IDL 3642 | Paweł PŁOTOWSKI to Ioannes DANTISCUS, Frauenburg (Frombork), 1538-04-16 | | 23 | IDL 1908 | Jerzy MYSZKOWSKI to Ioannes DANTISCUS, Cracow (Kraków), 1538-08-27 | | 24 | IDL 1911 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1538-08-31 | | 25 | IDL 1932 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Niepołomice, 1538-09-27 | | 26 | IDL 1966 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1538-11-04 | | 27 | IDL 2010 | Feliks (Szczęsny) SRZEŃSKI (SOKOŁOWSKI) to Ioannes DANTISCUS, Płock, 1538-12-05 | | 28 | IDL 4979 | Albrecht I von Hohenzollern-Ansbach to Ioannes DANTISCUS, Königsberg (Królewiec), 1540-02-17 | | 29 | IDL 4988 | Albrecht I von Hohenzollern-Ansbach to Ioannes DANTISCUS, Königsberg (Królewiec), 1540-03-25 | | 30 | IDL 2513 | Stanisław HOZJUSZ (HOSIUS) to Ioannes DANTISCUS, Vilnius, 1541-11-18 | | 31 | IDL 5279 | Ioannes DANTISCUS to Johann von KREYTZEN, Heilsberg (Lidzbark), 1542-03-17 | | 32 | IDL 2837 | Stanisław GÓRSKI to Ioannes DANTISCUS, Cracow (Kraków), 1545-06-13 | | 33 | IDL 2918 | Stanisław WŁOSZEK to Ioannes DANTISCUS, Vilnius, 1546-03-01 | | 34 | IDL 3130 | Stanisław GÓRSKI to Ioannes DANTISCUS, Cracow (Kraków), 1547-06-18 | | 35 | IDL 3334 | Martin ALLEXWANGEN to Ioannes DANTISCUS, Piotrków, 1548-01-28 | | 36 | IDL 3383 | Jan Benedyktowicz SOLFA to Ioannes DANTISCUS, Cracow (Kraków), 1548-06-29 | | 37 | IDL 3384 | Martin ALLEXWANGEN to Ioannes DANTISCUS, Cracow (Kraków), 1548-06-29 | | 38 | IDL 3385 | Stanisław HOZJUSZ (HOSIUS) to Ioannes DANTISCUS, Cracow (Kraków), 1548-06-29 | | 39 | IDL 3389 | Stanisław GÓRSKI to Ioannes DANTISCUS, Cracow (Kraków), 1548-06-30 | | 40 | IDL 3417 | Mikołaj PŁOTOWSKI to Ioannes DANTISCUS, Cracow (Kraków), 1548-07-27 |
__ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="418" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_to.* from text_to
left join objects_persons on text_to.person=objects_persons.id
where text="418" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_principal.* from text_principal
left join objects_persons on text_principal.person=objects_persons.id
where text="418" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_connection.* from text_connection
left join objects_persons on text_connection.person=objects_persons.id
where text="418" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_witness.* from text_witness
left join objects_persons on text_witness.person=objects_persons.id
where text="418" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 1 | IDT 418 | Ioannes DANTISCUS, Victoria Sigismundi primi regis Poloniae contra Vayevodam Muldaviae Brussels 1531-09-24 | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="769" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_to.* from text_to
left join objects_persons on text_to.person=objects_persons.id
where text="769" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_principal.* from text_principal
left join objects_persons on text_principal.person=objects_persons.id
where text="769" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_connection.* from text_connection
left join objects_persons on text_connection.person=objects_persons.id
where text="769" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine __ select text_witness.* from text_witness
left join objects_persons on text_witness.person=objects_persons.id
where text="769" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 2 | IDT 769 | UNKNOWN to UNKNOWN Cracow (Kraków)? 1542-08-27 — 1543-01-03 | |