fenway

Guidance with what?

This topic has been moved to Application Design. http://www.phpfreaks.com/forums/index.php?topic=347816.0

What's not clear is if you want someone to write your script or if there's just one aspect that's presenting difficulty.

That doesn't answer the question

I don't understand the question -- just keep everything.

You can also order by the expression ( premium = 1 ).

Doesn't work How?

I don't believe you.

That doesn't answer the question.

You need to add: songs.yourDateField > NOW() - INTERVAL 10 DAY To the WHERE clause.

How come sta isn't 165?

That depends on how much of your data you want back if it crashes.

"previous row" has no meaning to a dataase.

Easy to check -- use LOCATE().

If you have an index on that field, then : SELECT `field` FROM `table` WHERE `datefield`>= 'YYYY-MM-DD'; Is better.

Well, replacing IN() with a JOIN is likely going to show improvement. Beyond that, I'll need to see EXPLAIN output.

Yup, the previous comments were correct -- you're dealing with a hierarchy here. If you would store the "depth" when you store the original data, life would be easy.

I'm sorry, you want to do what/

Why do you have "FROM" twice?

Well, the order by is redundant, since group by orders automatically -- and typically you'd use the aggregated value alongside the count, like so: SELECT hour( `datetime_added` ) AS addedHour , count(*) AS cnt FROM `requests` GROUP BY hour( `datetime_added` ) But they're functionally equivalent.

You can group by HOUR(yourDateField).

Read this.

If you have the solution, then post it. "nevermind" won't help anyone but you.

Nothing wrong with the line break -- but unless you're getting a mysql error, you have some other, non-DB problem.

Are you saying that you don't get back 2 records?