I have a customer who wants a special sort of data.

They have categories of products like so.

By default its sorted like this

Animals, accessories, misc, mindblowing

What they want is, always have accessories and misc at the end like, Animals, Mindblowing, Accessories, Misc

Accessories and Misc always have a groupcode of 98 and 99

Is it possible or should a use a second query and then union the result?