SELECT openhouse.*,UnparsedAddress AS AddressDisplay,City,StateOrProvince,PostalCode,property.ListingId AS MLSNumber,DATE_FORMAT(`OpenHouseDate`,'%M %d %Y') AS OHDate FROM redbpillar9.openhouse,redbpillar9.property WHERE openhouse.ListingKeyNumeric=property.ListingKeyNumeric AND OpenHouseStartTime >= NOW() AND property.SubdivisionName='Franklin' group by property.ListingKeyNumeric LIMIT 6