» CORPUS of Ioannes Dantiscus' Texts & Correspondence
Copyright © Laboratory for Source Editing and Digital Humanities AL UW

All Rights Reserved. No part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording or any other information storage and retrieval system, without prior permission in writing from the publisher.

A-Z A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

__ select * from objects_persons where objects_persons.sorting_form like "%" __
QUERY ERROR!
Access denied for user 'root'@'localhost' (using password: NO)


SEARCH
__ 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 text_person as tp1 on letters.id=tp1.text_id and tp1.role="1" and tp1.text_type="letter" left join text_person as tp2 on letters.id=tp2.text_id and tp2.role="2" and tp2.text_type="letter" left join objects_persons as op1 on tp2.person=op1.id left join objects_persons as op2 on tp1.person=op2.id 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 (op1.sorting_form like "%" or op2.sorting_form like "%") 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!
Access denied for user 'root'@'localhost' (using password: NO)
No results found!