The Newest that have not yet hoisted or Raw links via spider...
Group by limit per group in PostgreSQL – Charles Nagy | charlesnagy.info
In web applications it’s very common to try to limit the results by group. For example showing all the new posts with the the two latest comments on them. Or have the best selling categories in an e-commerce website showing the 3 most popular products in those categories. In PostgreSQL you can do that in a single query.
Article DataBase Charles Nagy 1

Featured Contributors

Install the Toplog Bookmarklet to submit page with a single click. To Install, Just Drag or Right Click the below Link to bookmark it:
Post to Toplog Bookmarklet