Person or Institution #379
Piotr ZBOROWSKI
Piotr Zborowski (†1553), 1515-1520 Crown carver; 1520-1527 - cup-bearer; 1531-1548 castellan of Małogoszcz; 1548-1553 - of Sandomierz; 1549 Sandomierz starosta (Urzędnicy 10, p. 217) | |||||||||
__ 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 ("7431", "3079", "7433", "3212", "3297", "3335", "7477", "3364", "3431") 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 Piotr ZBOROWSKI Results found: 0 preserved: 0 + lost: 0 Texts where mentioned Piotr ZBOROWSKI Results found: 3 IDL, 0 IDP, 0 IDT
|