__ 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 ("7493", "6745") 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 KONOPACKI Sr
List
Database
Full text
Results found: 0 preserved: 0 + lost: 0 Texts regarding Jan KONOPACKI Sr
List
Database
Full text
Results found: 1 preserved: 1 + lost: 0 | 1 | IDT 479 | Sigismund I Jagiellon to Jan KONOPACKI Sr [Brest-Litovsk] 1511-08-05 |
Texts where mentioned Jan KONOPACKI Sr Results found: 19 IDL, 0 IDP, 6 IDT | 1 | IDL 110 | Sigismund I Jagiellon to Ioannes DANTISCUS, [Brest-Litovsk], 1511-08-04 | | 2 | IDL 333 | Ioannes DANTISCUS to Fabian [WOJANOWSKI (DAMERAU)], Valladolid, 1527-05-01 | | 3 | IDL 3476 | Hieronymus AURIMONTANUS (GÜRTLER von Wildenberg) to Ioannes DANTISCUS, Löbau (Lubawa), 1530-04-24 | | 4 | IDL 488 | Fabian WOJANOWSKI (DAMERAU) to [Ioannes DANTISCUS], Cracow (Kraków), 1530-05-04 | | 5 | IDL 518 | Ioannes DANTISCUS to Sigismund I Jagiellon, Augsburg, 1530-07-30 | | 6 | IDL 520 | Ioannes DANTISCUS to [Piotr TOMICKI], Augsburg, 1530-08-01 | | 7 | IDL 835 | Ioannes DANTISCUS to Sigismund I Jagiellon, Althausen (Starogród), 1532-09-24 | | 8 | IDL 3549 | Mauritius FERBER to Ioannes DANTISCUS, Heilsberg (Lidzbark), 1532-11-29 | | 9 | IDL 870 | Ioannes DANTISCUS to Piotr TOMICKI, Löbau (Lubawa), 1532-12-29 | | 10 | IDL 4223 | Stanisław KOSTKA to Ioannes DANTISCUS, Marienburg (Malbork), 1533-11-24 | | 11 | IDL 1133 | Mikołaj DZIAŁYŃSKI (von DZIALIN) to Ioannes DANTISCUS, Strasburg in Preussen (Brodnica), 1534-03-18 | | 12 | IDL 1410 | Ioannes DANTISCUS to [Thomas of Bydgoszcz?], Löbau (Lubawa), 1536-01-31 | | 13 | IDL 1417 | Ioannes DANTISCUS to Kulm (Chełmno) Chapter, Löbau (Lubawa), 1536-02-18 | | 14 | IDL 1461 | Ioannes DANTISCUS to [Kulm (Chełmno) Chapter], Löbau (Lubawa), 1536-05-31 | | 15 | IDL 1478 | Ioannes DANTISCUS to [Kulm (Chełmno) Chapter], Löbau (Lubawa), 1536-06-07 | | 16 | IDL 1509 | Ioannes DANTISCUS to [Elbing Town Council?], Löbau (Lubawa), 1536-07-17 | | 17 | IDL 1618 | Johann TYMMERMANN to Ioannes DANTISCUS, Frauenburg (Frombork), 1537-04-06 | | 18 | IDL 3616 | Thomas [of Bydgoszcz] to Ioannes DANTISCUS, Althausen (Starogród), 1538-02-12 | | 19 | IDL 4781 | Tiedemann GIESE to Ioannes DANTISCUS, Löbau (Lubawa), 1539-09-09 |
__ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="483" 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="483" 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="483" 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="483" 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="483" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 1 | IDT 483 | Record of Provincial Diet of Royal Prussia Marienburg (Malbork) 1512-01-25 — 1512-01-29 | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="544" 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="544" 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="544" 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="544" 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="544" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 2 | IDT 544 | Sigismund I Jagiellon [ca. 1524-02-04] | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="161" 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="161" 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="161" 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="161" 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="161" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 3 | IDT 161 | Instruction of Ioannes DANTISCUS for Georg von HÖFEN, envoy to Albrecht I von Hohenzollern-Ansbach Löbau (Lubawa) 1535-12-31 | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="160" 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="160" 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="160" 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="160" 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="160" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 4 | IDT 160 | Testimony for ecclesiastical judges of Roman Catholic Church Löbau (Lubawa) 1536-01-07 | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="107" 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="107" 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="107" 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="107" 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="107" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
| 5 | IDT 107 | Deed of gift for Johann von HÖFEN (Jan HARTOWSKI) & Dorothea, daughter of Lorenz von HÖFEN Heilsberg (Lidzbark) 1543-11-09 | |