   select
         count(sr.name),
         sr.name
   from ticket_history as th, standard_response as sr
   where
         th.name like 'ResponseTemplate%' and
         sr.id = LEFT(TRIM(LEADING 'ResponseTemplate (' FROM
th.name),LOCATE('/',TRIM(LEADING 'ResponseTemplate (' FROM th.name))-1)
         and DATE_SUB(CURDATE(),INTERVAL 60 DAY) <= th.create_time
   group by
         sr.name
   order by
         sr.id;