structure:
id
description
title
link
category
source
date
now I want to generate RSS feed from this table, wot I want to do is
lets assume there n,m,p rows for each source s1, s2,s3...
1. select 2 items from each source s(i)
2. complex side, select 2 items from s(1), select 3 items for s(2), select 5 items for s(3)
3. It should be the most recent RSS feed, the last one, if sources compiled once in half an hour
how do I do this???
I think
1. select all records by comparing each with other on time and prune the number of records with the recently generated records
2. from the result above I think again groupby statement anyway.
I can do all these by loops but I have to crack this in a single sql if possible...
suggestions appreciated