select contentproviderid, contentprovidername, productid, productname, visit, [view], [date]
from wap_free_log_2009 a
where a.date >= '20090803'and a.date <= '20090807'
order by a.date, a.[view] desc
from wap_free_log_2009 a
where a.date >= '20090803'and a.date <= '20090807'
order by a.date, a.[view] desc