Adrian,
Use:
city "Manchester" AND (path ^"/Volumes/Archive 01/" OR path ^"/Volumes/Archive 02/" OR path ^"/Volumes/Archive 03/")
Or you may find the Filter system easier. You could create a Folder Path filter, selecting the three paths (command-click them). Then a IPTC->Location (Legacy)->City filter and select Manchester.
-Kirk