Bug 1845238 may help with this -- it adds a link from holds to the hold copy map, which appears to be required to implement your SQL query via the reporter.
Bug 1845238 may help with this -- it adds a link from holds to the hold copy map, which appears to be required to implement your SQL query via the reporter.