__ 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 ("510", "6070", "5519", "7262", "2482", "3095", "3097", "3154", "4680", "4670") 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 Fabian von ZEHMEN
List
Database
Full text
Results found: 0 preserved: 0 + lost: 0 Texts where mentioned Fabian von ZEHMEN Results found: 36 IDL, 0 IDP, 1 IDT | 1 | IDL 556 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1530-10-04 | | 2 | IDL 3499 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1530-12-09 | | 3 | IDL 35 | [Fabian WOJANOWSKI (DAMERAU)] to [Ioannes DANTISCUS], s.l., [1531-08] | | 4 | IDL 686 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1531-09-20 | | 5 | IDL 999 | Georg von BAYSEN (BAŻYŃSKI) to Ioannes DANTISCUS, Mewe (Gniew), 1533-08-30 | | 6 | IDL 4538 | Georg von BAYSEN (BAŻYŃSKI) to Ioannes DANTISCUS, Mewe (Gniew), 1534-12-29 | | 7 | IDL 1283 | Mauritius FERBER to Ioannes DANTISCUS, Heilsberg (Lidzbark), 1535-02-23 | | 8 | IDL 5618 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1537-03-21 | | 9 | IDL 1605 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, s.l., 1537-03-27 | | 10 | IDL 1874 | Felix REICH to Ioannes DANTISCUS, Frauenburg (Frombork), 1538-07-18 | | 11 | IDL 1894 | Kaspar HANNAU to Ioannes DANTISCUS, Cracow (Kraków), 1538-08-04 | | 12 | IDL 1923 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1538-09-15 | | 13 | IDL 1956 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1538-10-31 | | 14 | IDL 1984 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Cracow (Kraków), 1538-11-13 | | 15 | IDL 2108 | Fabian WOJANOWSKI (DAMERAU) to Ioannes DANTISCUS, Christburg (Dzierzgoń), 1539-03-15 | | 16 | IDL 2132 | Ioannes DANTISCUS to Tiedemann GIESE, Heilsberg (Lidzbark), 1539-04-12 | | 17 | IDL 4777 | Tiedemann GIESE to Ioannes DANTISCUS, Löbau (Lubawa), 1539-06-11 | | 18 | IDL 5677 | Georg von BAYSEN (BAŻYŃSKI) to Ioannes DANTISCUS, Schoneck (Skarszewy), 1539-06-12 | | 19 | IDL 2289 | Samuel MACIEJOWSKI to Ioannes DANTISCUS, Cracow (Kraków), 1540-03-10 | | 20 | IDL 7068 | [Samuel MACIEJOWSKI?] to Ioannes DANTISCUS, Vilnius, 1542-03-13 | | 21 | IDL 5282 | Ioannes DANTISCUS to Albrecht I von Hohenzollern-Ansbach, Heilsberg (Lidzbark), 1542-05-25 | | 22 | IDL 2591 | Council of Royal Prussia to Ioannes DANTISCUS, Graudenz (Grudziądz), 1542-10-03 | | 23 | IDL 2676 | Stanisław HOZJUSZ (HOSIUS) to Ioannes DANTISCUS, Sandomierz, 1543-11-02 | | 24 | IDL 2815 | Tiedemann GIESE to Ioannes DANTISCUS, Löbau (Lubawa), 1545-04-14 | | 25 | IDL 2822 | Sigismund II Augustus Jagiellon to Ioannes DANTISCUS, Vilnius, 1545-05-01 | | 26 | IDL 2915 | Stanisław HOZJUSZ (HOSIUS) to Ioannes DANTISCUS, Cracow (Kraków), 1546-02-18 | | 27 | IDL 2932 | Samuel MACIEJOWSKI to Ioannes DANTISCUS, Cracow (Kraków), 1546-03-11 | | 28 | IDL 3005 | Paweł PŁOTOWSKI to Ioannes DANTISCUS, Frauenburg (Frombork), 1546-11-01 | | 29 | IDL 3109 | Maciej KALECKI of Mąkolin to Ioannes DANTISCUS, Vilnius, 1547-06-08 | | 30 | IDL 4459 | Ioannes DANTISCUS to Gdańsk Town Council, Heilsberg (Lidzbark), 1547-06-14 | | 31 | IDL 3133 | Ioannes DANTISCUS to Stanisław KOSTKA, Heilsberg (Lidzbark), 1547-06-20 | | 32 | IDL 3170 | Ioannes DANTISCUS to Georg von PREUCKEN, Heilsberg (Lidzbark), 1547-07-22 | | 33 | IDL 3279 | Ioannes DANTISCUS to Stanisław KOSTKA, Heilsberg (Lidzbark), 1547-12-09 | | 34 | IDL 3288 | Ioannes DANTISCUS to Stanisław KOSTKA, Heilsberg (Lidzbark), 1547-12-13 | | 35 | IDL 3290 | [Ioannes DANTISCUS] to Sigismund II Augustus Jagiellon, Heilsberg (Lidzbark), 1547-12-19 | | 36 | IDL 360 | Sigismund I Jagiellon to Ioannes DANTISCUS, [Cracow (Kraków)], 1548-03-15 |
__ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="671" 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="671" 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="671" 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="671" 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="671" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 1 | IDT 671 | Councillors of Royal Prussia to Sigismund I Jagiellon Löbau (Lubawa) 1539-06-14 | |