franchisenumber like 'NLOH0004.1%' and newused = 'n' and tnl_deleted <> 'Y' and year > 0 and make <> 'toyota' and make <> 'scion'