const consultant = await consultantRepository .createQueryBuilder() .select([ ‘consultant.created_at’, ‘consultant.id’, ‘consultant.department’, ‘consultant.specialization’, ‘consultant.bmdc_no’, ‘consultant.experience’, ‘consultant.bio’, ‘consultant.degrees’, ‘consultant.fee’, ‘consultant.average_rating’, ‘consultant.patient_treated’, ‘consultant.status’, ‘review.id’, ‘review.rating’, ‘review.comment’, ‘review.created_at’, ]) .from(Consultant, ‘consultant’) .where(‘consultant.id = :id’, { id }) .andWhere(‘consultant.status = :status’, { status: ‘active’ }) .leftJoin(‘consultant.review_consumed’, ‘review’) .orderBy(‘review.created_at’, ‘DESC’) .take(1) .getOne() Suppose there are seven rows with oneToMany relationship with review_consumed […]