select TAGS,GROUP_CONCAT(TAGS) t

 from EXCEPTION_RESULT e,PM_TASK t

        where e.TASK_ID='' and t.OWNER='admin'

        group by TAGS,TIMESTAMP

        order by e.TIMESTAMP DESC;

select GROUP_CONCAT(TAGS) IP,GROUP_CONCAT(TIMESTAMP) t from EXCEPTION_RESULT e,PM_TASK t

        where e.TASK_ID='' and t.OWNER='admin' and

        DATE_SUB(CURDATE(), INTERVAL

        6 DAY)<=date(TIMESTAMP)

        group by TAGS,left(TIMESTAMP, 10)

        order by e.TIMESTAMP

        DESC;

 select TAGS,count(TAGS) s,GROUP_CONCAT(TAGS) IP, TIMESTAMP t

 from EXCEPTION_RESULT e,PM_TASK t

        where e.TASK_ID='' and t.OWNER='admin' and

        DATE_SUB(CURDATE(), INTERVAL

        6 DAY)<=date(TIMESTAMP)

        group by TAGS,left(TIMESTAMP, 13)

        order by TAGS

        DESC;

SELECT * from EXCEPTION_RESULT

    WHERE TASK_ID='' AND TIMESTAMP LIKE '%2016-07-07 11%' AND TAGS='10.62.45.9';

SELECT COUNT(TAGS),TIMESTAMP from EXCEPTION_RESULT

    WHERE TASK_ID='' AND TIMESTAMP LIKE '%2016-07-07 12%' AND TAGS='10.62.45.9';

SELECT COUNT(TAGS),TIMESTAMP from EXCEPTION_RESULT

    WHERE TASK_ID='' AND TIMESTAMP LIKE '%2016-07-07 13%' AND TAGS='10.62.45.9';

SELECT COUNT(TAGS),TIMESTAMP from EXCEPTION_RESULT

    WHERE TASK_ID='' AND TIMESTAMP LIKE '%2016-07-07 14%' AND TAGS='10.62.45.9';

SELECT COUNT(TAGS),TIMESTAMP from EXCEPTION_RESULT

    WHERE TASK_ID='' AND TIMESTAMP LIKE '%2016-07-07 15%' AND TAGS='10.62.45.9';

 select TAGS,count(TAGS) s, TIMESTAMP

 from EXCEPTION_RESULT e,PM_TASK t

        where e.TASK_ID='' and t.OWNER='admin' and

        date(TIMESTAMP) >=DATE_SUB(CURDATE(), INTERVAL 4 DAY)

        group by TAGS,left(TIMESTAMP, 13)

        order by TAGS

        DESC;

SELECT DATE_SUB(CURDATE(), INTERVAL 8 DAY);