SELECT Property.PropertyID, Property.Name, BTAT.Action as Status, BTAT.Total, BTAT.BookingID, DateTimeCreatedRealtime
FROM BookingTotalAuditTrail as BTAT
LEFT JOIN Booking ON Booking.BookingID=BTAT.BookingID
LEFT JOIN PropertyBooking ON BTAT.BookingID=PropertyBooking.BookingID
LEFT JOIN Property ON PropertyBooking.PropertyID=Property.PropertyID
WHERE (PropertyBooking.PropertyID IN(25)) AND (DateTimeCreatedRealTime BETWEEN CAST('2018-02-13 00:00:00' as datetime) AND CAST('2018-02-14 23:59:59' as datetime))
ORDER BY DateTimeCreatedRealtime DESC

PropertyID  Name                    Status      Total BookingID DateTimeCreatedRealTime
25          Beach Resort & Villas   Modified    543   747890    2018-02-13 09:56:40
25          Beach Resort & Villas   Modified    499   747890    2018-02-13 09:56:21
25          Beach Resort & Villas   Modified    499   747890    2018-02-13 09:56:19
25          Beach Resort & Villas   New         277   747890    2018-02-13 09:56:09

PropertyID  Name                    Status      Total BookingID DateTimeCreatedRealTime
25          Beach Resort & Villas   Modified    543   747890    2018-02-13 09:56:40
25          Beach Resort & Villas   New         277   747890    2018-02-13 09:56:09

GROUP BY Property.PropertyID, Property.Name, BTAT.Action, BTAT.BookingID