SELECT tbl_propertyDetail.*, link.url as aLink, link.title as aTitle, concat(tbl_user_rentals.FirstName,' ',tbl_user_rentals.LastName) user,tbl_user_rentals.Email,tbl_user_rentals.Phone,tbl_user_rentals.CellPhone FROM tbl_propertyDetail left join link on (link.id = tbl_propertyDetail.availability_link_id) inner join tbl_user_rentals on tbl_user_rentals.user_id=tbl_propertyDetail.user_id WHERE  tbl_propertyDetail.building_id=(select primary_id from building where directory like '1935haro') and  tbl_propertyDetail.isActive=1 and tbl_propertyDetail.expiry_date > '2008-05-15' ORDER BY tbl_propertyDetail.property_id