Greater Louisville Home Guide

GO:SELECT * FROM acshowcasehomes INNER JOIN logincredentials ON acshowcasehomes.clientID = logincredentials.loginID INNER JOIN companies ON logincredentials.companyID = companies.companyID INNER JOIN cities ON acshowcasehomes.city = cities.cityID INNER JOIN counties ON acshowcasehomes.county = counties.abb WHERE acshowcasehomes.Status <> 'Pending' AND rundate = '12/26/2008';