Visits: 7
» Corpus of Ioannes Dantiscus' Latin Texts
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 "%" and ( exists (select tp2.text_id from text_person as tp2, letter_languages, text_person as tp1 where tp2.person=objects_persons.id and tp1.text_id=tp2.text_id and letter_languages.idl=tp2.text_id and letter_languages.language="1" and tp1.person="1" and tp1.role="1" and tp2.role="2" and tp1.text_type="letter" and tp2.text_type="letter") ) __
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 tp on letters.id=tp.text_id and tp.text_type="letter" and tp.role in ("1", "2") 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 exists (select * from text_person where text_person.person="1" and text_person.text_id=letters.id and text_person.role="1" and text_person.text_type="letter") and exists (select * from letter_languages where letter_languages.language="1" and letter_languages.idl=letters.id) and tp.person="3977" 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!