As far as I’m aware, multiple tags can be searched but it is way too cumbersome. Wildcards can be used (*) to search for multiple tags but depends on the user knowing beforehand the order in which tags are added to org-db (tag order in completion entries are displayed in reverse order to tags in headings).
Tag searches should be orderless. It shouldn’t be necessary to search
*#here*#tag with the knowledge of the order in which tags are stored internally, in order to find
some_node #here #are #the #tags. Have I been living under a rock and are there any solutions to this problem?