This code works except for the DISTINCT. Please note from earlier posts this is MYSQL.

Also how can I create a create to run for every month to get a count?

SELECT DISTINCT ticket.tn, ticket.id, ticket_history.ticket_id, ticket_history.state_id, ticket_history.create_time, MONTH( ticket_history.create_time ) , YEAR( ticket_history.create_time )

FROM `ticket`

INNER JOIN ticket_history ON ticket.id = ticket_history.ticket_id

WHERE ticket_history.state_id =2

AND freetext7 = 'small'

AND MONTH( ticket_history.create_time ) =1

AND YEAR( ticket_history.create_time ) =2014

ORDER BY `ticket`.`tn` ASC