I am having problems with a alias.

Can someone shed some light on this for me?

SELECT 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

INNER JOIN ticket_history ON ticket_state.id

WHERE ticket_state.id.create_time = 1 > ticket_state.id.create_time = 2

AND ticket_state.id.create_time=10 > ticket_state.id.create_time = 2

AND ticket_state_id IN (1,4,6,11,12,13,14,15,16,17,18,23,24)

AND freetext7 = 'small'

AND MONTH(ticket_history.create_time) =7

AND YEAR(ticket_history.create_time) =2014

ORDER BY `ticket`.`tn` ASC