hi,
here is table description
report1
+-------------------------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default
| Extra |
+-------------------------+------------------+------+-----+---------------------+----------------+
| id | int(10) unsigned | | PRI | NULL
| auto_increment |
| host_id | int(10) unsigned | | MUL | 0
| |
| report_rcpt_domain_id | int(10) unsigned | YES | MUL | NULL
| |
| report_sender_domain_id | int(10) unsigned | YES | MUL | NULL
| |
| report_ipaddress_id | int(10) unsigned | YES | MUL | NULL
| |
| time | datetime | | MUL | 0000-00-00 00:00:00
| |
| detected_spam | int(10) unsigned | | | 0
| |
| detected_virus | int(10) unsigned | | | 0
| |
| processed | int(10) unsigned | | | 0
| |
| allowed | int(10) unsigned | | | 0
| |
| suspected | int(10) unsigned | | | 0
| |
| blocked | int(10) unsigned | | | 0
| |
| spam | int(10) unsigned | | | 0
| |
| virus | int(10) unsigned | | | 0
| |
I WANT REPORT LIKE FOLLOWINGS
date sender processed spam suspected
I want top 10 spam sender each day.
QUery i'm using
select date_format(time,'%Y-%d-%m'),report_sender_domain_id,processed ,spam
from report1
order by spam desc ,report_sender_domain_id,date_format(time,'%Y-%d-%m') limit
10;
Please suggest.
thanks
---------------------------------
Discover Yahoo!
Find restaurants, movies, travel & more fun for the weekend. Check it out!
