optimize query (4 subqueries)

[tail]

Is there a way to optimize this query so I don't have to use so many subqueries?

SELECT COUNT( hits ) AS `unique` , SUM( hits ) AS `total` , (

SELECT SUM( `hits` )
FROM `stats`
WHERE `date` > UNIX_TIMESTAMP( ) -86400
) AS `today` , (

SELECT SUM( `hits` )
FROM `stats`
WHERE `date` > UNIX_TIMESTAMP( ) -604800
) AS `week` , (

SELECT SUM( `hits` )
FROM `stats`
WHERE `date` > UNIX_TIMESTAMP( ) -2419200
) AS `month` , (

SELECT COUNT( * )
FROM `stats`
WHERE `online` > UNIX_TIMESTAMP( ) - '600'
) AS `online`
FROM `stats` 

 

Thanks in advance!

[fenway]

Not really... there's no simple way to combine them.

[tail]

Ok thanks anyways!