Using Az resource list to select web apps returns duplicates

## Describe the bug
Running az resource list will return duplicate results for web apps, and Azure SQL resources. Tried filtering results by name, and found that it returned results with the same ID.

**Command Name**
`az resource list`

## To Reproduce:
Steps to reproduce the behavior. Note that argument values have been redacted, as they may contain sensitive information.

- use `azd init`
- deploy `csharp-todo-sql`
- then run
```
az resource list -g {} --query "[? tags.\`"azd-service-name\`" == 'web' ].name"
```

## Actual Behavior
Two web apps are returned
```
[
"app-web-i4ugtihr2mwwm",
"app-web-i4ugtihr2mwwm"
]
```

## Expected Behavior
Single web app is returned

## Environment Summary
```
Windows-10-10.0.22621-SP0
Python 3.10.8
Installer: MSI

azure-cli 2.44.1
```
## Additional Context