4pm backup -- Query for report && print

Report && Prints

SELECT DISTINCT p.idList, p.ListRef, p.AddressLine1, p.Postcode, p.Description, p.idPropMarket, t.Id, d.DistrictName, c.CountyCityName,bl.TotalRooms, p.PriceVal, f.FrequencyName, pt.PTypeName, pp.PicPath, pp.PicName, l.LTypeName, lcl.OccasionalWeekends, lcl.WeekendPrice,lc.idLetCategory, s.StatusName, p.DisplayAddress, (SELECT TOP 1 OfferPrice FROM [findahome].[dbo].PropOfferPrice WHERE idList = p.idList ORDER BY OfferPrice DESC) AS 'OfferPrice' 
FROM [findahome].[dbo].Property p
JOIN [findahome].[dbo].PropertyType pt ON p.idPType = pt.idPType
JOIN [findahome].[dbo].Frequency f ON p.idFrequency = f.idFrequency
JOIN [findahome].[dbo].District d ON p.idDistrict = d.idDistrict
JOIN [findahome].[dbo].CountyCity c ON p.idCountyCity = c.idCountyCity
JOIN [findahome].[dbo].LivingType l ON p.idLType = l.idLType
JOIN [findahome].[dbo].PropStatus s ON p.idPropStatus = s.idPropStatus
JOIN [findahome].[dbo].[Property.Tag] ptt ON p.idList = ptt.[Property.Id]
JOIN [findahome].[dbo].Tag t ON t.Id = ptt.[Tag.Id]
LEFT OUTER JOIN [findahome].[dbo].BedroomList bl ON p.idList = bl.idList
LEFT OUTER JOIN [findahome].[dbo].PropertyPicture pp ON p.idList = pp.idList AND pp.Thumbnail = 1
LEFT OUTER JOIN [findahome].[dbo].LetCategoryList lcl ON p.idList = lcl.idList 
LEFT OUTER JOIN [findahome].[dbo].LetCategory lc ON lcl.idLetCategory = lc.idLetCategory 
WHERE
p.idPropMarket = 3 AND p.idCreatedBy = 31980