SELECT date,view FROM `blog` order by date DESC limit 20

    date          view
    2011/08/16    18
    2011/08/15    134
    2011/08/15    20
    2011/08/13    800
    ...

SELECT date,view FROM `blog` order by date DESC, view DESC limit 20


    date          view
    2011/08/16    18
    2011/08/15    134
    2011/08/15    20
    2011/08/13    800

date          view
2011/08/13    800
2011/08/15    134
2011/08/15    20
2011/08/16    18

SELECT x.date, x.view FROM (SELECT date,view FROM `blog` order by date DESC limit 20) as x order by view DESC

SELECT `date`,`view` FROM `blog` ORDER BY `view` DESC, `date` DESC LIMIT 20