@Service("readersService")
@Repository
@Transactional
public class ReadersServiceImpl implements ReadersService 
..................................
    @PersistenceContext
    protected EntityManager entityManager;

    public List<ReaderDto> findReaders(ReaderDto readerDto) {

        List<ReaderDomain> listOfReaderRecords;
        StringBuilder sb = new StringBuilder();
        sb.append("select * from reader where ");
        if (readerDto.getId() != null) {
            sb.append("id=").append(readerDto.getId()).append(";");
        } else {
            if (readerDto.getLastName() != null)
                sb.append("lastName like '%").append(readerDto.getLastName()).append("%' ");
            if (readerDto.getFirstName() != null)
                sb.append("firstName like '%").append(readerDto.getFirstName()).append("%' ");
            if (readerDto.getPhone() != null)
                sb.append("phone like '%").append(readerDto.getPhone()).append("%' ");
            if (readerDto.getAddress() != null)
                sb.append("address like '%").append(readerDto.getAddress()).append("%'");
            sb.append(";");
        }

        TypedQuery<ReaderDomain> query = entityManager.createQuery(sb.toString(), ReaderDomain.class);
        listOfReaderRecords = query.getResultList();

        List<ReaderDto> listOfReaders = new ArrayList<>();

        for (ReaderDomain readerDomain : listOfReaderRecords)
            listOfReaders.add(new ReaderDto().convertToDto(readerDomain));

        return  listOfReaders;
    }

SELECT * FROM literarywork l WHERE l.literaryWorkName LIKE '%i%' and l.literaryWorkId = 
(select w.literaryWorkId FROM writerofliterarywork w WHERE w.literaryWorkId = l.literaryWorkId AND 
w.authorId IN ( SELECT authorId FROM writer wr WHERE wr.firstName like '%s%' AND  wr.lastName like '%z%'));