Query : select max(redsticker) maxpoint , to_days(regdate) as date from art where adult = 'N' and regdate >= '2012-02-01 00:00:00' and regdate <= '2012-02-31 23:59:59' group by to_days(regdate) order by redsticker desc;
[range/Using where; Using temporary; Using filesort]:idx_reg in idx_reg (54)
: 1 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 83] : /home1/www/dev/pages/dailybest.php

Query : select * from art where ( adult = 'N' and (to_days(regdate)=734910 and redsticker=200) or (to_days(regdate)=734904 and redsticker=100) or (to_days(regdate)=734915 and redsticker=100) or (to_days(regdate)=734909 and redsticker=200) or (to_days(regdate)=734906 and redsticker=200) or (to_days(regdate)=734907 and redsticker=0) or (to_days(regdate)=734913 and redsticker=0) or (to_days(regdate)=734914 and redsticker=0) or (to_days(regdate)=734916 and redsticker=0) or (to_days(regdate)=734920 and redsticker=0))
[ALL/Using where]: in idx_redsticker (37276)
: 419.2 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 96] : /home1/www/dev/pages/dailybest.php

Most popular arts are displayed in this section. Hit count , recommends and comments account for the popularity. 2012.02
SUN	MON	TUE	WED	THU	FRI	SAT
			1	2	3	4
5	6 악마	7	8 hyena flower	9 토파쥬 캐릭터 일러스트	10	11 lion guitar
12 웃어줘요 포스터	13	14	15 공모전응모	16 blackhole	17 여신	18 모로
19	20	21	22 girl	23	24	25
26	27	28	29