Need to perform ORDER by Twice

Does

[rest of query] order by date, id

work?

This should work:

SELECT * FROM Table
ORDER BY date, id;

SELECT FIELD1, FIELD2 FROM TABLE ORDER BY FIELD1 ASC, FIELD2 ASC

A good tutorial on this SQL ORDER BY