If you want to take this right back to basics put the query in a separate cfm file and call it into the page(s) your needing it in with <cfinclude />. Then just call it on your other page like it exists with everything else.
That's a REALLY old way of doing things though (going back to version 5 of CF and below) and isn't very modular.
If you want to go with "Best Practice" then the query should be placed in a CFC and that called into each of your pages when needed:
The advantages of CFCs if you can modularise your code into "blocks" so it makes it easier to manage as your application grows.