Дипломы олимпиады ПГУ

SELECT entrant.surname || ' ' || entrant.name AS "ФИО",
faculty.name AS "Факультет",
speciality.name AS "Специальность",
(SELECT subject.name FROM subject, prof_subject
WHERE subject.id = prof_subject.subject_id
AND prof_subject.allset_id = allset.id LIMIT 1) AS "Предмет",
split_part(documents.data, '#', 2) AS "Место",
split_part(documents.data, '#', 1) AS "ДипломОлимпиадыПГУ"
FROM entrant, documents, allset, speciality, faculty
WHERE entrant.id = documents.entrant_id
AND documents.list_documents_id = 48
AND entrant.allset_id = allset.id
AND allset.speciality_id = speciality.id
AND speciality.faculty_id = faculty.id