SELECT r.GrossArea,r.LandArea, r.Bathrooms, r.Rooms, r.InteriorRooms, r.Name ,r.Views, r.Exclusive, r.Reference, r.RealestateStatusIDName,r.GPSLat, r.GPSLon, r.ID, r.NettArea, r.Description,r.BrokerID,r.LocationIDName, rb.BusinessTypeIDName, rb.Price ,r.HasPriceUnderAppreciation,r.ExportAddress, r.ExportGeoreference, m.Format, m.UID,ed.PersonalContactEmailSearch,rb.CurrencyIDName, rb.SquareMetre, ed.PersonalContactPhoneSearch
FROM realestate r
INNER JOIN realestate_portal rp
ON r.ID = rp.RealestateID AND rp.PortalIDName = 'Web Page'
LEFT JOIN realestate_business_type rb
ON r.ID = rb.RealEstateID
LEFT JOIN media m
ON m.ID = r.FirstMediaID
LEFT JOIN entity_data ed
ON ed.EntityID = r.BrokerID
where 1=1 AND ((r.NatureTypeIDName IN ('Attic') )) AND r.RealestateStatusIDName != 'Withdrawn' ORDER BY r.CreateDate DESC LIMIT 0 , 15