SELECT `rental_application`.`id` as `app_id`, `rental_application`.`cancel_status`, `rental_application_reservation`.*, `rental_application_reservation`.`id` as `reserv_id`, `rental_application`.`request_to_user_id` as `app_request_to_user_id`, `rental_application_reservation`.`contract_arrival_date` as `contract_arrival_date`, `rental_application_reservation`.`contract_departure_date` as `contract_departure_date`, `users`.`id` as `tenant_id`, `users`.`first_name` as `tenant_f_name`, `users`.`last_name` as `tenant_l_name`
FROM `rental_application`
LEFT JOIN `rental_application_reservation` ON `rental_application`.`id` = `rental_application_reservation`.`application_id`
JOIN `users` ON `rental_application`.`request_to_user_id` = `users`.`id`
WHERE `rental_application`.`request_for_property_id` = '16658'
AND `rental_application`.`is_admin_approved` = 'y'
AND `rental_application_reservation`.`is_archived` = 0
AND ( date(rental_application_reservation.departure_date) >= CURRENT_DATE() OR date(rental_application_reservation.contract_departure_date) >= CURRENT_DATE())
GROUP BY `rental_application`.`id`
ORDER BY `rental_application`.`id` DESC
 LIMIT 3<br>