Osoba lub instytucja #381
Andrzej ZEBRZYDOWSKI
Andrzej Zebrzydowski (*1496 – †1560), pupil and householder of Erasmus of Rotterdam; 1530(?) dean at the collegiate chapter in Łęczyca; 1530 Cracow canon; 1531 - Płock; 1532 scholastic at the collegiate chapter in Warsaw; 1538 Poznań canon; 1543 bishop of Kamieniec; 1545 - Chełm; 1546 - Włocławek; 1551 - Cracow; chaplain of queen Bona Sforza; 1543 royal envoy to Roman King Ferdinand von Habsburg; 1549 - to Queen of Hungary Isabela Zápolya (Wy, 272) | ||||||||||||||||||||||||||||||||||||||||||||||||
__ 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 ("2900", "7419", "3003", "16", "3031", "3032", "3428", "6551", "6552", "3447") 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 Andrzej ZEBRZYDOWSKI Znaleziono: 0 zachowanych: 0 + zaginionych: 0 Teksty ze wzmianką o Andrzej ZEBRZYDOWSKI Results found: 15 IDL, 0 IDP, 0 IDT
|