SELECT type, text, date FROM tableA GROUP BY CAST(date AS DATE) ORDER BY date DESC, id DESC LIMIT 5
I want to be able to select all rows (most recent days first), but limit the number of previous days to a certain amount (i.e. last 5 days with rows).
So if I had TableA with 10 days with 100 records in each day and TableB with 100 days with 10 records in each day, the result will be TableA will have 500 results (5 days with 100 records each), and TableB will have 50 results (5 days with 10 records each).
Hope that makes sense.