Liczba odwiedzin: 9
» Korpus Tekstów Łacińskich Jana Dantyszka
Copyright © Pracownia Edytorstwa Źródeł i Humanistyki Cyfrowej AL UW

Wszelkie prawa zastrzeżone. Zabrania się kopiowania, redystrybucji, publikowania, rozpowszechniania, udostępniania czy wykorzystywania w inny sposób całości lub części danych zawartych na stronie Pracowni bez pisemnej zgody właściciela praw.

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)


WYSZUKIWANIE
__ 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="1116" 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)
Nie znaleziono rekordów pasujących do podanych kryteriów!