The deal is as follows:

Lets say I have 2 tables, Articles and Projects. The share some columns but are substantially different beasts. 

I need to grab the 7 most recently published of either Articles or Projects. Then, even more frustratingly, I'm going to want to grab the next 7, and then again the next 7 with a provided offset.

What's the best course of action? Is there way to query the DB in such a way as to return an amalgamated result set that'll allow me to easily offset by 7 to grab the next 7? There's gotta be something more clever than, say, keeping track of the createdAt date or some other malarky.