Fix query that removes location table

[alexgleith]

Reason for this pull request

See issue #1666

Proposed changes

• Do the query differently

  • [x] Closes #1666
  • [ ] Tests added / passed
  • [ ] Fully documented, including docs/about/whats_new.rst for all changes

---

📚 Documentation preview 📚: https://datacube-core--1667.org.readthedocs.build/en/1667/

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 16.66667% with 5 lines in your changes missing coverage. Please review.

Project coverage is 85.54%. Comparing base (009a9f2) to head (4c9e79b). Report is 1 commits behind head on develop-1.9.

Files with missing lines	Patch %	Lines
...sions/d27eed82e1f6_remove_datasetlocation_table.py	16.66%	5 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## develop-1.9 #1667 +/- ## =============================================== - Coverage 85.56% 85.54% -0.02% =============================================== Files 143 143 Lines 15418 15422 +4 =============================================== + Hits 13192 13193 +1 - Misses 2226 2229 +3 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.