Query : select max(redsticker) maxpoint , to_days(regdate) as date from art where adult = 'N' and regdate >= '2012-3-01 00:00:00' and regdate <= '2012-3-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 (43)
: 1.2 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)=734950 and redsticker=0) or (to_days(regdate)=734951 and redsticker=0) or (to_days(regdate)=734952 and redsticker=0) or (to_days(regdate)=734955 and redsticker=0) or (to_days(regdate)=734956 and redsticker=0) or (to_days(regdate)=734957 and redsticker=0) or (to_days(regdate)=734928 and redsticker=0) or (to_days(regdate)=734930 and redsticker=0) or (to_days(regdate)=734932 and redsticker=0) or (to_days(regdate)=734939 and redsticker=0) or (to_days(regdate)=734942 and redsticker=0) or (to_days(regdate)=734947 and redsticker=0) or (to_days(regdate)=734948 and redsticker=0) or (to_days(regdate)=734949 and redsticker=0))
[ref/Using where]:idx_redsticker in idx_redsticker (18619)
: 276 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.3
SUN	MON	TUE	WED	THU	FRI	SAT
				1 낙서	2	3 [감탄사] 아,갈라진 틈새를 메꾸려는환희의 조각.말로는 표현할 수 없는표현의 발현.... 감탄사
4	5 [비 내리는 도시] 비내리는도시. 그 회색빛 색조.모두가 같은얼굴, 모두가 같은우산.정해진 ... 비 내리는 도시	6	7	8	9	10
11	12 자연인 그림	13	14	15 Struggle for pleasur...	16	17
18	19	20 가스마스크	21 킹오브파이터즈 / 메탈슬러그 xx 캐...	22 BBA	23 밀림속으로	24 Brooch-2
25 마다가스카의 펭귄 손그림 팬아트	26	27	28 흑발	29 긴머리	30 해골	31