How to generate multiple listing pages???

which files do you need to copy to manually or otherwise generate multi listing pages based of sql query??