__ 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 ("4103", "2444", "6797", "2382") 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
Teksty ze wzmianką o Bartholomeus VOGT Results found: 16 IDL, 0 IDP, 2 IDT | 1 | IDL 4893 |   Ioannes DANTISCUS do Albrecht I von Hohenzollern-Ansbach, Braunsberg (Braniewo), 1541-05-20 | | 2 | IDL 5026 | Albrecht I von Hohenzollern-Ansbach do Ioannes DANTISCUS, Königsberg (Królewiec), 1541-05-24 | | 3 | IDL 4895 | Ioannes DANTISCUS do Albrecht I von Hohenzollern-Ansbach, Braunsberg (Braniewo), 1541-05-29 | | 4 | IDL 5027 | Albrecht I von Hohenzollern-Ansbach do Ioannes DANTISCUS, Königsberg (Królewiec), 1541-06-01 | | 5 | IDL 4897 | Ioannes DANTISCUS do Albrecht I von Hohenzollern-Ansbach, Braunsberg (Braniewo), 1541-06-03 | | 6 | IDL 5029 | Albrecht I von Hohenzollern-Ansbach do Ioannes DANTISCUS, Königsberg (Królewiec), 1541-06-05 | | 7 | IDL 4898 | Ioannes DANTISCUS do Albrecht I von Hohenzollern-Ansbach, Braunsberg (Braniewo), 1541-06-08 | | 8 | IDL 2438 | Samuel MACIEJOWSKI do Ioannes DANTISCUS, Vilnius, 1541-06-16 | | 9 | IDL 2457 | [Ioannes DANTISCUS] do [Samuel MACIEJOWSKI], [Heilsberg (Lidzbark)], 1541-07-15 | | 10 | IDL 2370 | [Ioannes DANTISCUS] do [Samuel MACIEJOWSKI], Heilsberg (Lidzbark), 1541-07-19 | | 11 | IDL 2481 | Samuel MACIEJOWSKI do Ioannes DANTISCUS, Vilnius, 1541-08-15 | | 12 | IDL 5271 | Ioannes DANTISCUS do Albrecht I von Hohenzollern-Ansbach, Heilsberg (Lidzbark), 1541-10-29 | | 13 | IDL 2542 | Stanisław HOZJUSZ (HOSIUS) do Ioannes DANTISCUS, Vilnius, 1542-02-18 | | 14 | IDL 7069 | [Sigismund I Jagiellon] do Ioannes DANTISCUS, Vilnius, 1542-03-20 | | 15 | IDL 2555 | Stanisław HOZJUSZ (HOSIUS) do Ioannes DANTISCUS, Vilnius, 1542-03-31 | | 16 | IDL 2731 | Samuel MACIEJOWSKI do Ioannes DANTISCUS, Brok, 1544-06-05 |
__ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="593" 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="593" 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="593" 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="593" 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="593" order by position, objects_persons.complete_form __
QUERY ERROR!
Got error 28 from storage engine
| 1 | IDT 593 | Sentence by Ioannes DANTISCUS concerning LANGERBEIN’s inheritance Heilsberg (Lidzbark) 1540-01-26 | __ select text_from.* from text_from
left join objects_persons on text_from.person=objects_persons.id
where text="135" 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="135" 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="135" 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="135" 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="135" order by position, objects_persons.complete_form __
QUERY ERROR!
Got error 28 from storage engine
| 2 | IDT 135 | Mandate by Ioannes DANTISCUS concerning inheritance from escaped Rössel priest Georg LANGERBEIN Heilsberg (Lidzbark) 1545-07-20 | |