MySQL Error!
------------------------
The Error returned was:
Out of memory (Needed 2095408 bytes)
Error Number:
5
SELECT p.category, COUNT(p.category) AS cnt,(select count(*) from a8140612__post pp where pp.category=p.category and date(pp.date)=curdate()) as curdatecnt FROM a8140612__post p WHERE p.approve = 1 AND p.date<=NOW() GROUP BY category