__ 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 ("5560", "4507", "3790") 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
Korespondencja pomiędzy Dantyszkiem i Bartholomeus SENGER Jr
Spis
Baza danych
Pełny tekst
Znaleziono: 0 zachowanych: 0 + zaginionych: 0 Teksty ze wzmianką o Bartholomeus SENGER Jr Results found: 6 IDL, 0 IDP, 1 IDT 1 | IDL 718 | Johann REYNECK do Ioannes DANTISCUS, Gdańsk (Danzig), 1531-11-29 | 2 | IDL 4317 | Ioannes DANTISCUS do Gdańsk Town Council, Löbau (Lubawa), 1532-10-15 | 3 | IDL 5885 | Gdańsk Town Council do Ioannes DANTISCUS, Gdańsk (Danzig), 1532-10-21 | 4 | IDL 4015 | Ioannes DANTISCUS do [Johann von WERDEN?], Althausen (Starogród), 1536-04-23 | 5 | IDL 6094 | Johann von WERDEN do Ioannes DANTISCUS, Gdańsk (Danzig), 1537-03-15 | 6 | IDL 4390 | Ioannes DANTISCUS do Gdańsk Town Council, Braunsberg (Braniewo), 1541-06-09 |
__ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="63" 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="63" 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="63" 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="63" 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="63" order by position, objects_persons.complete_form __ QUERY ERROR! Got error 28 from storage engine
1 | IDT 63 | Statement of Ioannes DANTISCUS concerning inheritance from Margret SENGER for Simon HANNAU Heilsberg (Lidzbark Warmiński) 1539-06-06 | |