sql="SELECT SUM(c_count) as cnum FROM f_counter_day WHERE c_date="&mydate&" and c_cata = 1 group by c_ip"
sql="select cnum from (SELECT cnum=SUM(c_count) FROM f_counter_day group by c_ip)aa where c_date='"& mydate &"'"
sql="select sum(a.c_count) as cnum,a.c_ip from (" sql=sql & "select c_count,c_ip from f_counter_day where c_date='" & mydate & "') a"sql=sql & " group by a.c_ip
sql="select sum(a.c_count) as cnum,a.c_ip from ("
sql=sql & "select c_count,c_ip from f_counter_day where c_date='" & mydate & "') a"sql=sql & " group by a.c_ip