Did you think of using $dbr->selectRow here? I know that join is possible to perform, I'm not sure about force index.