How do I turn a single query result into a Category/Products listing?

Have a look at