BUG: AND condition with multiple tags #164
Description
Page frontmatter allows for multiple tags, so #project and #status/backlog. Running the query below returns zero results, where rows are expected. Removing either condition returns the correct number of rows.
SELECT files.*
FROM files JOIN tags ON files.path=tags.path
WHERE tag = '#project' and tag = '#status/backlog'
Using 0.37.0, Obsidian 1.8.10.